CSA Question #100: Real Exam Question with Answer & Explanation

Question

When importing spreadsheet data into ServiceNow, in which step does the data get written to the receiving table?

Options

• ARun Transform
• BRun Import
• CImport Dataset
• DExecute Transform
• ESchedule Transform

Explanation

When importing spreadsheet data into ServiceNow, the data is written to the receiving target table during the 'Execute Transform' step.

Common mistakes.

• A. 'Run Transform' is essentially the same action as 'Execute Transform', but 'Execute Transform' can be seen as a more precise description of the process where the transformation logic is actively performed.
• B. 'Run Import' typically refers to the initial loading of data from the source file into the import set table, not the subsequent writing to the target table.
• C. 'Import Dataset' refers to the action of bringing the raw data into the staging (import set) table, which precedes the transformation to the target table.
• E. 'Schedule Transform' sets up the transform map to run at a future time, but it is not the step where the data is actually written to the target table.

Concept tested. Data import transform step

Reference. https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/import-sets/concept/c_ImportSets.html

No community discussion yet for this question.