Servicenow Certified System Administrator CSA · Free Practice Question Medium
Question 22
In your implementation, the following tables extend each other:
The Configuration Item [
cmdb_ci] table extends the Base Configuration Item [cmdb] table.The Service [
cmdb_ci_service] table extends the Configuration Item [cmdb_ci] table.The Business Service [
cmdb_ci_service_business] table extends the Service [cmdb_ci_service] table.
Based on the above mapping, which table(s) are child, parent and/or base tables?
Select 4 Answers from the below options.
-
A
Service table is a Child table.
-
B
Business Service table is a Base table.
-
C
Configuration Item table is a Parent table.
-
D
Business Service table is a Parent table.
-
E
Base Configuration Item table is a Parent table.
-
F
Service table is a Base table.
-
G
Base Configuration Item table is a Base table.
-
H
Base Configuration Item table is a Child table.
Reveal correct answers
Correct answers: A, C, E, G
Explanation
A table that extends another table is called a child class, and the table it extends is the parent class. A table can be both a parent and child class, both extending and providing extensions for other tables. A parent class that is not an extension of another table is called a base class.
The Base Configuration Item [cmdb] table is the core CMDB table for non-IT CIs (descending classes are non-IT CIs).
The core Configuration Item [
cmdb_ci] table stores the basic attributes of all the CIs (descending classes are IT CIs), which extends the Base Configuration Item table.The Configuration Item table is extended to other tables, such as the Service [
cmdb_ci_service] table.The Service table is extended to the Business Service [
cmdb_ci_service_business] table.Therefore:
The Base Configuration Item table is both a parent table and a base table since it is not extending any other table.
The Configuration Item and Service tables are both child and parent tables.
The Business Service table is only a child table since no other table is extending it.
Administrators and application developers typically extend tables to create a set of related records that share information.
Screenshot: The Schema map for the Business Service table that shows the hierarchy of the extended tables
Learn more about the CMDB schema model here!
Learn more about the table extension and classes here!
Learning Domains:
Database Management - Data Schema
Database Management - CMDB and CSDM
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
