CSA - ServiceNow System Administrator Database Schema and Tables Questions and Answers

Question 1

A system administrator needs to visualize the database structure for the Incident table, including which tables it extends and which tables extend it. Which ServiceNow feature provides a graphical representation of these table relationships?

Accepted Answer

Schema Map

Answer

The Schema Map provides a visual representation of table relationships, showing details like which tables extend the current table and which tables are referenced by it. This is the correct tool for understanding the database structure in a graphical format.

Question 2

A developer is creating a new custom table for a specific application. This table will inherit all of the fields and functionality from the Task [task] table, such as 'State', 'Priority', and 'Assignment Group'. In this scenario, the new custom table is considered a __________ table.

Accepted Answer

Child

Answer

When a table extends another table, it is called a child table. The child table inherits all the fields, scripts, and business rules of the parent table. The Task [task] table is a common parent table in ServiceNow.

Question 3

Which of the following BEST describes a 'base table' in the ServiceNow schema?

Accepted Answer

A table that is extended by other tables but does not extend any other table itself.

Answer

A base table is a foundational table in the hierarchy. It can be extended by other tables (becoming a parent), but it does not extend another table (it has no parent). The Task [task] and CMDB [cmdb] tables are common examples of base tables.

Question 4

An administrator wants to change the default value of the 'State' field for Incident records to 'In Progress' without affecting the default value for Problem or Change records, which also use the 'State' field from the parent Task table. What is the appropriate mechanism to achieve this?

Accepted Answer

Dictionary Override

Answer

A Dictionary Override is used to change the properties of a field on a child table without affecting the parent table. Since Incident, Problem, and Change are all child tables of Task, a dictionary override allows the administrator to modify the 'State' field's behavior specifically for the Incident table.

Question 5

The 'caller_id' field on the Incident form allows a user to select a record from the User [sys_user] table. This establishes a one-to-many relationship between the User and Incident tables. What type of field is 'caller_id'?

Accepted Answer

Reference

Answer

A Reference field stores the unique sys_id of a record on another table, creating a relationship between the two tables. The 'caller_id' field on the Incident table references the User [sys_user] table, allowing users to look up and select a specific user record.

(CSA) ServiceNow System Administrator Certification Practice Test

(CSA) ServiceNow System Administrator Certification Practice Test

CSA - ServiceNow System Administrator Database Schema and Tables Questions and Answers