Import Sets Flashcards
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
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
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.
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.
CSAP0413 ( Category: Import Sets )
Can we coalesce multiple fields?
True
False
✓Answer:
True
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
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.
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
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
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
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
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
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
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
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