ServiceNow CAD Data Model Quiz

1. In ServiceNow, what does a field's 'Unique' constraint ensure?

The field value is visible only to specific users

No two records can have the same value in that field

The field is automatically populated

The field cannot be modified after creation

2. In ServiceNow, which system field tracks the user who last modified a record?

Sys_created_by

Sys_updated_by

Sys_modified_user

Sys_owner

3. What does 'denormalization' mean in ServiceNow data modeling?

Removing all reference fields from tables

Storing redundant data to improve query performance

Creating multiple copies of the same table

Deleting unused fields from a table

4. In ServiceNow, what is the purpose of a 'Display Value'?

To show the internal ID of a record

To show a human-readable value for a reference field instead of sys_id

To calculate field totals on forms

To hide sensitive data from users

5. Which of the following describes a 'One-to-Many' relationship?

One record in table A relates to one record in table B

One record in table A can relate to many records in table B

Many records in table A relate to many records in table B

No relationship exists between tables

6. What is a 'sys_class_name' field used for in ServiceNow?

To identify which table a record belongs to in an inheritance hierarchy

To classify user roles

To store CSS class names for display

To define workflow states

7. In ServiceNow, what does the 'Read Access Control List' (ACL) restrict?

Which fields can be edited on a form

Who can view records in a table

Which tables can be created

How many records a user can access

8. What is a 'polymorphic reference' in ServiceNow?

A reference field that can point to multiple different tables

A field that automatically duplicates data

A relationship that only works one direction

A field that stores encrypted data

9. Which field type would you use to store a large amount of formatted text in ServiceNow?

String

Text

HTML

Long Text

10. What is the 'company' field typically used for in ServiceNow?

To store the employee's department

To indicate the organization or company associated with a record

To track business unit revenue

To define user access permissions

11. What is the primary purpose of a table in ServiceNow's data model?

To store and organize related data records

To display information on user dashboards

To execute business logic scripts

To manage user authentication

12. What is a 'Choice' field in ServiceNow used for?

To store unlimited text entries

To provide a dropdown list of predefined values

To link to another table

To calculate numeric values

13. Which system field in ServiceNow automatically records when a record was created?

Sys_updated_on

Sys_created_on

Sys_updated_by

Sys_created_by

14. What is the purpose of the 'Active' field commonly found in ServiceNow tables?

To track when a record was last modified

To indicate whether a record is currently in use or retired

To store the user who created the record

To define the record's priority level

15. In ServiceNow, what does a field's 'mandatory' attribute control?

Whether the field appears on a form

Whether a value must be entered before saving a record

Whether the field is visible to all users

Whether the field can be edited

16. What is a Many-to-Many relationship in ServiceNow?

One record in table A relates to many records in table B

Many records in table A relate to many records in table B through a junction table

Multiple instances of the same table

A relationship that cannot be queried

17. Which of the following is a best practice when designing a ServiceNow data model?

Create one large table for all data

Normalize data to reduce redundancy and improve performance

Use only text fields for simplicity

Avoid using reference fields

18. What is table inheritance in ServiceNow?

Copying all fields from one table to another

A child table extending a parent table's structure and fields

Linking two tables with a foreign key

Duplicating table records automatically

19. In ServiceNow, what does the 'sys_id' field represent?

The system identifier for each unique record

The table name identifier

The user's session ID

The application version number

20. Which field type in ServiceNow allows you to reference records from another table?