ServiceNow Certified System Administration Practice

Which tables provide Data Dictionary and relationship information?

1. Incident, Problem, Change

2. Sys_dictionary, Sys_db_object, Sys_metadata

3. Sys_properties, Sys_dictionary, Sys_update_set

4. Sys_dictionary, Sys_documentation, Sys_db_object

The correct answer is: Sys_dictionary, Sys_documentation, Sys_db_object

The correct answer highlights the key tables in ServiceNow that are vital for maintaining the Data Dictionary and understanding the relationships between different database objects. The Sys_dictionary table stores all the definitions of the fields in the ServiceNow tables, including data types, default values, and other field properties. This is a central reference point for understanding the structure of any given table. The Sys_documentation table contains documentation for various tables and fields, offering further context and clarity about how fields are used within the application. Sys_db_object, on the other hand, stores metadata for all tables present in the instance, which includes table names, table types, and other structural details that define the relationships between different tables. This combination of tables provides a comprehensive view of the data structure and relationships within ServiceNow, making it essential for system administration tasks, such as table design and customization. The interaction of these tables enables administrators to fully understand the underlying database schema, which is crucial for effective system management and optimization. In contrast, the other options include tables that are more focused on specific functionalities or components that may not give a complete overview of the Data Dictionary or relationships within the ServiceNow database.