SNOW-CSA Database Administration and CMDB Practice Question
Exhibit
Refer to the exhibit. Exhibit: ``` CMDB Query: sys_class_name: cmdb_ci_server Number of CIs: 2500 Number of CIs with missing serial_number: 800 Number of CIs with missing os: 300 Number of CIs with missing manufacturer: 150 Number of CIs with missing model_id: 200 Number of CIs with missing ip_address: 50 ```
An administrator runs a CMDB health report for the CI class cmdb_ci_server and sees the exhibit. Which attribute is the highest priority to populate first?
⚠ Common exam trap
The trap here is that candidates often prioritize attributes like operating system or manufacturer because they seem more relevant to server operations, but the CMDB health report specifically highlights population gaps, and serial_number is the most critical for unique CI identification and deduplication.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Serial number (serial_number)
The CMDB health report shows that the serial_number attribute has the lowest population percentage (e.g., 45%) compared to other attributes. Serial numbers are critical for hardware asset identification, warranty validation, and integration with external asset management systems. Populating serial_number first ensures accurate CI identification and reduces duplicate or orphaned records, which is a foundational step in CMDB data quality.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Operating system (os)
Why it's wrong here
300 missing, which is less than serial_number.
- ✓
Serial number (serial_number)
Why this is correct
800 missing, the highest number, and critical for identification.
- ✗
Model ID (model_id)
Why it's wrong here
200 missing, which is less than serial_number.
- ✗
Manufacturer
Why it's wrong here
150 missing, which is less than serial_number.
Go deeper
Related to this question
About these practice questions
One of 504 original SNOW-CSA practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SNOW-CSA practice question is part of Courseiva's free ServiceNow certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SNOW-CSA exam.