Module 4: Manage Data Flashcards
(28 cards)
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
C. Coalesce
Everything in ServiceNow is built on what?
A. The ServiceNow Platform
B. A relational database
C. A table
D. Tasks
B. A relational database
Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
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
C. System Dictionary
Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
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. Tables module
D. Tables & Columns module
Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
Source: Data dictionary tables
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
C. Tables module
Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
Source: Data dictionary tables
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
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
Which module contains additional information that defines database elements?
A. Data dictionary tables
B. Schema map
C. Tables module
D. Tables & Columns module
A. Data dictionary tables
Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
Source: Data dictionary tables
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
D. Tables & Columns module
Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
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. All > System Definition > Dictionary
Source: SNAF (Xanadu) > Table Administration > What is the ServiceNow infrastructure?
What is the 32-character, globally unique ID assigned to all records called?
A. sys_id
B. number
C. id
D. system_id
A. sys_id
Source: SNAF (Xanadu) > Table Administration > Table components
What defines how a field is interacted with through ServiceNow’s interfaces.
A. Field property
B. Field types
C. Field characteristics
D. Field properties
B. Field types
Source: SNAF (Xanadu) > Table Administration > Table components
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
C. Field label
Source: SNAF (Xanadu) > Table Administration > Field attributes
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
B. Field name
Source: SNAF (Xanadu) > Table Administration > Field attributes
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. Field data
Source: SNAF (Xanadu) > Table Administration > Field attributes
True or False
The field name always matches the field’s label.
False
e.g., Field name = city // Field label = Location
Source: SNAF (Xanadu) > Table Administration > Field attributes
Which field is identified with a magnifying glass?
A. Choice
B. True or False
C. Multi-choice
D. Reference
D. Reference
Source: SNAF (Xanadu) > Table Administration > Reference fields
True or False
When you define a reference field, the system creates a relationship between the two tables.
True
Source: SNAF (Xanadu) > Table Administration > Reference fields
True or False
A reference field can refer to records on any table.
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
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
B. Select the reference icon
Source: SNAF (Xanadu) > Table Administration > Reference fields
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
C. sys_id (the unique system identifier)
Source: SNAF (Xanadu) > Table Administration > Reference fields
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
C. Reference fields
Source: SNAF (Xanadu) > Table Administration > Table relationships
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. Glide list
Source: SNAF (Xanadu) > Table Administration > Table relationships
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
B. Document ID fields
Source: SNAF (Xanadu) > Table Administration > Table relationships
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
B. Many-to-Many
Source: SNAF (Xanadu) > Table Administration > Table relationships