Extra Material (Databases)

Question 1

Within a table, a field can hold a reference to a record on another table

Answer 1

One to Many

Question 2

Two or more tables that can be related in a bi-directional relationship

Answer 2

Many-to-Many

Question 3

Tables that can be joined using the database views plugin

Answer 3

Database Views

Question 4

Table that extends another table (IE: Task to Incident tables)

Answer 4

Extensions

Question 5

3 One to many relationship fields

Answer 5

Reference Fields
Glide List
Document ID Fields

Question 6

Extended Tables are defined as…

Answer 6

Tables can extend other tables, creating parent and child tables. a table that extends another table is a child

Question 7

Examples of Parent Class Tables (2)

Answer 7

Task Table
Configuration Item table

Question 8

Base Table Definition…

Answer 8

A Base table is a table that serves as a “base” from which other tables may extend. From the base table, you can establish parent/child relationships

Question 9

Schema maps have multiple color codes

Answer 9

Blue bars represent EXTENDED tables
Yellow Highlight are the focus area
Red bars are a reference table

Question 10

CRUD -

Answer 10

Create
Read
Update
Delegate

Question 11

System Admin uses 3 security modules -

Answer 11

Security
Access Control (ACL)
High Security Settings

Question 12

Access Cntrol

Answer 12

Is a security rule defined to restrict the permissions of a user from viewing and interacting with data (Row level and Column level)

Question 13

Access Control Definition (3 Areas) (OOP)

Answer 13

Object being secured (IE: Table, Field)
Valid Operation
Permissions required to access the object

Question 14

Table Access Control Rules (4)

Answer 14

Create
Delete
Read
Write

Question 15

What is specified in an access control rule?

Answer 15

Object and Operation being Secured
Permissions required to access

Question 16

What types of permissions can be configured in an ACL?

Answer 16

Roles
Conditions
Script

Question 17

In what order are rules evaluated?

Answer 17

Table Level (Specific to General)
THEN
Field Level (Specific to General)

Question 18

Which objects grants access to all table records?

Answer 18

Table.–None–

Question 19

Which elevated role is required to modify access control rules?

Answer 19

Security_admin

Question 20

Which users can manage import set rules?

Answer 20

Admin
Import_admin

Question 21

The ______ acts as a staging area for records imported from data source?

Answer 21

Import Set Table

Question 22

_____ Provide a guide for moving data from import set to target tables

Answer 22

Transform Maps

Question 23

Transform Maps

Answer 23

Set of field maps that define the relationships between fields in an import set table and fields in a target table

Question 24

Automatic Mapping Utility

Answer 24

Within a table, a field can hold a reference to a record on another table

Question 25

What is the first module used to load data?

Answer 25

Load Data

Question 26

What are the steps for importing data using an import step? (4)

Answer 26

Load the Data
Create a Transform Map
Transform the Data
Clean up import table

Question 27

Which option allows you to upodate existing target table records when importing data from an import set?

Answer 27

Coalesce

Question 28

Which tool is used to determine relationships in fields?

Answer 28

Transform Map

Question 29

Access to the CMDB table and underlying data requires permissions given to 4 roles

Answer 29

asset
ITIL
ITIL_Admin
CMDB_Read

Question 30

The CSDM is …

Answer 30

Standard terms and definitions
Best practice for CMDB Data Modeling
Out of the Box CMDB Tables
Recommended Mappings

Question 31

The CSDM is NOT

Answer 31

A process or implementation guide
Not a set of reports
Not a code to install
Not a SKU
Not an auto fix

Question 32

What is defined as a series of tables containing assets and services?

Answer 32

CMDB

Question 33

What is a CI?

Answer 33

Configuration Item

Question 34

What ServiceNow product can be used to populate the CMDB?

Answer 34

Discovery

Question 35

What are the three tables

Answer 35

CMDB
CMDB_CI
CMDB_REL_CI