Courseiva
Database Administration and CMDBmediumMultiple ChoiceObjective-mapped

SNOW-CSA Database Administration and CMDB Practice Question

A company's CMDB has duplicate CIs for the same server due to conflicting identification rules. The admin notices that some CIs are being merged incorrectly. What is the best practice to resolve this issue?

⚠ Common exam trap

Watch out — candidates often confuse symptom fixes (like increasing timeouts or deleting duplicates) with the root cause solution, which is correcting the identification rules that govern CI uniqueness.

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

Review and refine the identification rules to ensure uniqueness criteria are correctly defined.

Duplicate CIs in the CMDB arise from conflicting or poorly defined identification rules. The best practice is to review and refine these rules to ensure each CI has a unique set of identifying attributes (e.g., serial number, MAC address, or FQDN). This prevents incorrect merges and maintains data integrity without relying on manual cleanup or timeout adjustments.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Increase the reconciliation engine's timeout value.

    Why it's wrong here

    Timeout adjustments do not solve conflicts in identification rules.

  • Run the CI Class Manager to delete duplicate CIs.

    Why it's wrong here

    Deleting duplicates does not prevent reoccurrence; the underlying rule issue remains.

  • Review and refine the identification rules to ensure uniqueness criteria are correctly defined.

    Why this is correct

    This addresses the root cause by correcting the rules that cause misidentification.

  • Disable all identification rules and use manual reconciliation.

    Why it's wrong here

    Disabled rules stop automated deduplication, leading to more duplicates and manual effort.

Visual reference

Client Recursive Resolver Root DNS (13 root servers) TLD DNS (.com, .org, …) Authoritative example.com query IP addr answer

Quick reference

Access Control Model Comparison

ModelAcronymWho Controls Access?Best For
Discretionary Access ControlDACResource ownerSmall teams, file shares
Mandatory Access ControlMACSystem / security labelsClassified govt / military
Role-Based Access ControlRBACAdministrator (via roles)Enterprise environments
Attribute-Based Access ControlABACPolicy engine (user + resource attributes)Fine-grained, dynamic policies
Rule-Based Access ControlRuBACSystem rules / ACLsFirewall rules, network ACLs

About these practice questions

This SNOW-CSA question is part of Courseiva's 504-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

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.