Importing Data

Question 1

Which of the following should you do before importing data into ServiceNow? More than one response may be correct.
A. Understand the data you plan to import
B. Play fetch with your dog
C. Decide what to do with incomplete or erroneous data
D. Determine which source data maps to which target fields
E. Delete all the existing target table records to avoid conflicts

Answer 1

A. Understand the data you plan to import
C. Decide what to do with incomplete or erroneous data
D. Determine which source data maps to which target fields

Question 2

True or False? Assuming you do not want to create duplicate records when importing data, all duplicate records should be removed from the import source before importing.

Answer 2

False

Question 3

Which of the following are possible data sources for importing data into ServiceNow? More than one response may be correct.
A. CSV
B. TXT
C. JDBC
D. XML
E. HTTP

Answer 3

A. CSV
C. JDBC
D. XML
E. HTTP

Question 4

Which one of the following best describes the data import process?
A. Use a Transform Map to move data from the data source to the staging table. Verify the data integrity then move the records to the target table.
B. Load the records from the data source into the target table using a Transform Map then verify the data integrity.
C. Copy the data source records into a staging table. Copy the records from the staging table to the target table using a Transform Map only if the field names are different between the two tables. Verify the data integrity.
D. Load data from the data source into a staging table. Use a Transform Map to move data from the staging table fields to the target table fields then verify the data integrity.
E. Load the records from the data source into the staging table using a Transform Map then verify the data integrity.

Answer 4

D. Load data from the data source into a staging table. Use a Transform Map to move data from the staging table fields to the target table fields then verify the data integrity.

Question 5

Which one of the following best describes a Transform Map?
A. Matches columns from the data source to columns in the target table
B. Determines which data source columns are important for the import
C. Imports date fields when there is a format mismatch
D. Uses scripts to remove or correct records that were mistakenly imported
E. Matches columns from the staging table to columns in the target table

Answer 5

E. Matches columns from the staging table to columns in the target table

Question 6

Which of the following are true when a data source does not have columns or values for mandatory target table fields? More than one response may be correct.
A. The records are imported to the target table
B. The records cannot be imported to the target table
C. The records can be imported if the mandatory fields are not mapped
D. The records can be imported if the mandatory fields are mapped
E. The records are imported if all mandatory fields are mapped

Answer 6

All responses can be correct. What happens during an import when mandatory fields do not have values depends on the Enforce mandatory fields Transform Map configuration option. Records are imported when the criteria from the Enforce mandatory fields option is met: mandatory field values are not required, mapped field values are required, or all mandatory fields must have values. If the Enforce mandatory fields option criteria is not met, records are not imported.

Question 7

Which of the following are true statements about importing data into ServiceNow?
A. Every Transform Map must have at least one coalesce field
B. Every import must have at least one Transform Map
C. Every staging table can be used once
D. Every application has one staging table
E. Every date field has to be mapped

Answer 7

B. Every import must have at least one Transform Map

Question 8

Which of the following are possible outcomes when coalescing detects a match between a record in the staging table and a record in the target table?
A. Create duplicate records
B. Halt the import and ask the user what to do
C. Keep the record already in the target table
D. Overwrite the record in the target table with the source data
E. Stop the import and delete the previously imported records

Answer 8

C. Keep the record already in the target table

D. Overwrite the record in the target table with the source data

Question 9

Transform Event Scripts use server-side scripts to modify a transform’s behavior. When is Transform Event Script logic executed? More than one response may be correct.
A. When data is loaded from the data source into the staging table
B. When a user launches a transform
C. When Transform Maps are saved
D. When an import starts and before any staging table records are imported
E. When a record is about to be transformed

Answer 9

D. When an import starts and before any staging table records are imported
E. When a record is about to be transformed