CSA - ServiceNow System Administrator Data Import and Management Questions and Answers

Question 1

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?

Accepted Answer

Coalesce

Answer

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.

Question 2

What is the primary function of a Transform Map in the ServiceNow data import process?

Accepted Answer

To define the relationships between columns in a source import set table and fields in a target table.

Answer

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.

Question 3

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?

Accepted Answer

Auto Map Matching Fields

Answer

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.

Question 4

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?

Accepted Answer

Comma-Separated Values (.csv)

Answer

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.

Question 5

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?

Accepted Answer

In a Transform Script

Answer

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.

(CSA) ServiceNow System Administrator Certification Practice Test

(CSA) ServiceNow System Administrator Certification Practice Test

CSA - ServiceNow System Administrator Data Import and Management Questions and Answers