Module 4: Manage Data Flashcards

(28 cards)

1
Q

Which option allows you to update existing target table records when importing data from an import set?
A. Merge
B. Load Data
C. Coalesce
D. Update

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

Everything in ServiceNow is built on what?
A. The ServiceNow Platform
B. A relational database
C. A table
D. Tasks

A

B. A relational database

Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?

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

What contains the definition for each and every table and field in ServiceNow’s database?
A. System Properties
B. Tables
C. System Dictionary
D. System Definitions

A

C. System Dictionary

Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?

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

Please choose two

In which modules can you create a new table?
A. Tables module
B. Schema map
C. Data dictionary tables
D. Tables & Columns module

A

A. Tables module
D. Tables & Columns module

Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
Source: Data dictionary tables

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

Which module provides a list of all tables in the database?
A. Data dictionary tables
B. Schema map
C. Tables module
D. Tables & Columns module

A

C. Tables module

Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
Source: Data dictionary tables

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

Which module provides a graphical representation of the relationships between tables?
A. Data dictionary tables
B. Schema map
C. Tables module
D. Tables & Columns module

A

B. Schema map

Within Tables & Columns, select table, then select Schema map-
Within Tables, select table, the select Show Schema map UI action under Related Links

Within Tables & Columns, select table, then select Schema map

Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
Source: Data dictionary tables

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

Which module contains additional information that defines database elements?
A. Data dictionary tables
B. Schema map
C. Tables module
D. Tables & Columns module

A

A. Data dictionary tables

Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
Source: Data dictionary tables

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

Which module provides a list of all existing tables, with columns, column attributes, and indexes?
A. Data dictionary tables
B. Schema map
C. Tables module
D. Tables & Columns module

A

D. Tables & Columns module

Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?

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

How do you access the System Dictionary?
A. All > System Definition > Dictionary
B. All > System Definition > Tables
C. All > System Definition > Tables & Columns
D. All > System Definition > Schema map

A

A. All > System Definition > Dictionary

Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?

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

What is the 32-character, globally unique ID assigned to all records called?
A. sys_id
B. number
C. id
D. system_id

A

A. sys_id

Source: SNAF (Xanadu) > Table Administration > Table components

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

What defines how a field is interacted with through ServiceNow’s interfaces.
A. Field property
B. Field types
C. Field characteristics
D. Field properties

A

B. Field types

Source: SNAF (Xanadu) > Table Administration > Table components

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

Which answer below best describes the following:

A user-friendly term which allows people to identify the field in the user interface.
A. Field data
B. Field name
C. Field label
D. Field ID

A

C. Field label

Source: SNAF (Xanadu) > Table Administration > Field attributes

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

Which answer below best describes the following:

A system-friendly unique term that the system uses to identify the field.
A. Field data
B. Field name
C. Field label
D. Field ID

A

B. Field name

Source: SNAF (Xanadu) > Table Administration > Field attributes

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

Which answer below best describes the following:

The actual data entered into a field.
A. Field data
B. Field name
C. Field label
D. Field ID

A

A. Field data

Source: SNAF (Xanadu) > Table Administration > Field attributes

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

True or False

The field name always matches the field’s label.

A

False
e.g., Field name = city // Field label = Location

Source: SNAF (Xanadu) > Table Administration > Field attributes

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

Which field is identified with a magnifying glass?
A. Choice
B. True or False
C. Multi-choice
D. Reference

A

D. Reference

Source: SNAF (Xanadu) > Table Administration > Reference fields

17
Q

True or False

When you define a reference field, the system creates a relationship between the two tables.

A

True

Source: SNAF (Xanadu) > Table Administration > Reference fields

18
Q

True or False

A reference field can refer to records on any table.

A

False

Reference fields can refer to records from one other table. To add a field that can refer to records on any table, use the Document ID element type.

Source: SNAF (Xanadu) > Table Administration > Reference fields

19
Q

If a record is specified in the reference field on the source table, how can you preview the referenced record?
A. Dot-walk
B. Select the reference icon
C. Select the record within the Related Lists section
D. Double-click the field

A

B. Select the reference icon

Source: SNAF (Xanadu) > Table Administration > Reference fields

20
Q

Fill in the blank

The reference field stores the [blank] of a record on the other table.
A. Record number
B. Record value
C. sys_id
D. Lookup value

A

C. sys_id (the unique system identifier)

Source: SNAF (Xanadu) > Table Administration > Reference fields

21
Q

Which of the following one-to-many relationship fields allows a user to select a record on the other table?
A. Glide list
B. Document ID fields
C. Reference fields
D. Related lists

A

C. Reference fields

Source: SNAF (Xanadu) > Table Administration > Table relationships

22
Q

Which of the following one-to-many relationships allows a user to select multiple records on the other table?
A. Glide list
B. Document ID fields
C. Reference fields
D. Related lists

A

A. Glide list

Source: SNAF (Xanadu) > Table Administration > Table relationships

23
Q

Which of the following one-to-many relationships allows a user to select a record on any table in the instance.
A. Glide list
B. Document ID fields
C. Reference fields
D. Related lists

A

B. Document ID fields

Source: SNAF (Xanadu) > Table Administration > Table relationships

24
Q

Which answer below best describes the following:

Two or more tables can be related in a bidirectional relationship, so that the related records are visible from both tables in a related list.
A. One-to-Many
B. Many-to-Many
C. Database Views
D. Extensions

A

B. Many-to-Many

Source: SNAF (Xanadu) > Table Administration > Table relationships

25
# Which answer below best describes the following: Defines table joins for reporting purposes. A. One-to-Many B. Many-to-Many C. Database Views D. Extensions
C. Database View ## Footnote Source: SNAF (Xanadu) > Table Administration > Table relationships
26
# Which answer below best describes the following: The extended table includes unique fields plus all of the fields and their properties from the parent table. A. One-to-Many B. Many-to-Many C. Database Views D. Extensions
D. Extensions ## Footnote Source: SNAF (Xanadu) > Table Administration > Table relationships
27
# Please fill in the blank A table that extends (is an extension of) another table is a [blank]. A. Parent class B. Base class C. Core class D. Child class
D. Child class ## Footnote Source: SNAF (Xanadu) > Table Administration > Table relationships: extended tables
28
# Please fill in the blank The table from which a child class extends is the [blank] A. Parent class B. Base class C. Core class D. Child class
A. Parent class ## Footnote Source: SNAF (Xanadu) > Table Administration > Table relationships: extended tables