CSA Data Import and Management 3 — Questions and Answers
Question 1: Which system property controls the maximum number of rows that can be loaded into an import set at one time?
- glide.import.max_rows
- glide.excel.max_rows (Correct answer)
- com.glide.loader.max_count
- glide.transform.limit
Correct answer: glide.excel.max_rows
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?
- Executing a REST call to validate the source value
- Writing a script to derive the target value dynamically from source data (Correct answer)
- Triggering a workflow when the field is mapped
- Applying a choice list transformation automatically
Correct answer: Writing a script to derive the target value dynamically from source data
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?
- It stores the configuration of import set data sources
- It acts as the parent staging table for all import set records (Correct answer)
- It logs errors encountered during transformation
- It tracks which users initiated each import
Correct answer: It acts as the parent staging table for all import set records
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?
- onStart
- onBefore (Correct answer)
- onAfter
- onComplete
Correct answer: onBefore
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:
- An XPath expression for XML or a JSONPath expression for JSON (Correct answer)
- A regular expression pattern defined on the data source
- A CSV delimiter configured in the transform map
- A JDBC driver matching the REST endpoint's database type
Correct answer: An XPath expression for XML or a JSONPath expression for JSON
ServiceNow uses XPath for XML REST responses and JSONPath expressions for JSON REST responses to extract records.
Question 6: Which ServiceNow feature allows you to preview how a Transform Map will process a specific import set row before committing?
- Transform Simulator
- Test Transform (Correct answer)
- Preview Row
- Dry Run Mode
Correct answer: Test Transform
The 'Test Transform' option on a Transform Map lets you process a single row to verify mappings and scripts without affecting target data.
Question 7: What does the import set state 'Error' indicate about an import set row?
- The row failed validation before entering the staging table
- The transform script encountered an error processing that row (Correct answer)
- The data source connection failed mid-import
- The target record was locked by another user during update
Correct answer: The transform script encountered an error processing that row
An 'Error' state on an import set row means an exception occurred in the transform map scripts or field mapping for that specific row.
CSA Data Import and Management 3
Which system property controls the maximum number of rows that can be loaded into an import set at one time?