13% Topic 6 – Data Migration & Integration Flashcards by Linda Leynes

What is data migration?

[Exam Weight: 13%] One-time movement of data into ServiceNow

How well did you know this?

Not at all

Perfectly

What is an integration?

[Exam Weight: 13%] Ongoing data exchange between systems

How well did you know this?

Not at all

Perfectly

What is the key difference between migration and integration?

[Exam Weight: 13%] Migration is one-time; integration is ongoing

How well did you know this?

Not at all

Perfectly

What tool is used for one-time data loads?

[Exam Weight: 13%] Import Sets

How well did you know this?

Not at all

Perfectly

What record defines where import data comes from?

[Exam Weight: 13%] Data Source

How well did you know this?

Not at all

Perfectly

Where is imported data stored initially?

[Exam Weight: 13%] Import Set table

How well did you know this?

Not at all

Perfectly

What controls how import data moves to target tables?

[Exam Weight: 13%] Transform Map

How well did you know this?

Not at all

Perfectly

Can Transform Maps be reused?

[Exam Weight: 13%] Yes

How well did you know this?

Not at all

Perfectly

What feature allows recurring imports?

[Exam Weight: 13%] Scheduled Import

How well did you know this?

Not at all

Perfectly

What integration type uses REST APIs?

[Exam Weight: 13%] REST integration

How well did you know this?

Not at all

Perfectly

What data format is commonly used with REST?

[Exam Weight: 13%] JSON

How well did you know this?

Not at all

Perfectly

Which integration type is more lightweight?

[Exam Weight: 13%] REST

How well did you know this?

Not at all

Perfectly

What CSA mistake is common with imports?

[Exam Weight: 13%] Treating them as integrations

How well did you know this?

Not at all

Perfectly

What CSA mistake is common with integrations?

[Exam Weight: 13%] Using them for one-time loads

How well did you know this?

Not at all

Perfectly

What determines whether to use migration or integration?

[Exam Weight: 13%] Frequency of data exchange

How well did you know this?

Not at all

Perfectly

What is data migration in ServiceNow?

[Exam Weight: 13%] [Migration] The process of importing data from external sources into ServiceNow tables.

How well did you know this?

Not at all

Perfectly

What tool is most commonly used for data migration in ServiceNow?

[Exam Weight: 13%] [Migration] Import Sets.

How well did you know this?

Not at all

Perfectly

What is an Import Set?

[Exam Weight: 13%] [Migration] A staging table used to temporarily store imported data.

How well did you know this?

Not at all

Perfectly

What is the purpose of an Import Set table?

[Exam Weight: 13%] [Migration] To hold raw data before it is transformed into target tables.

How well did you know this?

Not at all

Perfectly

What are common data sources for Import Sets?

[Exam Weight: 13%] [Migration] CSV files, Excel files, JDBC, and web services.

How well did you know this?

Not at all

Perfectly

What process moves data from an Import Set to a target table?

[Exam Weight: 13%] [Migration] Transform Map.

How well did you know this?

Not at all

Perfectly

What is a Transform Map?

[Exam Weight: 13%] [Migration] A set of rules that maps fields from an Import Set to a target table.

How well did you know this?

Not at all

Perfectly

What is a target table?

[Exam Weight: 13%] [Migration] The destination table where transformed data is stored.

How well did you know this?

Not at all

Perfectly

What happens during data transformation?

[Exam Weight: 13%] [Migration] Data is validated, mapped, and inserted or updated in the target table.

How well did you know this?

Not at all

Perfectly

Can data be modified during transformation?

[Exam Weight: 13%] [Migration] Yes, using transform scripts.

What types of transform scripts exist?

[Exam Weight: 13%] [Migration] onStart, onBefore, onAfter, and field scripts.

What determines whether records are inserted or updated?

[Exam Weight: 13%] [Migration] The coalesce field.

What is a coalesce field?

[Exam Weight: 13%] [Migration] A field used to uniquely identify records during import.

What happens if a matching coalesce value exists?

[Exam Weight: 13%] [Migration] The target record is updated.

What happens if no matching coalesce value exists?

[Exam Weight: 13%] [Migration] A new record is inserted.

Can multiple fields be used as coalesce?

[Exam Weight: 13%] [Migration] Yes.

What happens if coalesce is not defined?

[Exam Weight: 13%] [Migration] New records are created for every import row.

What table stores Import Set data?

[Exam Weight: 13%] [Migration] import_set tables (u_* or prefixed tables).

What happens to Import Set data after transformation?

[Exam Weight: 13%] [Migration] It remains unless manually deleted or cleaned up.

What is data migration in ServiceNow?

[Exam Weight: 13%] [Integration] The process of importing data from external sources into ServiceNow tables.

What tool is most commonly used for data migration in ServiceNow?

[Exam Weight: 13%] [Integration] Import Sets.

What is an Import Set?

[Exam Weight: 13%] [Integration] A staging table used to temporarily store imported data.

What is the purpose of an Import Set table?

[Exam Weight: 13%] [Integration] To hold raw data before it is transformed into target tables.

What are common data sources for Import Sets?

[Exam Weight: 13%] [Integration] CSV files, Excel files, JDBC, and web services.

What process moves data from an Import Set to a target table?

[Exam Weight: 13%] [Integration] Transform Map.

What is a Transform Map?

[Exam Weight: 13%] [Integration] A set of rules that maps fields from an Import Set to a target table.

What is a target table?

[Exam Weight: 13%] [Integration] The destination table where transformed data is stored.

What happens during data transformation?

[Exam Weight: 13%] [Integration] Data is validated, mapped, and inserted or updated in the target table.

Can data be modified during transformation?

[Exam Weight: 13%] [Integration] Yes, using transform scripts.

What types of transform scripts exist?

[Exam Weight: 13%] [Integration] onStart, onBefore, onAfter, and field scripts.

What determines whether records are inserted or updated?

[Exam Weight: 13%] [Integration] The coalesce field.

What is a coalesce field?

[Exam Weight: 13%] [Integration] A field used to uniquely identify records during import.

What happens if a matching coalesce value exists?

[Exam Weight: 13%] [Integration] The target record is updated.

What happens if no matching coalesce value exists?

[Exam Weight: 13%] [Integration] A new record is inserted.

Can multiple fields be used as coalesce?

[Exam Weight: 13%] [Integration] Yes.

What happens if coalesce is not defined?

[Exam Weight: 13%] [Integration] New records are created for every import row.

What table stores Import Set data?

[Exam Weight: 13%] [Integration] import_set tables (u_* or prefixed tables).

What happens to Import Set data after transformation?

[Exam Weight: 13%] [Integration] It remains unless manually deleted or cleaned up.

What role is required to configure integrations?

[Exam Weight: 13%] [Exam Favourite] admin (and sometimes security_admin).

How should credentials be stored for integrations?

[Exam Weight: 13%] [Exam Favourite] Securely using credentials records.

What should never be hard-coded in scripts?

[Exam Weight: 13%] [Exam Favourite] Passwords or credentials.

What ensures secure communication for integrations?

[Exam Weight: 13%] [Exam Favourite] HTTPS / TLS.

What is a common best practice for data migration testing?

[Exam Weight: 13%] [Exam Favourite] Test imports in a sub-production instance first.

What should be validated after a data import?

[Exam Weight: 13%] [Exam Favourite] Data accuracy, completeness, and relationships.

What happens if a transform map fails?

[Exam Weight: 13%] [Exam Favourite] Errors are logged for review.

Where can transform errors be reviewed?

[Exam Weight: 13%] [Exam Favourite] Import Set run history and logs.

13% Topic 6 – Data Migration & Integration Flashcards

(61 cards)