Module 7.1 Flashcards

1
Q

Understand what data is coming in and where is should be place before what?

A

Before importing any data

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

Plan time before an import to verify the data to correct inaccurate data and delete undesired or inaccurate data (t/f)

A

True

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

Why is it best to spend time planning and examining data before importing it?

A

To save time and potential problems later

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

What are the three ways that the guided application creator provides for creating tables?

A

Upload spreadsheet
Extend
Scratch

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

What option do you choose to easily transform an excel spreadsheet into a table?

A

Upload spreadsheet option

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

What are the two ways to upload a spreadsheet?

A

Manually or drag and drop

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

What requirements does the spreadsheet have to be successfully used?

A

Must be xlsx with horizontal columns and header labels

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

After you upload a spreadsheet what must you indicate?

A

Which rows contain header columns

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

What is the default row for the header column?

A

1

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

When a spreadsheet is uploaded what information is detected and extracted?

A

The field labels, the field names, and the field types

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

After uploading the spreadsheet, to include the data make sure you select what?

A

import the spreadsheet data

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

The system cannot identify choice or reference fields but what can be done?

A

It can be defined manually

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

The system will parse the first worksheet in the spreadsheet to do what?

A

To identify the fields for the custom table

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

Can new fields be added to a table after fields have already been imported?

A

Yes

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

How many field types are listed as options for new fields for tables?

A

18

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

If a field type for a table is not listed, what system property can be added for you to set value to the field type?

A

sn_g_app_creator.field_types

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

After table columns are defined, what is next to do?

A

Define the table properties and permissions

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

To finish designating tables when creating an app, what do you select?

A

Done with tables

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

If you do not use the import option during Guided Application creator, what provides a mechanism to pull data into servicenow?

A

Import sets

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

Where do import sets store data?

A

In import set tables

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

When does the import set process skip records?

A

when the data in the instance is the same as the data being imported

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

What determines the relationship between fields in an import set table to fields in an existing ServiceNow table?

A

Transform maps

23
Q

This is the table where data will be placed, post transformation during an import set

A

The target table

24
Q

What is the process for importing via an import set?

A

Load data, create transform map, run transform

25
Q

When loading data into an import set table via excel, where is the data initially loaded before it’s final destination?

A

A staging table

26
Q

When loading data into an import set table via excel, what is loaded onto the staging table?

A

All content from a worksheet

27
Q

Does all data from a staging table have to be copied to the final destination?

A

No

28
Q

Where do you first go to create a new import set table?

A

System import sets> load data > create table

29
Q

How do you name an import set table?

A

The name field is automatically populated after putting a value in the label field

30
Q

Maps data from the source (import set) table to the target table

A

Transform map

31
Q

A set of field maps that determine the relationships between fields in an import set and fields in an existing servicenow table

A

Transform map

32
Q

Once defined, can an existing transform map be reused for mapping data from an import set to a servicenow table?

A

Yes

33
Q

To create a transform map, after importing data what do you select? (Two options)

A

Select the create transform map related link or create a transform map in studio

34
Q

Select this to run business rules, workflows, approval engines, auditing, and field normalization while the transformation inserts or updates data into the target table

A

Run business rules

35
Q

Select this to enforce mandatory fields on the target table when creating a transform map

A

Enforce mandatory fields

36
Q

Choose this option to clear fields with existing values when an incoming field contains an empty value when creating a transform map

A

Copy empty fields

37
Q

Choose this option to create a new record when all coalesce fields are empty when creating a transform map

A

Create a new record on empty coalesce fields

38
Q

What are the two ways to match fields on the import set table to fields on the target table?

A

Automatic (if field names match)
Manual

39
Q

The simplest method to match fields is where all of the field names of the import sets match the names of the fields on the target table. In this case, simply click?

A

Auto map matching fields in the related list in the table transform map and confirm proper matching

40
Q

If there are any discrepancies in how fields are automatically matched this can easily be corrected by doing what?

A

Using the mapping assist utility

41
Q

When all fields are matched properly, what do you select to begin transforming data onto the destination table?

A

Transform in the related list

42
Q

Provides a visually intuitive environment for specifying mapping between import set fields and production table fields

A

Mapping assist utility

43
Q

With this it is possible to map a single source field (field on an import set table) to multiple destination fields (fields on a production table)

A

Mapping assist utility

44
Q

Can more than one field be a coalesce field?

A

Yes

45
Q

Are coalesce fields required?

A

No

46
Q

This option makes a field a record’s unique key

A

Coalesce

47
Q

If a match is found using the coalesce field, the existing record will be updated with the information being imported. If a match is not found, then what happens?

A

A new record will be inserted into the database

48
Q

The import set application attempts to match source values to existing target values when the coalesce value is set to what?

A

True

49
Q

The import set application always creates new records for each transformation when the coalesce value is set to what?

A

False

50
Q

If multiple fields are set to coalesce, all coalesce values are used to do what?

A

Match an existing record

51
Q

If two fields are set for coalescing and a matching value is found on one of the coalescing fields but not on the other, what happens?

A

A new record is inserted

52
Q

This copies data from the import set table to the target table using the map(s)

A

Transform

53
Q

After a transform is complete what are the three options for the next steps?

A

-Go to the import set
-Show the transform history, related errors, and log
-View the import log

54
Q

To transform data what do you select?

A

Select the transform related link
Select the import set to copy records from
Select the map(s) to use when copying
Select transform