Module 6/7 Monitoring and Managing Data

Question 1

Which required tools are used to monitor performance in your instance?

Answer 1

Performance Dashboard
Extending Value

Question 2

System Diagnostics page

Answer 2

Is used to look for root causes of platform performance issues

Question 3

A Table

Answer 3

Is a collection of rows and columns (records and fields)

Question 4

Reference Fields are identified with…

Answer 4

a reference lookup Icon (Magnifying glass)

Question 5

Reference Fields refer to…

Answer 5

A record elsewhere, on another table

Question 6

4 Table relationship

Answer 6

One-To-Many
Many-to-Many
Database Views
Extensions

Question 7

One To Many relationship -

Answer 7

On an incident record, when you go to related records, there is a problem field. The reference to a problem record creates a one to many relationship, because several incidents may relate to that problem. From an incident we can’t indicate more than one problem for example.

Question 8

Many to Many Relationship Definition…

Answer 8

When you create a record and then a role, and a group, these are all many to many relationships.

Question 9

Groups and Roles are examples of (what type of relationship?)

Answer 9

Many to Many

Question 10

Group VIew is an example of a…(record type)

Answer 10

Many to Many Relationship. Group member record has a single name (Sys_user_GRMEMBER), which has a large list of records, junctions between reference fields (Group and User)

Question 11

Many to Many relationship Defined as

Answer 11

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

Question 12

Many to Many relationship Defined as

Answer 12

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

Question 13

One-to-Many relationship defined as

Answer 13

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

Question 14

Database Views are defined as

Answer 14

Tables that can be joined using the database views plugin (also known as a table join)

Question 15

Table Extensions are effectively where…

Answer 15

When a parent table becomes the parent of a child table, that child table inherits all of the database structure (Columns, but none of the rows)

Question 16

Task Table is a parent, base and core table (T/F?)

Answer 16

True

Question 17

Core table Types

Answer 17

Incident
User
Task

Question 18

Base Table Names

Question 19

What does a Schema Map do?

Answer 19

Schema map provides a graphical representation of other tables related to a specific table

Question 20

What colors are on the Schema Map? (THIS IS ON THE TEST)

Answer 20

Subject Table - Highlighted in Yellow
Blue Bars - Extend the subject table Further down the line (IE: Unix Servers would also have AIX, HPUX, etc.)
Red Bars - are referenced by the subject table
Green Bars - Extended Tables (all the way back to the base table) (IE: Unix Table would extend the CMDB, CMDB_CI, CMDB_CI_HW, CMDB_CI_COMPUTE)

Question 21

One-To-Many relationship fields (3)

Answer 21

Reference Fields
Glide List
Document ID Fields

Question 22

Common Many to Many example

Answer 22

Students and classes - A student can register for many classes, and a class can include many students.

Question 23

What makes a base table different than a core table?

Answer 23

A bas table is not an extension of another table, and has no parent. A base table can also be considered a parent or core table depending on circumstance

Question 24

Is CMDB_CI a base table?

Answer 24

No - This is a child and extension of the CMDB base and core table

Question 25

CRUD - Stands for...

Answer 25

Create - Read - Update - Delete

Question 26

Access Control is ....

Answer 26

a security rule defined to restrict permissions of a user from viewing and interacting with data

Question 27

Access control is set at the....

Answer 27

Row and Column Level

Question 28

Security rules can restrict your ability to view or run reports on a specific table (T/F)

Answer 28

True

Question 29

When you become a security admin by elevating roles...

Answer 29

You need to log out before you lose those privilages

Question 30

Access control rule specifies

Answer 30

Operations Objects Permissions

Question 31

Permissions include

Answer 31

Roles Conditional Expression Scripts

Question 32

Three Security Modules used by Sys Admin

Answer 32

Security Access Control (ACL) High Security Settings

Question 33

When you create a custom table servicenow creates access control rules by default (T/F)

Answer 33

True - CRWD

Question 34

When no specific ACL rule is defined then...

Answer 34

The rule applies to the whole table including all records

Question 35

table.field ACL would define...

Answer 35

Rules applying to only one field in a record

Question 36

table.*

Answer 36

This rule would apply to every field where there isn't already a table.field rule

Question 37

Table.none rule is the least specific rule, followed by table.field, and then table.*

Question 38

By Default when a read access control has been established for a new table...

Answer 38

then assume there is complete access to all fields and rows on the table

Question 39

ServiceNow starts from Generic to Specific security Policies (T/F)

Answer 39

False - ServiceNow goes from specific to general as they review security policies

Question 40

A user must pass which rules to access a record object

Answer 40

Table First Field ACL rule second

Question 41

Record ACL rules are processed in the following order:

Answer 41

Match the object against table ACL Rules (Specific to general) Match the object against Field ACL Rules (Specific to General)

Question 42

If a user passes table ACL rules and not Field ACL rules, can they access a record object?

Answer 42

No, both rules must be passed in order to access the table

Question 43

Should you grant a new role to an individual, or to a group for inheriting those roles?

Answer 43

Group is the best practice, it would be best to add a permission or ACL to a group, and then assign a user to that group

Question 44

What are import sets?

Answer 44

Import set is a tool used to import data from various data sources, and map that data into ServiceNow tables

Question 45

Import Set Tables are defined as....

Answer 45

A staging table prior to the transform label and pushing to a target table within the ServiceNow instance

Question 46

A transform map is...

Answer 46

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

Question 47

Coalesce field is...

Answer 47

A field or multiple fields that will be used as unique keys, the coalesce will override instead of update where there is a match

Question 48

IF you don't do coalescence, what will happen?

Answer 48

Data will just be treated as brand new records, and SN won't look for a match. HUGE TABLES could result

Question 49

Which roles can import data?

Answer 49

admin import_admin

Question 50

Data Source Imports can be accomplished through

Answer 50

Local Source (XML, CSV, Excel) Network Servers (LDAP), or JDBC

Question 51

What are the three main sources of data for import sets?

Answer 51

Local Data (excel, flat file) Network (LDAP) Java Database Connectivity (JDBC)

Question 52

Key CMDB system tables are (3)

Answer 52

Base Configuration Item (cmdb) Configuration Item (cmdb_ci) CI Relationship (cmdb_rel_ci)

Question 53

4 "parts" of the ITSM platform related to the CMDB

Answer 53

Incident Management Change Management Problem Management Request Management

Question 54

What are the benefits of an accurate and up to date CMDB?

Answer 54

Locate failed changes and associated INCIDENTS Facilitate impact analysis of proposed CHANGES to reduce downtime Assess PROBLEMS pertaining to specific CIs Efficiently manage INCIDENTS affecting CIs and Services

Question 55

What are the three elements of the CMDB Workspace

Answer 55

CI Search CMDB Health CI Overview CIs managed by me

Question 56

The strength of the dependency view are the...

Answer 56

relationships here, which are based off of records on a table

Question 57

Common Service Data Model is NOT

Answer 57

A process or implementation guide Not a set of reports not code not a sku or product to buy not an automatic fix for broken implementations

Question 58

CSDM Is...

Answer 58

Standard Terms Best Practices out of the box CMDB Core Tables

Question 59

ServiceNow Discovery....

Answer 59

scans the network to inventory devices and applications to update the CMDB

Question 60

ServiceNow Mapping...

Answer 60

Top Down discovery, augments the CMDB with IT relationships and dependencies between CIs and Models

Question 61

Which module can you use to create a new table?

Answer 61

Tables Tables & Columns

Question 62

Which elevated role is required to modify access control rules?

Answer 62

Security_Admin

Question 63

What does a CI?

Answer 63

Configuration Item (hardware, software, services etc.)

Question 64

A parent class that is not an extension of another table is called

Answer 64

Base Table

Question 65

In what order are access controls evaluated

Answer 65

Table Level - Specific to most general Field Level - Specific to most General

Question 66

What are the three key tables in the CMDB?

Answer 66

CMDB CMDB_CI CMDB_REL_CI