CSA Data Import and Management 3

Question 1

Which system property controls the maximum number of rows that can be loaded into an import set at one time?

Accepted Answer

glide.excel.max_rows

Answer

The glide.excel.max_rows property limits the number of rows ServiceNow will load from Excel and other file-based imports.

Question 2

In a Transform Map field mapping, what does the 'Use source script' option allow?

Accepted Answer

Writing a script to derive the target value dynamically from source data

Answer

Enabling 'Use source script' lets you write JavaScript in the field map to compute or transform the value before writing it to the target field.

Question 3

What is the role of the 'Import Set Row' table (sys_import_set_row) in ServiceNow?

Accepted Answer

It acts as the parent staging table for all import set records

Answer

sys_import_set_row is the base table extended by all import set (u_imp_*) staging tables to store imported rows.

Question 4

Which transform map script field fires once per row BEFORE the row is transformed?

Accepted Answer

onBefore

Answer

The onBefore script runs once per row before transformation, allowing row-level validation or pre-processing.

Question 5

When importing data via a REST data source in ServiceNow, the response is typically parsed using:

Accepted Answer

An XPath expression for XML or a JSONPath expression for JSON

Answer

ServiceNow uses XPath for XML REST responses and JSONPath expressions for JSON REST responses to extract records.

(CSA) ServiceNow System Administrator Certification Practice Test