Courseiva

SNOW-CSA · topic practice

Database Administration and CMDB practice questions

Practise ServiceNow Certified System Administrator CSA Database Administration and CMDB practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Reviewed byJohnson Ajibi· MSc IT Security
20 questionsDomain: Database Administration and CMDB
Practice 10 questionsBrowse domain →

What the exam tests

What to know about Database Administration and CMDB

Database Administration and CMDB questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Watch out for

Common Database Administration and CMDB exam traps

  • ▸Answering from memory before reading the full scenario.
  • ▸Missing a constraint such as cost, availability, security, scope or command context.
  • ▸Choosing a broad answer when the question asks for the most specific fix.
  • ▸Ignoring why the wrong options are tempting.

Practice set

Database Administration and CMDB questions

20 questions · select your answer, then reveal the explanation

Question 1easymultiple choice
Read the full Database Administration and CMDB explanation →

A ServiceNow administrator notices that a CI record in the CMDB is not being updated by a scheduled discovery job. The CI is a Linux server that is reachable on the network. Which is the most likely cause?

Question 2mediummultiple choice
Read the full Database Administration and CMDB explanation →

A consultant is designing the CMDB for a large enterprise. The company wants to track relationships between business services, applications, and infrastructure components. Which relationship model should be used to represent that a business service depends on an application, which in turn depends on a server?

Question 3hardmultiple choice
Read the full Database Administration and CMDB explanation →

During a CMDB health review, an administrator finds that many CI records have the same serial number but different names and IP addresses. What is the most likely root cause?

Question 4easymulti select
Read the full Database Administration and CMDB explanation →

Which TWO of the following are valid CI relationship types in ServiceNow?

Question 5mediummulti select
Read the full Database Administration and CMDB explanation →

Which THREE of the following are required for ServiceNow Discovery to successfully populate the CMDB?

Question 6hardmulti select
Read the full Database Administration and CMDB explanation →

A company wants to ensure that only authorized changes to the CMDB are allowed. Which THREE of the following mechanisms can help enforce this?

Question 7mediummultiple choice
Read the full Database Administration and CMDB explanation →

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?

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
```
Question 8hardmultiple choice
Read the full Database Administration and CMDB explanation →

An administrator inspects the IRE log and sees the exhibit. The IRE created a new CI despite finding a match on serial_number. What is the most likely reason?

Exhibit

Refer to the exhibit.

Exhibit:
```
IRE Log Entry:
  Input CI: { name: 'WebServer01', serial_number: 'SN123', class: 'cmdb_ci_server' }
  Match found: CI sys_id 'abc123' with serial_number 'SN123'
  Action: Insert (new record created)
```
Question 9easymultiple choice
Read the full Database Administration and CMDB explanation →

An administrator wants to ensure that when a user deletes a CI, all its relationships are also deleted to maintain data integrity. What should the administrator configure?

Question 10mediummultiple choice
Read the full Database Administration and CMDB explanation →

A company is using multiple data sources (Discovery, SCCM, and manual imports) to populate the CMDB. They notice that some CI attributes are being overwritten incorrectly. Which feature should be used to define which data source is authoritative for specific attributes?

Question 11hardmultiple choice
Read the full Database Administration and CMDB explanation →

An administrator discovers that a scheduled discovery job is creating duplicate CI records for the same physical server. The server has two IP addresses (one for management, one for production). What is the most likely cause?

Question 12easymultiple choice
Read the full Database Administration and CMDB explanation →

What is the purpose of the CMDB Health Dashboard?

Question 13hardmultiple choice
Read the full Database Administration and CMDB explanation →

A large financial institution uses ServiceNow CMDB to manage their IT infrastructure. They have a complex environment with multiple data sources: Discovery, SCCM, and a custom integration from their cloud provider. The CMDB contains over 100,000 CIs. Recently, the CMDB team noticed that for a specific set of Windows servers, the 'os_version' attribute is being updated to an incorrect value every night. The value comes from the SCCM integration, which is supposed to be the authoritative source for software-related attributes. However, the 'os_version' attribute should be authoritative from Discovery. The IRE is configured with reconciliation rules, but the issue persists. The team also finds that the Discovery job for these servers runs at 2:00 AM, and the SCCM integration runs at 3:00 AM. The incorrect value appears after the SCCM run. The reconciliation rules are set so that Discovery is authoritative for 'os_version', but the SCCM integration still overwrites it. What is the most likely cause and recommended action?

Question 14mediummultiple choice
Read the full Database Administration and CMDB explanation →

A company uses ServiceNow CMDB and wants to ensure that CI attribute updates from a discovery tool are not overwritten by manual changes made by administrators. Which configuration best achieves this?

Question 15hardmultiple choice
Read the full Database Administration and CMDB explanation →

An organization is planning to implement CMDB for a large-scale environment with multiple data sources. They need to ensure that the most trustworthy data source takes precedence when conflicts occur. Which feature should they use?

Question 16easymultiple choice
Read the full Database Administration and CMDB explanation →

A CMDB administrator notices that duplicate CIs are being created for the same server from different discovery sources. What is the most likely cause?

Question 17mediummulti select
Read the full Database Administration and CMDB explanation →

Which TWO statements about ServiceNow CMDB identification and reconciliation are correct?

Question 18hardmultiple choice
Read the full Database Administration and CMDB explanation →

Based on the exhibit, why did the identification rule fail?

Exhibit

Refer to the exhibit.

Error log from CMDB IRE:
```
2024-03-15 10:32:45 Error: IdentificationReconcileEngine: Class 'cmdb_ci_server' - Identification rule 'Default Server Identification' failed.
Rule definition:
- Identifier: serial_number
- Condition: serial_number IS NOT EMPTY
- Dependency: None
Source payload:
{
 "name": "SRV-APP-01",
 "serial_number": "",
 "ip_address": "10.1.1.50"
}
```
Question 19hardmultiple choice
Read the full Database Administration and CMDB explanation →

Your organization has implemented ServiceNow CMDB with multiple data sources including ServiceNow Discovery, SCCM, and manual imports. You notice that for a critical group of Windows servers, the 'os_version' attribute is being overwritten frequently. Upon investigation, you find that Discovery reports the correct version, but SCCM imports an older version that overwrites it. The Discovery source runs daily at 2 AM, and SCCM imports run at 4 AM. Currently, all data sources have equal priority. You need to ensure that the Discovery value is the authoritative source for os_version on these servers, but you do not want to block SCCM from updating other attributes. What is the best course of action?

Question 20mediummultiple choice
Read the full Database Administration and CMDB explanation →

A company's CMDB has been populated with configuration items (CIs) from various discovery sources. However, when querying the CMDB for all Windows servers, the result set is missing some servers that are known to exist. The administrator has verified that the servers are discovered and appear in the discovery logs. What is the most likely cause of this issue?

Continue with 20-question session →

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Sign up freeLog in

Focused Database Administration and CMDB sessions

Start a Database Administration and CMDB only practice session

Every question in these sessions is drawn from the Database Administration and CMDB domain — nothing else.

10 questions20 questions30 questions50 questions
Browse all Database Administration and CMDB questions →Mixed SNOW-CSA session

Related practice questions

Related SNOW-CSA topic practice pages

Move into related areas when this topic feels solid.

Reporting, SLA and Imports practice questions

Practise SNOW-CSA questions linked to Reporting, SLA and Imports.

Self-Service and Automation practice questions

Practise SNOW-CSA questions linked to Self-Service and Automation.

UI, Navigation and Forms practice questions

Practise SNOW-CSA questions linked to UI, Navigation and Forms.

Database Administration and CMDB practice questions

Practise SNOW-CSA questions linked to Database Administration and CMDB.

Service Catalog and Workflows practice questions

Practise SNOW-CSA questions linked to Service Catalog and Workflows.

Application Rules, ACL and Notifications practice questions

Practise SNOW-CSA questions linked to Application Rules, ACL and Notifications.

SNOW-CSA fundamentals practice questions

Practise SNOW-CSA questions linked to SNOW-CSA fundamentals.

SNOW-CSA scenario practice questions

Practise SNOW-CSA questions linked to SNOW-CSA scenario.

SNOW-CSA troubleshooting practice questions

Practise SNOW-CSA questions linked to SNOW-CSA troubleshooting.

Frequently asked questions

What does the SNOW-CSA exam test about Database Administration and CMDB?
Database Administration and CMDB questions test whether you can apply the concept in context, not just recognise a definition.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Database Administration and CMDB questions in a focused session?
Yes — the session launcher on this page draws every question from the Database Administration and CMDB domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other SNOW-CSA topics?
Use the topic links above to move to related areas, or go back to the SNOW-CSA question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the SNOW-CSA exam covers. They are not copied from any real exam or dump site.