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

Question 1

You are responsible for the CMDB at a large enterprise. The CMDB is used for change management and incident management. Recently, during a major incident, it was found that several critical CIs were missing from the CMDB, causing delays in troubleshooting. Further analysis reveals that the Discovery probes were not running on those devices due to schedule conflicts. You need to ensure that all critical devices are discovered regularly. What is the most effective solution?

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

Accepted Answer

Create a dedicated Discovery schedule for critical devices with a higher frequency.. Creating a dedicated Discovery schedule for critical devices ensures they are discovered at a higher frequency without being affected by schedule conflicts that impact the general discovery schedule. This approach guarantees that critical CIs are consistently updated in the CMDB, which is essential for effective change and incident management. By isolating critical devices into their own schedule, you avoid the overhead of increasing frequency for all devices while meeting the specific requirement for regular discovery of critical assets.

Answer

Manually add the missing CIs and set a reminder to check every week.

Answer

Use horizontal discovery to prioritize critical devices.

Answer

Increase the frequency of Discovery schedules for all devices.

Question 2

You are a ServiceNow administrator for a healthcare organization. The CMDB contains sensitive patient data under strict compliance rules. You need to ensure that only authorized users can view the full details of certain CIs, while still allowing change management to reference the CIs. What is the best practice to achieve this?

Accepted Answer

Use Access Controls (ACLs) to restrict read access to the sensitive CI records.. Access Controls (ACLs) are the correct mechanism to restrict read access to sensitive CI records while still allowing Change Management to reference them. ACLs can be configured to grant read access only to authorized users or roles, and the cmdb_ci table or specific CI records can be targeted. This ensures compliance with data privacy rules without removing the CIs from the CMDB or breaking downstream processes like change requests that need to link to those CIs.

Answer

Move the sensitive CIs to a separate CMDB instance.

Answer

Encrypt the fields containing sensitive data.

Answer

Remove the sensitive CIs from the CMDB and maintain them externally.

Question 3

A ServiceNow administrator notices that the CMDB contains duplicate CI records for the same server. The duplicates were created by different discovery sources. Which TWO actions should the administrator take to resolve this issue and prevent future duplicates? (Choose two.)

Accepted Answer

Use the 'Reconcile' operation in the CMDB Workspace to manually merge the duplicates.. The 'Reconcile' operation in the CMDB Workspace allows an administrator to manually review and merge duplicate CI records, which is necessary when duplicates are created by different discovery sources and automatic rules cannot resolve the conflict. This action directly resolves the existing duplicate records by consolidating them into a single authoritative CI.

Answer

Run the 'Remove Duplicate CIs' scheduled job with the 'Delete' flag enabled.

Answer

Set the 'Identification Engine' to automatically merge duplicate CIs based on serial number.

Answer

Update the discovery source rules to exclude the duplicate server from future discovery.

Question 4

A CMDB administrator is reviewing reconciliation results and notices that a Windows server CI named 'WEB01' discovered by ServiceNow Discovery has a serial number that differs by one character from the serial number recorded by SCCM for the same physical server. The administrator wants ServiceNow to automatically keep the Discovery-sourced serial number and discard the SCCM value on future updates. Which configuration should the administrator use?

Accepted Answer

Create a CMDB Data Source precedence rule that ranks the Discovery source higher than the SCCM source for the serial number attribute.. Reconciliation in the CMDB decides which value is written when multiple discovery sources report conflicting data for the same CI. Data Source precedence is the supported mechanism: you rank sources per CI class and attribute, so the higher-ranked source wins. Ranking ServiceNow Discovery above SCCM for the serial number ensures Discovery's value is retained on future reconciliations.

Answer

Enable the 'Enforce CI uniqueness' property so duplicate serial numbers are rejected at insert time.

Answer

Modify the SCCM discovery schedule to exclude the serial number field from the payload.

Answer

Add an IRE identification rule that uses the serial number as a unique identifier for the server class.

Question 5

A CMDB administrator is preparing a cleanup effort and needs to identify configuration items that are affected by a service outage. The administrator wants to query the CMDB for CIs and their relationships so that upstream and downstream impact can be visualized. Which TWO tables should the administrator query to retrieve CI records and the relationships between them? (Choose two.)

Accepted Answer

cmdb_ci. To analyze outage impact, you need both the CIs and the links between them. The cmdb_ci table holds the CI records, and the cmdb_rel_ci table holds the relationship records that connect parent and child CIs. Querying both lets you follow dependencies and determine which CIs are upstream or downstream of the failure.

Answer

cmdb_health_result

Answer

cmdb_ci_relationship

Answer

cmdb_ci_service

Question 6

A CMDB administrator notices that a Windows server CI named 'WEB01' was created manually, and later Discovery also discovered the same server but did not merge the records. The administrator wants to ensure that future discoveries correctly identify and reconcile this CI. Which CMDB feature should be configured to define the attributes that uniquely identify a CI?

Accepted Answer

Identification and Reconciliation Engine (IRE). The Identification and Reconciliation Engine (IRE) is the ServiceNow component responsible for uniquely identifying CIs and reconciling data from multiple sources. By defining identification rules for the server class, the administrator ensures that attributes like serial number or name are used to match and merge records, preventing duplicates. This is the correct approach to resolve the existing duplicate and avoid future ones.

Answer

CMDB Health Dashboard

Answer

CI class manager

Answer

Discovery schedule

Question 7

A CMDB administrator needs to prevent a nightly import from overwriting the 'Serial number' field on existing server CIs, while still allowing the import to create new CIs and update the 'Name' field. Which feature should be configured on the import set transform to achieve this?

Accepted Answer

Ignore field in the transform map for the serial number target field. The Ignore field flag on the transform map's field map is the correct mechanism because it specifically prevents the transform from writing a value to that target field on existing records. Coalesce settings define matching, not write protection, and UI-level read-only settings do not apply to imports. This combination allows new CI creation, name updates, and serial number preservation.

Answer

Field map with 'coalesce' set to true on the serial number

Answer

Transform script with a coalesce on the serial number field

Answer

Set the serial number field to read-only on the CI form

Question 8

A service desk manager wants to ensure that when a new server CI is created in ServiceNow, it is automatically assigned to the correct support group based on the CI's class and location. The manager asks an administrator to configure a rule that sets the support group field during CI creation. Which feature should the administrator use?

Accepted Answer

A business rule on the CI table that runs before insert and sets the support group based on class and location.. To automatically set a field on CI creation, a before insert business rule on the CI table is the appropriate tool. It can read the class and location of the incoming CI and assign the correct support group before the record is saved, ensuring data consistency without manual intervention.

Answer

A CMDB Health Dashboard rule that assigns support groups to non-compliant CIs.

Answer

A CMDB CI Class Manager policy that maps support group by class and location.

Answer

A data lookup rule on the CI table that returns the support group based on class and location.

Question 9

A CMDB administrator needs to ensure that all CIs of class 'Database' have a mandatory attribute 'environment' populated with either 'Production', 'Test', or 'Development'. Which ServiceNow feature should be used to enforce this data integrity requirement?

Accepted Answer

Data Policies. Data Policies are the correct feature to enforce mandatory field values and validation rules at the database level, regardless of how the record is created or updated. By applying a Data Policy to the Database class, the administrator ensures that every CI of that class has the 'environment' field set to one of the allowed values, maintaining data integrity across all entry points.

Answer

CMDB Health Dashboard

Answer

Access Control Lists (ACLs)

Answer

UI Policies

Question 10

A CMDB administrator is troubleshooting why a Windows server CI named 'SVR-DB-01' discovered by ServiceNow Discovery is not merging with an existing CI of the same name that was manually created. The administrator confirms both records exist in the cmdb_ci_win_server table. Which feature should the administrator review to understand why the records were not unified?

Accepted Answer

CMDB Identification and Reconciliation Engine (IRE) identification rules. The Identification and Reconciliation Engine is the ServiceNow component that decides whether an incoming CI payload should update an existing record, create a new one, or be flagged as a potential duplicate. Its behavior is driven entirely by identification rules configured per CI class. Since both records reside in the same class table, the administrator must inspect the identification rule to see which attributes are used to match, and whether the manually created record contains those values.

Answer

CMDB Health Dashboard duplicate metric thresholds

Answer

Table transform maps for the CMDB

Answer

Discovery schedule blackout windows

Question 11

A service desk agent is investigating an incident related to a business application that is performing slowly. The agent needs to quickly identify all the servers that support this application. Which CMDB feature should the agent use to visualize the relationships between the application and its supporting infrastructure?

Accepted Answer

Dependency Views. Dependency Views provide a graphical map of relationships between CIs, enabling users to see how an application depends on servers, databases, and other infrastructure. This is ideal for incident investigation where understanding the supporting components is crucial. Other options like CMDB Health Dashboard focus on data quality, Service Mapping is for discovery, and CI Class Manager is for schema management, none of which provide the needed visualization.

Answer

CMDB Health Dashboard

Answer

Service Mapping

Answer

CMDB CI Class Manager

Question 12

A ServiceNow administrator needs to document the physical location of each server CI in the CMDB so that facilities staff can quickly locate hardware during maintenance. Which CI class should be used to represent the physical location records that servers will reference?

Accepted Answer

cmn_location. The cmn_location table is the base ServiceNow table for physical locations such as buildings and rooms. CI records reference locations through a field that points to cmn_location, enabling consistent reporting and filtering by site. Facilities and CMDB teams rely on this table to associate hardware with physical places, making it the correct class for documenting server locations.

Answer

cmdb_ci_rack

Answer

cmdb_ci_datacenter

Answer

cmdb_ci_server_room

Question 13

A CMDB administrator is investigating why a CI record was incorrectly marked as 'retired' even though it is still in active use. The administrator suspects that an identification and reconciliation process incorrectly matched the CI. Which ServiceNow feature should the administrator review to understand how the CI was identified and reconciled?

Accepted Answer

Identification and Reconciliation Engine (IRE) logs. The Identification and Reconciliation Engine (IRE) logs capture the matching process, including the rules applied and the resulting action. By examining these logs, the administrator can trace how the CI was identified and why it was marked as retired. Other options are either for monitoring health or querying relationships, not for auditing IRE decisions.

Answer

CMDB Query Builder

Answer

CMDB Health Dashboard

Answer

CMDB CI Class Models

Question 14

A CMDB administrator notices that a business service CI is missing several downstream application CIs in its dependency view. The administrator confirms that the application CIs exist and that relationship records connect them to the business service, but the dependency map still does not display them. Which condition should the administrator verify first?

Accepted Answer

The relationship records have a valid 'type' that is included in the dependency map's relationship type filter.. Dependency maps in ServiceNow traverse CI relationships but only those relationship types included in the map configuration. If the relationship type linking applications to the business service is excluded, those CIs are omitted from the rendered map. The administrator should inspect the map's relationship type filter and confirm the type used on the relationship records is included, which directly addresses why some connected CIs are invisible.

Answer

The application CIs are assigned to the same support group as the business service.

Answer

The business service CI has an operational status of 'Retired'.

Answer

The application CIs have a install status of 'Installed'.

Question 15

A CMDB administrator is setting up the Identification and Reconciliation Engine (IRE) to ensure that data from multiple sources, such as Discovery and SCCM, are correctly reconciled. The administrator needs to configure rules that determine how CIs are identified and how attributes are updated when conflicts arise. Which TWO of the following statements accurately describe the IRE's behavior? (Choose two.)

Accepted Answer

Identification rules are used to determine whether an incoming CI matches an existing CI in the CMDB.. Identification rules match incoming CIs to existing ones, while reconciliation rules resolve attribute conflicts by defining source precedence. These two mechanisms work together to maintain a clean and authoritative CMDB. The other statements are incorrect: the IRE does not create classes dynamically, reconciliation does not precede identification, and it supports multiple sources concurrently.

Answer

The IRE can only process data from a single data source at a time to avoid conflicts.

Answer

Reconciliation rules are applied before identification rules to ensure data is clean before matching.

Answer

The IRE automatically creates new CI classes when it encounters data that does not fit any existing class.