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
CSAP0990 ( Category: Import Sets )
Which tables can be a target in a transform map?
Any table
cmdb_ci
Problem
Incident
✓Answer:
Any table
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
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
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:
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)
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
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
CSAP1661 ( Category: Import Sets )
Name and Source table are set based on the label which was assigned to the _____ _____.
Import Set
Transform Map
✓Answer:
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
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:
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
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
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
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
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
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
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
