Data Migration and Integration
51 questions from the Data Migration and Integration domain of the ServiceNow Certified System Administrator (CSA) exam, each with its answer and an explanation. Read them through as revision, then sit the full practice exam to test yourself on them under multiple-choice conditions.
1.What data formats can IntegrationHub parse?
Answer
- Both XML and JSON responses
IntegrationHub handles multiple data formats when integrating with external systems. It can parse XML (common in SOAP APIs and legacy systems) and JSON (standard for REST APIs), which ensures flexibility across diverse integrations.
2.Which OOB support will help you to avoid creating duplicates while importing data?
Answer
- Coalesce Field
Coalesce lets you update existing target table records when transforming import data. A matching record is updated; if none is found, a new record is created.
3.Can we coalesce multiple fields in a table for given transform map?
Answer
- Yes
ServiceNow supports coalescing on multiple fields and multiple transform maps against a single data source. When several fields coalesce, all values must match an existing record; if one matches but another does not, a new record is inserted.
4.Where are customizations done on a ServiceNow instance stored?
Answer
- sys_update_xml
Customizations are stored in sys_update_xml (Customer Update), which captures XML records of changes such as new fields, forms, scripts and configurations for use in update sets. sys_update_set only stores metadata about the update set container. Update sets store new and updated choice options as separate records in sys_update_version and sys_update_xml.
5.The MID Server enables communication and the movement of data between ServiceNow instance and external applications, data sources, and services. Which table stores all related communication records in this regard?
Answer
- ECC Queue (ecc_queue) table
ecc_queue is the central table storing all communication records between the instance and the MID Server, holding both input and output messages. The cmdb-prefixed variants are not valid table names.
6.Is it true that you cannot revert update set versions?
Answer
- FALSE
Update sets can be reverted to previous versions; administrators can roll changes back, so the statement is false.
7.Which one of the following statements is a recommendation from ServiceNow about Update Sets?
Answer
- Avoid using the Default Update set as an Update Set for moving customization from instance to instance
The Default Update Set only captures changes when no other set is selected; using it for migration causes confusion and incomplete transfers, so named update sets are best practice. The Baseline Update Set captures the original state before customization, instances should be on the same version, and a Complete update set should not be reopened.
8.What details can you find in the import set record after running an import? (Choose 3)
Answers
- Import Log
- Import Set Runs
- Import Set Rows
The Import Log details execution errors, warnings and successes; Import Set Runs track each execution with timing and status; Import Set Rows hold the staged source records. Import Maps are configuration objects, the Import Set API is a programmatic mechanism, and concurrent import sets describe system behavior rather than record detail.
9.When using the Load Data and Transform Map process, what is the Mapping Assist used for?
Answer
- Mapping fields using a Field Map
Mapping Assist helps align source fields from the import set table with target fields in the destination table using Field Maps, reducing manual effort. Transform History tracks past transforms, the Import Log records import status, and SLAs are unrelated to data import.
10.IntegrationHub enables execution of third-party APIs as a part of a flow. These integrations are referred to as:
Answer
- A spoke
A spoke is a scoped application containing Flow Designer or IntegrationHub actions or subflows, grouping related actions and supporting files for reuse. IntegrationHub includes baseline spokes, and more can be obtained from the ServiceNow Store or Share, or built in-house.
11.How are Workflows moved between instances?
Answer
- Workflows are moved using Update Sets
Workflows are tracked differently in update sets because workflow information spans multiple tables. Changes to a workflow version are not added to the update set until the workflow is published, at which point the whole workflow is added.
12.Which one of the following phrases completes the statement: "The purpose of transform map is to"
Answer
- Determine the relationship between fields displaying in an import set table to the fields in an existing ServiceNow table.
A transform map is a set of field maps determining the relationships between fields in an import set and fields in an existing ServiceNow table, such as Incident or User. The Transform Maps module lets an administrator define destinations for imported data on any table, often via drag-and-drop field linking.
13.What is the primary application used to load data into ServiceNow?
Answer
- System Import Sets
To load data from a data source into a staging table, use the Application Navigator to open System Import Sets > Load Data; configuration options vary by data source, and a staging table is created dynamically.
14.What is the Import Set Table?
Answer
- A staging area for imported records
An import set table acts as a staging location for records imported from a data source prior to transforming them. Fields on these tables are generated automatically and should not be modified manually.
15.Which field (or fields) is used as a unique key during imports?
Answer
- Coalesce Fields
Coalesce Fields determine whether an incoming record should update an existing record or create a new one, acting as the unique key for matching during import. Sys IDs are system-generated and impractical for external matching, and "Match Fields"/"Key Fields" are not formal ServiceNow terms.
16.What module enable an administrator to define destinations for imported data on any ServiceNow table?
Answer
- Transform Map
The Transform Map module lets administrators define destinations for imported data on any table.
17.What is a best practice regarding data imports?
Answer
- Plan time before your import to remove obsolete or inaccurate data
Before importing, verify and clean the data, and avoid loading data in extremely large chunks.
18.Why is it recommended that you limit update sets to a maximum of 100 records? (Choose 2 answers)
Answers
- Reduce potential conflicts
- Make it easier to identify and review changes
Smaller update sets reduce the chance of overlapping changes or conflicts when merging into production, and make changes easier to review, test, and validate. It is unrelated to ISO audits, business-hour timing, the default update set, or log length.
19.New records, new groups and modified configuration items what do they have in common?
Answer
- They are not captured in an update set.
Update sets capture configuration changes like tables, fields, form/list layout, business rules, workflows, system properties, client scripts, and script includes, but they do NOT capture transactional data such as changes to records, users, groups, incidents, configuration items, or email.
20.When using Transform Mapping in ServiceNow, how can we dynamically map fields?
Answer
- We can dynamically map source and destination fields by using ServiceNow scripting objects and functionality.
Transform map field mapping scripts (such as onBefore, onAfter, or Script mappings) enable dynamic logic to map source fields to destination fields during data imports. Update sets are unrelated to runtime mapping, and ServiceNow does support scheduled data imports.
21.By default in ServiceNow, what customizations are added to Update Sets?
Answer
- Changes made to a form.
Update sets track customizations to application tables, fields, and records, which are entailed in a form.
22.When moving a homepage or dashboard between instances, what must you remember?
Answer
- Manually add them to the update set
Homepages and dashboards must be manually added to the update set to move between instances; they are not automatically captured.
23.What tool allows you to drag and drop to specify links between source fields on an Import Set table and destination fields on any ServiceNow table?
Answer
- Mapping Assist Utility
The mapping assist utility provides a visually intuitive drag-and-drop environment for specifying mapping between import set fields and production table fields, including mapping a single source field to multiple destination fields.
24.What are the steps for importing data using an import set?
Answer
- Load the data; Create transform map; Transform data; Clean up import table
The Import Set table acts as a staging location for records prior to transforming them; the standard process is to load data, create a transform map, transform the data, and clean up the import table afterward.
25.When importing data, what happens to imported rows, if no coalesce field is specified?
Answer
- All rows are treated as new records. No existing records are updated
If no coalesce field is defined, all imported rows are treated as new records; no existing records get updated.
26.Which one of the following statement applies to a set of fields when they are coalesced during an import?
Answer
- If a match is found using the coalesce fields, the existing record is updated with the information being imported
Coalesce fields determine whether an incoming record matches an existing one; when a match is found, the existing record is updated with the imported data, and if no match is found a new record is created instead.
27.Which of the following are valid data sources for import sets? (select all that apply)
Answers
- JDBC
- XML Files
- HTTP
- CSV Files
- Excel files
All five are valid import set sources: JDBC connects to relational databases, XML and CSV are structured file formats, HTTP enables web service imports, and Excel spreadsheets can also be imported directly.
28.You are importing data from an excel sheet into the Incident table. The Incident table already contains data. You want to make sure that the import doesn't result in duplicate records. What should you do?
Answer
- Set the coalesce to Title field
Setting the Title field as coalesce causes ServiceNow to check for an existing record with the same Title and update it instead of creating a duplicate. The 'Allow Duplicates' checkbox only affects the import set staging table, not the target table, and a delete-after-insert business rule is inefficient and risky.
29.What is the minimum role needed to create import sets?
Answer
- import_admin
import_admin is specifically designed to allow creating and managing import sets, providing the necessary permissions to load data and configure mappings — the minimum role needed for this task rather than the broader admin role.
30.Which of the following can be used to integrate flow designer with other instances and 3rd party applications?
Answer
- Integration Hub
Integration Hub enables executing third-party APIs as part of a flow via spokes, which are easy to configure without scripting. The MID Server instead facilitates data movement between the platform and external systems, not flow integration per se.
31.Which of the following is captured in update sets? (select all that apply)
Answers
- Client Scripts
- Business Rules
- Fields
Update sets capture application customizations like client scripts, business rules, and field definitions, enabling consistent deployment across environments. They do not capture transactional data such as modified/new data records or tasks like incidents.
32.Which of the following is captured in update sets? (select all that apply)
Answers
- Report Definitions
- Published Workflows
- Views
- Tables
Update sets capture report definitions, active published workflow versions, custom views (columns/filters), and table/schema changes. Homepages/dashboards require separate export/import, and scheduled jobs are runtime/transactional data excluded from update sets.
33.Transform maps can only be used once.
Answer
- FALSE
Transform maps can be reused multiple times across different import sets, promoting efficiency and consistency in data mapping.
34.How to capture workflow in update sets?
Answer
- Publish
Workflows must be published before they are captured in update sets. Only published versions are included for migration between instances.
35.Where would you go to start an import set?
Answer
- System Import Sets > Load Data
System Import Sets > Load Data is where you upload a data file into a staging table, the entry point for initiating an import set process.
36.What are update sets?
Answer
- Customization that can be moved from 1 instance to another
Update sets are containers that capture customizations and configuration changes made in one instance, allowing them to be moved to another instance (e.g., dev to production).
37.All users can manage and setup import sets.
Answer
- FALSE
Only users with the import_set role (or membership in a group with that role) can manage and set up import sets, due to the potential impact on data integrity.
38.Where can you view a series of customizations?
Answer
- Update set
Update sets bundle and track customizations (scripts, workflows, field/table modifications, UI customizations) made within an instance.
39.Is it true that System upgrade schedule auto-updates an existing MID server to the latest build on a ServiceNow instance?
Answer
- FALSE
ServiceNow system upgrades do not automatically update MID Servers. MID Servers require manual upgrade or redeployment to align with the instance version.
40.Update sets cannot be merged.
Answer
- FALSE
Update sets in ServiceNow can be merged - multiple update sets can be combined into a single new update set, with ServiceNow prioritizing the latest changes.
41.If the Default update set is marked complete:
Answer
- The system creates another update set named Default1 and uses it as the default update set.
Marking the Default update set complete causes ServiceNow to automatically create a new 'Default1' update set and make it the active default.
42.Only _ update sets can be exported
Answer
- Completed
An update set must be marked Completed before it can be exported to another instance.
43.ServiceNow consists of standard integration with LDAP
Answer
- True
ServiceNow provides native, out-of-the-box integration with LDAP for authenticating users and importing user/group data from directories like Active Directory.
44.There is no need to create new Import Set for every time you need to import data, you can reuse the Import Set if you're importing data with the same columns
Answer
- True
Import Set tables are reusable staging tables; once mapped correctly, the same Import Set can be reused for future imports that share the same column structure.
45.To retrieve an update set from a remote instance, in the Production instance, navigate to:
Answer
- All > System Update Sets > Update Sources
Update sets are retrieved from a remote instance via All > System Update Sets > Update Sources, which manages connections to other instances for pulling update sets.
46.Other than Update Set, how else can you move data to another instance in a easy way?
Answer
- XML
Exporting data as XML from one instance and importing it into another is a common way to migrate records exactly, without needing to build an import set or transform map, for occasional one-time migrations.
47.What are the steps for applying an update set to an instance?
Answer
- Retrieve, Preview, Commit
The update set transfer process is: Retrieve the remote update set, Preview it to check for conflicts, then Commit it to apply the changes to the instance.
48.An outbound SOAP message is defined. Which function can invoke the SOAP message?
Answer
- UI Action
UI Actions can be configured with scripts/conditions to trigger outbound SOAP messages when events occur (record created/updated, button clicked, condition met), enabling integration with external systems. UI Policies control visibility/behavior of UI elements, and Data Policies enforce data integrity rules — neither triggers outbound communication.
49.LDAP comes automatically configured on a company's ServiceNow instance. True or False?
Answer
- FALSE
ServiceNow supports LDAP integration out of the box, but it is not configured for you. An administrator has to define the LDAP server connection, the OUs to import and the transform maps, and schedule the user and group imports before LDAP authentication and synchronization work.
50.Only predefined roles can be migrated from one instance to another. True or False?
Answer
- FALSE
Custom roles are configuration records, so creating or changing them is captured in update sets, and they move between instances like any other customization. Assigning a role to a user or group is data, however, and is not captured.
51.Which of the following are automatically captured in an update set?
Answers
- Tables
- Forms
- Views
Update sets capture configuration changes, such as creating or modifying tables, changing form layouts and defining views. User records are data, not configuration, so they are not captured and have to be moved another way, for example by exporting and importing XML.