CSA · Question #58
Which of the following steps can be used to import new data into ServiceNow from a spreadsheet?
The correct answer is D. Select Import Set, Select Transform Map, Run Transform. Importing new data into ServiceNow from a spreadsheet typically involves loading the data into an Import Set, defining how it should be mapped to a target table via a Transform Map, and then executing the transformation.
Question
Which of the following steps can be used to import new data into ServiceNow from a spreadsheet?
Options
- ASelect Data Source, Schedule Transform
- BLoad Data, Create Transform Map, Run Transform
- CDefine Data Source, Select Transform Map, Run Transform
- DSelect Import Set, Select Transform Map, Run Transform
How the community answered
(48 responses)- A2% (1)
- C4% (2)
- D94% (45)
Why each option
Importing new data into ServiceNow from a spreadsheet typically involves loading the data into an Import Set, defining how it should be mapped to a target table via a Transform Map, and then executing the transformation.
This option omits crucial steps such as loading the data into an Import Set and creating/selecting a Transform Map for data transformation.
While 'Load Data' is the initial action to bring data into an import set, the phrase 'Select Import Set' in option D represents interacting with the staged data, and the subsequent steps of selecting a Transform Map and running the transform are crucial for completing the import process.
'Define Data Source' is a prerequisite, but 'Load Data' which creates the Import Set where the data initially resides, is omitted from this sequence of processing steps.
The process of importing new data first involves loading it into an Import Set. Once the data is staged, the next steps involve selecting or defining a Transform Map to specify the field mappings and then running that Transform to move the data from the Import Set table to the final target table.
Concept tested: Import Set data import process
Source: https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/import-sets/task/t_ImportDataUsingImportSets.html
Topics
Community Discussion
No community discussion yet for this question.