CSA Data Import and Management 2

Question 1

What is the primary purpose of a Transform Map in ServiceNow data imports?

Accepted Answer

To map source fields to target table fields during import

Answer

A Transform Map defines how fields in the import set (staging table) map to fields in the target ServiceNow table.

Question 2

Which scripting field in a Transform Map runs logic before any row is transformed?

Accepted Answer

onStart

Answer

The onStart script runs once before processing begins, making it ideal for initialization logic.

Question 3

An import set source type of 'JDBC' allows ServiceNow to:

Accepted Answer

Connect directly to an external relational database

Answer

JDBC data sources enable ServiceNow to connect directly to external relational databases using a database driver.

Question 4

What happens to records in an import set table after the transform is complete by default?

Accepted Answer

They are automatically deleted after 7 days

Answer

By default, import set records are cleaned up after 7 days, but this retention period is configurable.

Question 5

Which field on a Transform Map record controls whether duplicate records in the target table are updated or skipped?

Accepted Answer

Coalesce field

Answer

Coalesce fields act as match keys — if a target record with the same coalesce value exists, it is updated rather than a duplicate being created.

(CSA) ServiceNow System Administrator Certification Practice Test