SNOW-CSA Database Administration and CMDB — 40 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

Question 16

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?

Accepted Answer

Review and correct the reconciliation rule to ensure Discovery is the authoritative source for 'os_version' and that the rule is active.. The reconciliation rule is the mechanism that dictates which data source is authoritative for a specific attribute. If the rule is misconfigured, inactive, or not properly scoped, the IRE will allow the SCCM integration to overwrite the 'os_version' attribute even though Discovery is intended to be authoritative. Reviewing and correcting the rule ensures that the IRE enforces the correct source priority for that attribute.

Answer

Enable the IRE 'Strict' mode to prevent any updates from non-authoritative sources.

Answer

Disable the SCCM integration for these servers and rely solely on Discovery.

Answer

Change the order of the integrations so that SCCM runs before Discovery.

Question 17

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?

Accepted Answer

Configure the 'Preserve manual changes' setting in the CMDB CI Class Manager.. The 'Preserve manual changes' setting in the CMDB CI Class Manager ensures that when a CI attribute is manually updated by an administrator, subsequent discovery runs will not overwrite that specific attribute. This setting works at the class level and compares the source of the last update; if the source is 'Manual', the attribute is preserved even if the discovery tool reports a different value. This directly addresses the requirement to prevent discovery from overwriting manual changes without disabling discovery entirely.

Answer

Set the CI source to 'Manual' to prevent discovery updates.

Answer

Create a business rule to prevent updates from discovery.

Answer

Disable the reconciliation process for the affected CIs.

Question 18

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?

Accepted Answer

Data Source Priority. Data Source Priority (Option D) is the correct feature because it allows administrators to define a hierarchy of data sources in the CMDB, ensuring that when multiple sources provide conflicting attribute values for the same CI, the source with the highest priority (lowest numeric value) is trusted and its data is used. This directly addresses the requirement to make the most trustworthy data source take precedence in a large-scale, multi-source environment.

Answer

Identification & Reconciliation engine

Answer

Reconciliation

Answer

Set source precedence in the CI class manager for each CI

Question 19

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

Accepted Answer

The identification rules for the CI class are not correctly defined.. Duplicate CIs occur when multiple discovery sources (e.g., Service Mapping, Discovery, or cloud APIs) identify the same server but the identification rules fail to reconcile them into a single CI. Identification rules define which attributes (such as serial number, MAC address, or FQDN) uniquely identify a CI class. If these rules are missing, incomplete, or incorrectly prioritized, the system treats each discovery event as a new CI, leading to duplicates.

Answer

The 'Prevent duplicates' flag is not enabled.

Answer

The reconciliation rules are misconfigured.

Answer

The CMDB is set to read-only mode.

Question 20

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

Accepted Answer

The Identification and Reconciliation (IRE) engine processes incoming CI data.. The Identification and Reconciliation (IRE) engine is the ServiceNow component responsible for processing incoming CI data from sources like Discovery, Service Mapping, or integrations. It applies identification rules to determine if a CI already exists and reconciliation rules to resolve attribute conflicts, ensuring data integrity in the CMDB.

Answer

The 'Source' field on a CI can be set per attribute.

Answer

Reconciliation rules are used to identify duplicate CIs.

Answer

The CMDB automatically deletes duplicate CIs when detected.