Extra Material (Databases) Flashcards
Within a table, a field can hold a reference to a record on another table
One to Many
Two or more tables that can be related in a bi-directional relationship
Many-to-Many
Tables that can be joined using the database views plugin
Database Views
Table that extends another table (IE: Task to Incident tables)
Extensions
3 One to many relationship fields
Reference Fields
Glide List
Document ID Fields
Extended Tables are defined as…
Tables can extend other tables, creating parent and child tables. a table that extends another table is a child
Examples of Parent Class Tables (2)
Task Table
Configuration Item table
Base Table Definition…
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
Schema maps have multiple color codes
Blue bars represent EXTENDED tables
Yellow Highlight are the focus area
Red bars are a reference table
CRUD -
Create
Read
Update
Delegate
System Admin uses 3 security modules -
Security
Access Control (ACL)
High Security Settings
Access Cntrol
Is a security rule defined to restrict the permissions of a user from viewing and interacting with data (Row level and Column level)
Access Control Definition (3 Areas) (OOP)
Object being secured (IE: Table, Field)
Valid Operation
Permissions required to access the object
Table Access Control Rules (4)
Create
Delete
Read
Write
What is specified in an access control rule?
Object and Operation being Secured
Permissions required to access
What types of permissions can be configured in an ACL?
Roles
Conditions
Script
In what order are rules evaluated?
Table Level (Specific to General)
THEN
Field Level (Specific to General)
Which objects grants access to all table records?
Table.–None–
Which elevated role is required to modify access control rules?
Security_admin
Which users can manage import set rules?
Admin
Import_admin
The ______ acts as a staging area for records imported from data source?
Import Set Table
_____ Provide a guide for moving data from import set to target tables
Transform Maps
Transform Maps
Set of field maps that define the relationships between fields in an import set table and fields in a target table
Automatic Mapping Utility
Within a table, a field can hold a reference to a record on another table
What is the first module used to load data?
Load Data
What are the steps for importing data using an import step? (4)
Load the Data
Create a Transform Map
Transform the Data
Clean up import table
Which option allows you to upodate existing target table records when importing data from an import set?
Coalesce
Which tool is used to determine relationships in fields?
Transform Map
Access to the CMDB table and underlying data requires permissions given to 4 roles
asset
ITIL
ITIL_Admin
CMDB_Read
The CSDM is …
Standard terms and definitions
Best practice for CMDB Data Modeling
Out of the Box CMDB Tables
Recommended Mappings
The CSDM is NOT
A process or implementation guide
Not a set of reports
Not a code to install
Not a SKU
Not an auto fix
What is defined as a series of tables containing assets and services?
CMDB
What is a CI?
Configuration Item
What ServiceNow product can be used to populate the CMDB?
Discovery
What are the three tables
CMDB
CMDB_CI
CMDB_REL_CI
