CH4: Import Data Flashcards

1
Q

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

A

Import Set

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Data Sources

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Import Set Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Transform Maps

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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.

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Target Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

FALSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

True or False: It is impossible to schedule imports.

A

FALSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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.

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

Transform Map

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

Coalesce

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

TRUE

17
Q

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

A

TRUE

18
Q

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

A

Single-field Coalesce

19
Q

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

A

Multiple-field Coalesce

20
Q

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

A

Conditional Coalesce

21
Q

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

A

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