SNOW-CSA Database Administration and CMDB Practice Test 1 — 15 Questions

Question 1

Which TWO are valid methods to populate the CMDB with configuration items?

Accepted Answer

Running ServiceNow Discovery to automatically identify and populate CIs.. ServiceNow Discovery (B) automatically scans the network and populates the CMDB with CIs identified through probes and sensors. Importing a CSV file using the Import Set feature (E) is also a valid method, as it allows structured data to be loaded into the CMDB via a staging table and transform maps. Option C, manually creating CIs, is not considered a 'populate' method as it is a manual, one-at-a-time entry. Option A, the 'CMDB Import' application, does not exist as a standard application. Option D, LDAP integration, synchronizes users and groups, not CIs.

Answer

Using the 'CMDB Import' application to upload data from external tools.

Answer

Manually creating CIs using the 'New' button on the CMDB module.

Answer

Configuring LDAP integration to synchronize user and computer objects.

Question 2

An administrator is investigating a performance issue where a script that queries the task table with a JOIN to the cmdb_ci table is slow. Which two actions can improve query performance? (Select two.)

Accepted Answer

Add an index on the task table's cmdb_ci field.. Adding an index on the `cmdb_ci` field of the `task` table allows the database to quickly locate matching rows without scanning the entire table, significantly speeding up the JOIN operation. In ServiceNow, indexes are database-level structures that reduce I/O and improve query performance for filtered or joined columns. Option D is incorrect because creating a database view does not improve performance – views in ServiceNow are not materialized and only store the query logic; they do not pre-join or cache data.

Answer

Increase the database connection pool size.

Answer

Replace the JOIN with a glide query using query().

Answer

Create a database view that combines the two tables.

Answer

Use a glide aggregate query to reduce data returned.

Question 3

A ServiceNow CSA is tasked with ensuring that all CIs in the CMDB have an accurate 'Asset Tag' field. Some records show 'No asset tag' as a value. Which method can prevent this in the future?

Accepted Answer

Create a data policy that requires a pattern. A data policy can enforce that the 'Asset Tag' field does not contain the specific string 'No asset tag' by using a condition script. Default values only populate the field at creation but do not prevent users from manually entering unwanted values like 'No asset tag' later. A data policy with a pattern requirement can block such invalid entries, ensuring data integrity.

Answer

Set the 'Asset Tag' field as mandatory

Answer

Use a workflow to populate the field

Answer

Configure a default value for the 'Asset Tag' field

Question 4

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?

Accepted Answer

The CI is classified under a different CI class in the CMDB.. When a CI is classified under a different CI class in the CMDB, the scheduled discovery job may not update it because discovery uses the IRE to match incoming data against existing CIs based on identification rules. If the CI's class differs from what the discovery payload expects, the IRE may fail to reconcile the record, or the update may be directed to a different class table, leaving the original CI unchanged. This is a common cause of apparent update failures when the CI is reachable and the discovery source is correctly configured.

Answer

The discovery source is not configured for this IP range.

Answer

The Identification and Reconciliation Engine (IRE) is disabled.

Answer

The cmdb_ci table ACL is set to private.

Question 5

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?

Accepted Answer

Dependency relationship (structural). A dependency relationship (structural) is the correct model because it explicitly captures the directional 'depends on' nature of the chain: a business service relies on an application, which in turn relies on a server. In ServiceNow CMDB, structural dependency relationships (e.g., 'Depends on' or 'Used by') are designed to represent these hierarchical, transitive dependencies between CIs, enabling impact analysis and root cause mapping.

Answer

Membership relationship

Answer

Ownership relationship

Answer

Connectivity relationship

Question 6

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?

Accepted Answer

The identification rule for the CI class does not include the serial number.. The identification rule determines which fields are used to uniquely identify a CI. If the serial number is not included in the identification rule, the CMDB cannot detect duplicates based on serial number, allowing multiple CIs with the same serial number but different names and IP addresses to be created. This is a common misconfiguration that leads to CI proliferation and data inconsistency.

Answer

The CMDB has a scheduled job that deletes old CIs.

Answer

The CI class has a unique constraint on the name field.

Answer

The reconciliation rule is set to 'Create' instead of 'Update'.

Question 7

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

Accepted Answer

Member of. 'Member of' is a predefined CI relationship type in ServiceNow's CMDB, used to indicate that a CI belongs to a group or cluster, such as a server being a member of a cluster. This relationship is part of the standard CMDB relationship model and is commonly used for grouping CIs like applications, clusters, or business services.

Answer

Uses

Answer

Connects to

Answer

Owns

Question 8

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

Accepted Answer

Valid credentials for the target devices. Valid credentials (Option B) are required because ServiceNow Discovery uses SNMP, SSH, WMI, or REST to probe target devices. Without correct credentials, the MID Server cannot authenticate to the device, so it cannot read configuration data or populate CI attributes in the CMDB.

Answer

The CMDB CI tables with open ACLs

Answer

The Identification and Reconciliation Engine (IRE) enabled

Question 9

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

Accepted Answer

CMDB Health Definitions with remediation tasks. CMDB Health Definitions can include remediation tasks that automatically or manually enforce compliance by correcting unauthorized changes to CI attributes. These tasks are triggered when a health score falls below a threshold, ensuring that only authorized modifications persist in the CMDB.

Answer

The Identification and Reconciliation Engine (IRE)

Answer

Scheduled Discovery jobs

Question 10

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?

Accepted Answer

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

Operating system (os)

Answer

Model ID (model_id)

Answer

Manufacturer

Question 11

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?

Accepted Answer

The identification rule for cmdb_ci_server does NOT include serial_number.. The IRE uses identification rules to determine which attributes are used for matching CIs. If the identification rule for cmdb_ci_server does NOT include serial_number, then even though a match on serial_number exists, the IRE will not consider it a match and will create a new CI. The IRE only reconciles based on the attributes defined in the identification rule.

Answer

The identification rule for cmdb_ci_server includes serial_number.

Answer

The IRE is configured to always create new records regardless of matches.

Answer

The existing CI has a different name, so IRE considers it a different CI.

Question 12

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?

Accepted Answer

A cascade delete rule on the relationship table. A cascade delete rule on the relationship table (sys_cmdb_rel_ci) ensures that when a CI is deleted, all associated relationship records are automatically removed. This maintains referential integrity in the CMDB without requiring custom scripting or manual cleanup.

Answer

An ACL that denies delete unless relationships are removed first

Answer

A CMDB health rule that flags orphaned relationships

Answer

A business rule on the CI table that deletes relationships on delete

Question 13

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?

Accepted Answer

Identification and Reconciliation Engine (IRE) with reconciliation rules. The Identification and Reconciliation Engine (IRE) with reconciliation rules is the correct feature because it allows administrators to define which data source is authoritative for specific CI attributes. When multiple sources populate the CMDB, reconciliation rules determine the priority of data sources, ensuring that attributes from a higher-priority source overwrite those from lower-priority sources, preventing incorrect overwrites.

Answer

CMDB Data Source rules

Answer

Import set transform maps

Answer

Business rules with condition on source field

Question 14

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?

Accepted Answer

The identification rule for the CI class does not include a unique hardware identifier like serial number.. ServiceNow's CMDB uses identification rules to determine whether a discovered CI is new or matches an existing record. For a physical server with multiple IP addresses, the identification rule must include a unique hardware identifier such as a serial number (e.g., from SMBIOS) to prevent duplicate CIs. Without that, the system may treat each IP address as a separate CI, even though they belong to the same server.

Answer

The discovery schedule is set to run too frequently.

Answer

The discovery job is configured to scan only the management IP.

Answer

The server has too many IP addresses for discovery to handle.

Question 15

What is the purpose of the CMDB Health Dashboard?

Accepted Answer

To monitor the completeness and compliance of CI data in the CMDB. The CMDB Health Dashboard is designed to monitor the completeness and compliance of Configuration Item (CI) data within the CMDB. It provides metrics and visualizations that help administrators identify data quality issues, such as missing mandatory fields, stale CIs, or violations of CMDB rules, ensuring the CMDB remains a reliable source of truth for IT operations.

Answer

To manage user roles and permissions for CMDB

Answer

To visualize relationships between CIs

Answer

To configure discovery schedules and probes