Database Administration

Question 1

Which of the following is NOT a database setting on the Application Access section of a Table?

Can Create
Can Update
Can Write
Can Read

Answer 1

Can write is NOT a database setting on the Application Access section of a Table.

Question 2

Every import must have at least one transform table?

Answer 2

True

Question 3

The CMDB aids ITSM processes by identifying:

Answer 3

• the respective support and approval groups,
  • the business criticality of affected CIs to aid in prioritisation and escalation and
  • the potential upstream or downstream impacts.

Question 4

What needs to be activated/installed to use the Configuration Management Database (CMDB) quick start tests?

Answer 4

The CMDB-ATF Tests Plugin

Question 5

Which of the following field types have a one-to-many relationship?

Answer 5

Glide List
Document ID Fields
Reference Fields

Question 6

Reference Field

Answer 6

allows a user to select a record on a table defined by the reference field. For instance, the Caller field on the Incident table allows the user to select any record on the User table.

Question 7

Which incident field is used to predict the Configuration Item and Service fields’ value via Predictive Intelligence solution definitions?

Answer 7

Short Description

Question 8

What are the four access control rules that the system creates by default when a custom table is created?

Answer 8

Delete, Write, Read, Create

Question 9

Data policies have a Condition as part of a trigger?

Answer 9

True

Question 10

Data Policies are script-free, server-side application files

Answer 10

True

Question 11

Data Policies can take different actions when the Conditions field evaluates to true or false.

Answer 11

True

Question 12

Which of the following is used to control access to features and capabilities in ServiceNow applications and modules?
Organization
Role
Department
Group

Answer 12

Role

Question 13

What CMDB table stores the basic attributes of all the configuration items?

Answer 13

CMDB_CI

Question 14

Which option allows you to update existing Target Table records when importing data from an import set?

Answer 14

Coalesce

Question 15

The ______ option allows you to update existing Target Table records when importing data from an import set.

Answer 15

Coalesce

Question 16

What table in the base system details the appropriate relationship types for a CI type, based on its class?

Answer 16

Suggested Relationships (CMDB_REL_TYPE_SUGGEST)

Question 17

What NOW Platform feature, in conjunction with field normalisation, does CMDB leverage to check a CI’s uniqueness automatically?

Answer 17

IRE (Identification and Reconciliation Engine)

Question 18

What is the system behaviour when applying a data policy to the list view to make a field read-only?

Answer 18

Field will appear to be editable, but the update will fail

Question 19

What is created by default when you create a new table?

Answer 19

Application menu with the same name
Module with the plural of the table label