nerdexam
ServiceNow

CAD · Question #242

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

The correct answer is B. Create Transform Map. Importing spreadsheet data into ServiceNow tables requires a structured process, with a key step being the definition of data mapping.

Submitted by helene.fr· Apr 18, 2026Integrating with Other Applications

Question

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

Options

  • ADefine Data Source, Select Transform Map, Run Transform Load Data.
  • BCreate Transform Map.
  • CRun Transform Select Import Set, Select Transform Map.
  • DRun Transform Select Data Source. Schedule Transform

How the community answered

(43 responses)
  • A
    9% (4)
  • B
    86% (37)
  • C
    2% (1)
  • D
    2% (1)

Why each option

Importing spreadsheet data into ServiceNow tables requires a structured process, with a key step being the definition of data mapping.

ADefine Data Source, Select Transform Map, Run Transform Load Data.

'Run Transform Load Data' is an inaccurate combination of steps; data is loaded into an import set first, and then transformed in separate, distinct phases.

BCreate Transform Map.Correct

A critical and distinct step in importing spreadsheet data into a ServiceNow table is to 'Create Transform Map,' which defines the field-to-field relationships and any necessary transformations between the import set (temporary staging area) and the target table. Without a properly configured transform map, the system cannot correctly process and map the incoming data to its destination.

CRun Transform Select Import Set, Select Transform Map.

The order of 'Run Transform' before 'Select Transform Map' is incorrect; the transform map must be defined or selected before the transformation can be executed.

DRun Transform Select Data Source. Schedule Transform

'Run Transform Select Data Source' incorrectly conflates the data source definition with running a transform, and 'Schedule Transform' is an optional, later step, not part of the core import sequence.

Concept tested: ServiceNow data import process (Transform Maps)

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

Topics

#Data Import#Transform Map#Import Set#Spreadsheet Integration

Community Discussion

No community discussion yet for this question.

Full CAD Practice