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

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

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 2

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 3

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 4

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 5

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.

Question 6

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

Accepted Answer

The serial_number field is empty, but the rule requires it to be non-empty.. The identification rule fails because the serial_number field, which is defined as a required identifier field in the rule configuration, is empty in the incoming payload. ServiceNow CMDB identification rules use a set of fields to uniquely identify CI records; if any required field is missing or null, the rule cannot match or create a record, resulting in a failure. In this case, the payload contains the serial_number field but with no value, which the rule treats as a violation of its non-empty constraint.

Answer

The name field is missing from the payload.

Answer

The rule has a dependency that is not satisfied.

Answer

The ip_address field is not included in the identification rule.

Question 7

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?

Accepted Answer

Create a reconciliation rule that gives Discovery higher priority than SCCM for the os_version attribute on the Windows Server CI class.. Reconciliation rules allow you to define attribute-level priority between data sources without blocking SCCM from updating other attributes. By creating a rule that gives Discovery higher priority than SCCM specifically for the os_version attribute on the Windows Server CI class, Discovery's value will be authoritative for that attribute while SCCM can still update other attributes. This approach preserves the multi-source CMDB integrity without disabling reconciliation or removing SCCM entirely.

Answer

Remove SCCM as a data source for these servers.

Answer

Disable reconciliation for the Windows Server CI class.

Answer

Set the 'Preserve manual changes' flag on the CI class.

Question 8

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?

Accepted Answer

The missing servers are classified under a different CMDB class than the one being queried.. The CMDB organizes CIs into a hierarchical class structure (e.g., cmdb_ci_server, cmdb_ci_win_server). If a Windows server is classified under a different parent class (e.g., cmdb_ci_linux_server due to misclassification or a custom class), a query filtering specifically on the Windows server class will exclude it. Discovery populates the CI with the correct class based on the identification and classification rules, but manual reclassification or an incorrect identification rule can place the CI in a different class, making it invisible to class-specific queries.

Answer

The missing servers are duplicates and have been merged into other CIs.

Answer

The missing servers have a status of 'Retired' in the CMDB.

Answer

The user running the query does not have the cmdb_read role.

Question 9

Refer to the exhibit. What is the primary purpose of this Business Rule?

Accepted Answer

To update a timestamp field on the parent CI whenever a child CI is updated.. The Business Rule shown is an 'After' update rule that triggers on the 'cmdb_ci' table. It uses a 'setValue' call on the parent record (via 'current.parent') to update the 'sys_updated_on' field, which is the system timestamp. This ensures that whenever a child CI is updated, the parent CI's timestamp is refreshed, maintaining an accurate audit trail of changes in the CMDB hierarchy.

Answer

To prevent updates to child CIs if the parent CI has not been updated recently.

Answer

To log all changes made to a CI in a custom table.

Answer

To delete child CIs when the parent CI is deleted.

Question 10

Drag and drop the steps to create a new user in ServiceNow into the correct order.

Accepted Answer

Navigate to User Administration > Users, click New, enter mandatory fields (User ID, Email), then click Submit.. Creating a new user in ServiceNow requires navigating to the Users module, clicking New to open a blank record, entering mandatory fields like User ID and Email, and finally submitting the form. Skipping or reordering steps leads to errors or missing fields.

Answer

Navigate to User Administration > Users, enter mandatory fields, click New, then click Submit.

Answer

Navigate to User Administration > Users, click New, click Submit, then enter mandatory fields.

Answer

Click New, navigate to User Administration > Users, enter mandatory fields, then click Submit.

Question 11

Drag and drop the steps to configure a new Catalog Item in ServiceNow into the correct order.

Accepted Answer

Create a new Catalog Item record, then add variables, then define the workflow/approval process, then set availability and submit.. The correct order to configure a new Catalog Item in ServiceNow is: first create the catalog item record to establish the basic structure; then add variables to define the questions users will answer; next, optionally define a workflow or approval process to handle fulfillment; finally, set the availability to make the item active and submit. This sequence ensures all necessary components are in place before making the item visible to users.

Answer

Create a new Catalog Item record, then set availability and submit, then add variables, then define the workflow/approval process.

Answer

Add variables, then create a new Catalog Item record, then define the workflow/approval process, then set availability and submit.

Answer

Define the workflow/approval process, then create a new Catalog Item record, then add variables, then set availability and submit.

Question 12

Match each database table type to its description.

Accepted Answer

Core table: A base table that contains common fields used by many other tables.. Understanding table types is key for data modeling in ServiceNow. Core tables provide common fields, extension tables inherit from parents, task tables track work, and journal tables store logs.

Answer

Core table: A table that inherits fields and behaviors from a parent table.

Answer

Extension table: A base table that contains common fields used by many other tables.

Question 13

Match each ServiceNow update set state to its meaning.

Accepted Answer

Draft: The update set is in the initial stage and is not yet ready for review.. Update set states track progress: Draft (building), Complete (ready), Testing (validating), Committed (applied). Common confusions involve mixing Committed with Draft or Testing with Complete.

Answer

Draft: The update set has been applied to the target instance.

Answer

Complete: The update set is being validated in a test environment.

Question 14

A CMDB administrator wants to identify which user last updated a CI record. Which table contains this information?

Accepted Answer

sys_audit. The sys_audit table stores the audit history of all field-level changes made to CI records, including the user who made the update, the timestamp, and the old and new values. When a CMDB administrator needs to identify the last user to update a CI, querying sys_audit with the appropriate filter on the record's sys_id and ordering by the 'sys_created_on' field descending will reveal the most recent change and its author.

Answer

sys_user

Answer

sys_ci

Answer

sys_metadata

Question 15

A ServiceNow administrator needs to create a database view that combines data from the cmdb_ci_server table and the cmdb_ci_netgear table. What is the correct method to achieve this?

Accepted Answer

Use the Database Views module to create a view with join conditions.. The Database Views module in ServiceNow allows administrators to create a view that combines data from multiple tables using SQL-like join conditions. This is the standard, no-code method to create a virtual table that merges fields from cmdb_ci_server and cmdb_ci_netgear without modifying the underlying schema or duplicating data.

Answer

Use the CMDB Explorer to merge CI classes.

Answer

Write a custom script to join tables and store results in a new table.

Answer

Create a report and save it as a view.