CSA Data Import and Management 2 — Questions and Answers
Question 1: What is the primary purpose of a Transform Map in ServiceNow data imports?
- To schedule recurring import jobs
- To map source fields to target table fields during import (Correct answer)
- To validate data before it enters the staging table
- To compress import files for faster upload
Correct answer: To map source fields to target table fields during import
A Transform Map defines how fields in the import set (staging table) map to fields in the target ServiceNow table.
Question 2: Which scripting field in a Transform Map runs logic before any row is transformed?
- onStart (Correct answer)
- onBefore
- onComplete
- onAfter
Correct answer: onStart
The onStart script runs once before processing begins, making it ideal for initialization logic.
Question 3: An import set source type of 'JDBC' allows ServiceNow to:
- Import files from an FTP server
- Connect directly to an external relational database (Correct answer)
- Read data from a REST web service
- Parse XML files from email attachments
Correct answer: Connect directly to an external relational database
JDBC data sources enable ServiceNow to connect directly to external relational databases using a database driver.
Question 4: What happens to records in an import set table after the transform is complete by default?
- They are automatically deleted after 7 days (Correct answer)
- They remain indefinitely until manually purged
- They are moved to the audit log
- They are immediately deleted upon successful transform
Correct answer: They are automatically deleted after 7 days
By default, import set records are cleaned up after 7 days, but this retention period is configurable.
Question 5: Which field on a Transform Map record controls whether duplicate records in the target table are updated or skipped?
- Coalesce field (Correct answer)
- Run business rules
- Force update
- Copy empty fields
Correct answer: Coalesce field
Coalesce fields act as match keys — if a target record with the same coalesce value exists, it is updated rather than a duplicate being created.
Question 6: The 'Run as' field on a scheduled import determines:
- Which timezone the import runs in
- The user context under which the transform executes (Correct answer)
- How many rows are processed per batch
- Which data source template is applied
Correct answer: The user context under which the transform executes
The 'Run as' field specifies the user account whose permissions and roles govern the transform execution.
Question 7: What does setting 'Copy empty fields' to true on a Transform Map do?
- Imports only rows where all source fields are empty
- Overwrites target field values with blank when the source field is empty (Correct answer)
- Skips rows that have empty mandatory fields
- Copies field labels instead of values when empty
Correct answer: Overwrites target field values with blank when the source field is empty
When 'Copy empty fields' is true, blank source values will overwrite existing data in the target record's fields.
CSA Data Import and Management 2
What is the primary purpose of a Transform Map in ServiceNow data imports?