Data Import and Management Flashcards
6 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 6 Data Import and Management flashcards as text
An administrator is importing a spreadsheet of user data into ServiceNow to update existing user records and create new ones for new hires. To prevent duplicate records, the transform map must use a unique identifier from the source data to find and update existing records. Which field map setting accomplishes this?
Answer: Coalesce
The 'Coalesce' option on a field map designates that field as a unique key for the import. If a record in the target table has a matching value in the coalesced field, the existing record is updated; otherwise, a new record is created. This is the standard method for preventing duplicate records during data imports.
What is the primary function of a Transform Map in the ServiceNow data import process?
Answer: To define the relationships between columns in a source import set table and fields in a target table.
A Transform Map is a set of field maps that determines the relationships between fields in an import set and fields in an existing ServiceNow table. It acts as a guide for moving data from the staging table to its final destination table.
When creating a Transform Map, a system administrator notices the column names in the source spreadsheet (e.g., 'first_name', 'last_name', 'email') are identical to the field names on the target User [sys_user] table. Which feature can save time by automatically creating the field mappings?
Answer: Auto Map Matching Fields
The 'Auto Map Matching Fields' utility in the Transform Map form automatically creates field maps between the source and target tables when the column names and field names are identical. This is the quickest way to map fields that share the same name.
A system administrator needs to import data from a file provided by an external vendor. Which of the following is a valid, structured file format for a Data Source configuration in ServiceNow?
Answer: Comma-Separated Values (.csv)
ServiceNow Data Sources support several structured file formats, including CSV, Excel (.xlsx), and XML. JSON is also a supported format. Formats like .docx, .pdf, and unstructured .txt files are not suitable for direct data source imports.
During a data import of computer assets, the source data for the 'Status' column contains values like 'In Use' and 'In Stock'. The target field on the CMDB CI table expects integer choice values (e.g., 1 for 'In Use', 7 for 'In Stock'). A simple field map will not work. Where should an administrator implement logic to convert these string values to the correct integer values during the transformation?
Answer: In a Transform Script
Transform Scripts are used to implement custom logic during the data transformation process. They can modify data from the source before it is written to the target field, which is ideal for scenarios like converting string values to the appropriate integer choice values.
What is the role of an Import Set Table in ServiceNow?
Answer: A temporary staging area for data imported from an external source.
An Import Set Table is a temporary table created to store raw data imported from an external source, such as a CSV or Excel file. This acts as a staging area, allowing the data to be reviewed and transformed before it is moved to its final destination (target) table.