Import Sets Flashcards

1
Q

CSAP0313 ( Category: Import Sets )
Which of the following is a definition for Transform Maps in ServiceNow?

A Map that is used to share the history of an incident
A Map used to add data to encrypt fields
A map used to trigger business rules before the data is queued in the outbound web service
A map to determine relationships between fields displaying in an import set to fields in an existing table

✓Answer:
A map to determine relationships between fields displaying in an import set to fields in an existing table

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

CSAP0377 ( Category: Import Sets )
Which option allows you to update existing Target Table records when importing data from an import set?

Transform
Mandatory
Coalesce
Unique

✓Answer:
Coalesce

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

CSAP0405 ( Category: Import Sets )
How does automating in a Transform Map work?

It takes the names of import set table heading and matches it against the existing column field name.
It takes the import set table heading and matches it against the existing column name.
It takes the import set column name and matches it against the existing table heading.

✓Answer:
It takes the names of import set table heading and matches it against the existing column field name.

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

CSAP0410 ( Category: Import Sets )
What does specifying a coalesce mean?

It’s a special data set brought over using a different module.
Make the report that will feed the gauge.
The field or fields you specify will be used as a unique key.
None of the above.

✓Answer:
The field or fields you specify will be used as a unique key.

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

CSAP0413 ( Category: Import Sets )
Can we coalesce multiple fields?

True
False

✓Answer:
True

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

CSAP0428 ( Category: Import Sets )
What does ‘Coalesce’ field mean?
Field/s will be set a reference key
Field/s will bind with target table
Field/s will be set a unique key

✓Answer:
Field/s will be set a unique key

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

CSAP0449 ( Category: Import Sets )
What happens if a match is found with the field that’s been marked coalesce?

It is one record in the sys_user_role table; and, it’s a personal that is assigned to a group or person, i.e., grant access and assign security controls.
The existing record will be updated with the new information.
The existing record will not be updated with the new information.
All of the above
None of the above

✓Answer:
The existing record will be updated with the new information.

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

CSAP0469 ( Category: Import Sets )
What is used to import data from data sources, then map data into tables?

Transform Map
Coalesce
Target Table
Import Set

✓Answer:
Import Set

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

CSAP0518 ( Category: Import Sets )
What is the configuration where duplicate records are created if the import executes again?

No Coalesce
Single-Field Coalesce
Multiple-Field Coalesce
Conditional Coalesce

✓Answer:
No Coalesce

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

CSAP0519 ( Category: Import Sets )
What is the option allowing you to update existing Target Table records when importing data?

Transform
Mandatory
Unique
Coalesce

✓Answer:
Coalesce

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

CSAP0848 ( Category: Import Sets )
In what type of coalesce are source scripts defined to match the sys_id of the target field?

Using Multifunctional coalesce
Using Multiple field coalesce
Using Conditional coalesce
Using Single field coalesce
Not using coalesce

✓Answer:
Using Conditional coalesce

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

CSAP0886 ( Category: Import Sets )
Select one of the below characteristics of importing data into ServiceNow.

Same Transform Map can be used for multiple import sets
Only one Transform Map can be used per import set

✓Answer:
Same Transform Map can be used for multiple import sets

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

CSAP0944 ( Category: Import Sets )
What tool is used to create relationships between fields in an import set and an existing table?

Target Table
Transform Map
Coalesce
Import Set
Import Map

✓Answer:
Transform Map

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

CSAP0962 ( Category: Import Sets )
What happens when more then one record in the target table matches the coalesce options?

No Target records are updated and the transform fails with an error
Only the first matching record in the target table is updated with values from the import set
All matching target records are updated with values from the import set

✓Answer:
Only the first matching record in the target table is updated with values from the import set

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

CSAP0963 ( Category: Import Sets )
Select a true statement from below related to Mapping Assist utility.

Auto matching import set fields with target table fields
To visually and manually map import set fields with target table fields

✓Answer:
To visually and manually map import set fields with target table fields

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

CSAP0990 ( Category: Import Sets )
Which tables can be a target in a transform map?

Any table
cmdb_ci
Problem
Incident

✓Answer:
Any table

A
17
Q

CSAP1005 ( Category: Import Sets )
Which two roles are required to manage import sets?

admin_import
import_admin
import_set_admin
trasnform_admin
admin

✓Answer:
import_admin
admin

A
18
Q

CSAP1029 ( Category: Import Sets )
Which are the accepted file types for an Import?

Excel, CSS, HTML
HTML, CSS, JS
Excel, XML, CSV
Excel, CSS, HTML

✓Answer:
Excel, XML, CSV

A
19
Q

CSAP1650 ( Category: Import Sets )
Regarding Import Sets, select two options where you can import data from:

An inbound email actions
A local source file (i.e., XML, CSV, Excel)
System events
A network server by providing a path and authentication information

✓Answer:

A
20
Q

CSAP1651 ( Category: Import Sets )
Regarding Import Sets, select two options where you can import data from:

An inbound email actions
System event
An LDAP connection (Lightweight Directory Access Protocol)
A JDBC connection (Java™ database connectivity)

✓Answer:
An LDAP connection (Lightweight Directory Access Protocol)
A JDBC connection (Java™ database connectivity)

A
21
Q

CSAP1657 ( Category: Import Sets )
The imported _____ _____ is used to name the import set table the data will be loaded into.

File label
naming convention
File name
Coalesce condition

✓Answer:
File label

A
22
Q

CSAP1660 ( Category: Import Sets )
A single _____ _____ field can also be mapped to multiple fields on a Target Table.

Export Set
Import Set
Import Rule
Import Guide

✓Answer:
Import Set

A
23
Q

CSAP1661 ( Category: Import Sets )
Name and Source table are set based on the label which was assigned to the _____ _____.

Import Set
Transform Map

✓Answer:

A
24
Q

CSAP1667 ( Category: Import Sets )
Name the simplest mapping method is where all of the field names of the Import Set match the name of the fields on the target table where the data will be transformed.

Transform Map mapping
Automatic mapping utility
Map Designer
Mapping assist utility

✓Answer:
Automatic mapping utility

A
25
Q

CSAP1668 ( Category: Import Sets )
With the _____ _____ _____ it is possible to map a single source field (field on an Import Set table) to multiple destination fields (fields on a target table).

Mapping assist utility
Transform Map mapping
Automatic mapping utility

✓Answer:

A
26
Q

CSAP1669 ( Category: Import Sets )
Regarding Import Sets, if there are any discrepancies in terms of how fields were automatically matched, these can easily be corrected using the _____ _____ _____.

Automatic mapping utility
Mapping assist utility

✓Answer:
Mapping assist utility

A
27
Q

CSAP1672 ( Category: Import Sets )
The conversion of data from an import set table to its target table according to the _____ _____ in the transform map.

Rules defined
Rules labeled
Import set
Table definition

✓Answer:
Rules defined

A
28
Q

CSAP1678 ( Category: Import Sets )
The coalesce option on a field map allows you to specify if the selected _____ _____ should be used to coalesce on when import set records are transformed.

Target table
Target map
Target field
Target value

✓Answer:
Target field

A
29
Q

CSAP1686 ( Category: Import Sets )
To configure data policies, navigate to:

All > System Definition > Rules > Data Policies
All > System Policy > Rules > Data Policies
All > System Security > Rules > Data Policies
All > System Security > Data Policies

✓Answer:
All > System Policy > Rules > Data Policies

A
30
Q

CSAP1690 ( Category: Import Sets )
What should you use to ensure that a field (or a table) is fully inaccessible to users without a certain role or set of permissions?

ACLs
SLAs
Data Policies
UI Policies

✓Answer:
ACLs

A
31
Q

CSAP1694 ( Category: Import Sets )
To create a Transform Map, navigate to:

All > System Import Sets > Create Transform Map
All > Transform Maps > Create Transform Map
All > Import Sets > Create Transform Map
All > System Definition > Create Transform Map

✓Answer:
All > System Import Sets > Create Transform Map

A
32
Q

CSAP1695 ( Category: Import Sets )
To clean up the Import Set Table data, navigate to:

All > System Import Sets > Import Set Tables > Cleanup
All > Import Sets > Import Set Tables > Cleanup
All > System Definition > Import Set Tables > Cleanup
All > System Security > Import Set Tables > Cleanup

✓Answer:
All > System Import Sets > Import Set Tables > Cleanup

A