Data Import and Management Flashcards
7 cards from real CSA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Import and Management flashcards as text
A ServiceNow administrator wants to automatically import data from an SFTP server every night. Which module should they configure?
Answer: Scheduled Import
Scheduled Imports allow administrators to configure recurring imports from a data source on a defined schedule.
When using the 'Update' action in a Transform Map, what must be true for the target record to be updated?
Answer: A coalesce field match must be found in the target table
The transform engine looks for existing target records using coalesce fields; without a match, a new record is inserted instead.
What is the effect of enabling 'Run business rules' on a Transform Map?
Answer: Standard ServiceNow business rules on the target table will execute during the transform
When enabled, business rules defined on the target table fire normally as each row is inserted or updated during the transform.
Which data source attachment type would you use to import a pipe-delimited text file?
Answer: CSV
CSV data sources support configurable delimiters, so a pipe-delimited file can be imported by setting the delimiter character to '|'.
What does the 'Ignore mandatory fields' option on a Transform Map do?
Answer: Allows target records to be saved even if mandatory fields are empty
Enabling 'Ignore mandatory fields' lets the transform bypass mandatory field validation on the target table, which can be useful for bulk migrations.
A field map in a Transform Map has its 'Target field' left blank. What will happen to that source field during the transform?
Answer: The source field will be ignored and not written to the target
If no target field is specified in a field map, that source column is simply not written to the target table.
What is the recommended approach to handle lookup (reference) fields when importing data into ServiceNow?
Answer: Use a 'Reference' type field map with a dot-walk to match on a display value like name or number
ServiceNow field maps can resolve reference fields by matching on display values (e.g., user name, group name) using dot-walked lookup fields.