CAD practice question 26 of 35

Which set of steps is used to import spreadsheet data into a ServiceNow table?

Full set: 264 questions
Answer options
A: Define Data Source, Select Transform Map, Run Transform Load Data. Correct answer
B: Create Transform Map.
C: Run Transform Select Import Set, Select Transform Map.
D: Run Transform Select Data Source. Schedule Transform
Correct Answer:
A. Define Data Source, Select Transform Map, Run Transform Load Data.
Explanation

Importing spreadsheet data uses the Import-Set pipeline.
1. Define a Data Source (upload the spreadsheet) from System Import Sets > Load Data.
2. After the file is loaded, choose or create the appropriate Transform Map that maps import-set fields to target-table fields.
3. Run Transform to move the rows from the import-set table into the target table.
Option A lists this exact sequence; the other options omit or mis-order mandatory steps.

Why Incorrect

B Only creating a Transform Map does not load or transform any data. C Attempts to run the transform before an import set or map is selected; sequence is invalid. D Starts with Run Transform (cannot run without an import set) and ends with “Schedule Transform,” which is optional, not part of the basic import.

References

1. ServiceNow Product Documentation, “Load data from a file,” Tokyo release, steps 1–5 (para. 1-3)

2. ServiceNow Product Documentation, “Create a transform map,” Tokyo release, section ‘Run the transform’ (para. 2)

3. ServiceNow Product Documentation, “Import Set overview,” Tokyo release, section ‘Import process flow’ (Figure and bullet list)

(Official docs enumerate: Define Data Source → Load Data → Select/Create Transform Map → Run Transform, matching option A.)

Scroll to Top