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

Ignore

Answer

Mandatory

Answer

Use Source Script

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

To provide a temporary staging area for raw data before it is processed.

Answer

To schedule the recurring import of data from an external source.

Answer

To validate the file format (e.g., CSV, Excel) of the incoming data source.

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

Mapping Assist Utility

Answer

Run Transform Script

Answer

Data Source Linker

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

Microsoft Word (.docx)

Answer

Portable Document Format (.pdf)

Answer

Text file (.txt) with no delimiter

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

On the Data Source record

Answer

In a Business Rule on the target table

Answer

In the Import Set table definition

Question 6

What is the role of an Import Set Table in ServiceNow?

Accepted Answer

A temporary staging area for data imported from an external source.

Answer

A final destination table for business data.

Answer

A table that stores a history of all data transformations.

Answer

A configuration table that defines data source connection details.