CH4: Import Data

Question 1

An ______________ is a tool used to import data from various data sources, and map that data into ServiceNow tables.

Answer 1

Import Set

Question 2

True or False: Any user logged in with the admin or Import_admin role can manage all aspects of import sets.

Answer 2

TRUE

Question 3

______________ are records in ServiceNow that contain information regarding an Import Set data source.

Answer 3

Data Sources

Question 4

The _____________ acts as a staging area for records imported from a data source.

Answer 4

Import Set Table

Question 5

____________ provide a guide for moving data from Import Set tables to “target” tables.

Answer 5

Transform Maps

Question 6

True or False: A transform map is a set of field maps that determine the relationship between fields in an Import Set and fields in an existing ServiceNow table.

Answer 6

TRUE

Question 7

The ________ is an existing table where the data will be placed, post-transformation.

Answer 7

Target Table

Question 8

True or False: Data should be imported in extremely large chunks.

Answer 8

FALSE

Question 9

True or False: Creating an extremely large import set can cause extensive delays.

Answer 9

TRUE

Question 10

True or False: The imported file label is used to determine the name for the Import Set table that data will be loaded into.

Answer 10

TRUE

Question 11

True or False: It is impossible to schedule imports.

Answer 11

FALSE

Question 12

True or False: It is possible to choose an existing Import Set table to use for loading data from the same source, or data that has the same field/column designations.

Answer 12

TRUE

Question 13

A ____________ is a set of field maps that define the relationships between fields in an import set table and fields in a targe table.

Answer 13

Transform Map

Question 14

To _________ a field means that the field will be used as a unique key during imports.

Answer 14

Coalesce

Question 15

True or False: If a match is found using the coalesce field(s), the existing record will be updated with the information being imported.

Answer 15

TRUE

Question 16

True or False: If a match is not found using the coalesce field(s), then a new record will be inserted into the database.

Answer 16

TRUE

Question 17

True or False: If no coalesce is defined, all imported rows will be treated as new records.

Answer 17

TRUE

Question 18

Coalesce Configurations: Coalescing on a single field to update an existing record.

Answer 18

Single-field Coalesce

Question 19

Coalesce Configurations: Coalescing on multipe fields to update an existing record.

Answer 19

Multiple-field Coalesce

Question 20

Coalesce Configurations: Scripting to determine if an import table row should coalesce to a target record.

Answer 20

Conditional Coalesce

Question 21

True or False: Deleting records is reccommended in 99% of system administration functions.

Answer 21

False - It is NOT reccomended in 99% of system administration functions as records can be cancelled or marked inactive instead.