Module 3 - Database Administration Flashcards
What are the three ServiceNow data infrastructures?
Tables, Records, Fields
How can you access the System Dictionary?
System definition > Dictionary
What does the System Dictionary do?
Contains the definition of every table and field
Where are Numbers maintained?
System Definition > Number Maintenance
Sys_id are how long?
32 characters
How do you add columns to a table?
System Definition > Tables and columns
What are the three attributes of a field?
Field Label, Field Name, Value
Name the 4 ways tables can be related
One-to-Many, Many-to-many, Database View, and Extensions
Where do you set up a Database View?
System Definition > Database Views
What’s a base Table?
An extended table that is itself not extended IE Task
How do you set up alternate Labels for a Table?
System definition > Language File
What’s are tables called that are OOB?
Core Table
What’s a table that was created by an admin or developer?
Custom Table
What’s a schema map
A graphical representation of table relations
What two modules allow you to create tables?
Tables & Tables and Columns
What 2 things created by default when a new table is created?
Application Menu with the same name as the table
Module with the plural table names
How do you edit the title of an application menu?
Click the pencil (edit) icon or Update the Title field on the form
What is CRUD
Create, Read, Update, Delete
Name three Security layers to access data?
User Logon
Application/Module access
Database Access
What three modules are used to administer security?
System Properties>Security
System Security>Access Control (ACL)
System Security>High Security Settings
Besides CRUD there are 5 additional security operations
Execute
edit_ci_relations
save_as_template
Report_on
personalize_choices
What role allows ACL access?
security_admin
Each access control rule specified three things:
the Object (table)
permissions required (role, conditions, scripts)
Operation (CRUD)
How do you access the Access Controls easily?
table_name.CONFIG
What’s the table access order for an ACL?
Match table, match field
If you fail a Table ACL?
No access to table
If you fail a field ACL?
No access to field, still can access table
What happens if there is more than 1 rule for an ACL?
You must pass all to get access
What happens with ACL Rule Type: table.None?
No specific field so applies to the entire table
What happens with ACL Rule Type: table.field?
Rule applies to only one field
What happens with ACL Rule Type: table.*?
Rule applies to all fields without a specific field rule
Why use a wildcard in an ACL?
Reduces the number of rules needed
What is an Import set used for?
Import data and map it to tables
Import sets contain …
information regarding an import Set data source
An Import Set Table is used for …
staging records from an imported data source
Transform maps …
A set of field maps defining the relationship between import set fields and target table
Automatic Mapping Utility will do what?
It matches exact names from the import set and destination table
What does the Mapping Assist Utility do?
Visually assists mapping the import set to table fields
Coalescing a field does what?
It’s a unique key to determine if the record is inserted or updated
What happens if no Coalesce field(s) is selected
All data is imported
What does a Conditional Coalesce do?
It uses a script to determine unique records
What module is used to import data?
Load Data
What four steps import data?
Load the data, Create a transform map, Transform the data, clean up the import
What tool is used to determine a relationship between fields in an import set and an existing table
A transform map
What are the 3 key CMDB tables?
Configuration Item [cmdb]
Configuration Item [cmdb_ci] holds ci data
CI relationships [cmdb_rel_ci]
What helps you create CI Relationships?
The CI Relationship Editor
What does Service Mapping do?
discovers relationships and dependencies between discovered CI’s and automatically populates this info in the CMDB
What does MID stand for?
Management, Instrumentation, and Discovery
What do these 3 dependency view icons look like:
Triangle with !
wrench
lego
Triangle = Incident
wrench = Active Problem
Lego = Affected CIs for a Task
What is CSDM?
Common Service Data Model, a CMDB Based framework
What is a series of tables containing assets and services for my company?
CMDB (Configuration Management DataBase
What ServiceNow service populates the CMDB?
Discovery