Import Sets

Question 1

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

Question 2

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

Question 3

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.

Question 4

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.

Question 5

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

True
False

✓Answer:
True

Question 6

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

Question 7

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.

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Any table
cmdb_ci
Problem
Incident

✓Answer:
Any table

Question 17

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

Question 18

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

Question 19

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:

Question 20

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)

Question 21

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

Question 22

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

Question 23

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

Import Set
Transform Map

✓Answer:

Question 24

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

Question 25

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:

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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