SNOW-CSA Practice Test 13 — 15 Questions

Question 1

An administrator notices that a reference field on the cmdb_ci table, 'vendor', points to the 'core_company' table. However, some users report that they cannot select certain companies in the reference field. What is the most likely cause?

Accepted Answer

The 'vendor' field has a reference qualifier that filters companies. Option C is correct because reference qualifiers are used to filter the records displayed in a reference field. If the 'vendor' field has a reference qualifier condition (e.g., 'active=true' or 'vendor_type=hardware'), only companies meeting that condition will appear in the dropdown, preventing users from selecting certain companies. This is the most likely cause when users cannot see specific records in a reference field.

Answer

The 'display field' property is incorrectly configured

Answer

The 'vendor' field is marked as mandatory

Answer

The database view permission is set to 'none' for some users

Question 2

Refer to the exhibit. What is the purpose of the 'condition' field in this discovery probe?

Accepted Answer

It filters which discovered CIs should be updated by this probe.. In ServiceNow discovery probes, the 'condition' field is used to filter which discovered CIs should be updated by the probe. It acts as a predicate that evaluates against the discovered CI's attributes; only CIs that match the condition will have their fields updated by the probe's actions. This prevents the probe from overwriting CIs that do not meet specific criteria, ensuring targeted and accurate CI updates.

Answer

It defines the condition under which the probe triggers.

Answer

It specifies the condition for identifying duplicates.

Answer

It limits the probe to only query the database for existing records matching the condition.

Question 3

A custom table called 'u_cmdb_ci_application' has been created to extend cmdb_ci. After importing data into this table, the new records do not appear in the 'Configuration Items' module. What is the most likely reason?

Accepted Answer

The 'sys_class_name' field was not set to 'u_cmdb_ci_application' during import.. The Configuration Items module typically shows records from the base cmdb_ci table and its children. If the new table is not properly defined as an extension of cmdb_ci, or if it lacks the required fields like 'sys_class_name', it may not be recognized. However, the most common issue is that the import did not set the 'sys_class_name' field correctly, so the records are seen as base table entries or not at all.

Answer

The import set used the wrong transform map.

Answer

The table was created in the wrong application scope.

Answer

The user does not have access to the custom table.

Question 4

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?

Accepted Answer

Review and refine the identification rules to ensure uniqueness criteria are correctly defined.. Option C is correct because 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

Increase the reconciliation engine's timeout value.

Answer

Run the CI Class Manager to delete duplicate CIs.

Answer

Disable all identification rules and use manual reconciliation.

Question 5

A new administrator needs to view the relationships between CIs. Which TWO tables store information about CI relationships? (Select two.)

Accepted Answer

cmdb_rel_type. Option B is correct because the `cmdb_rel_type` table defines the types of relationships that can exist between configuration items (CIs), such as 'Depends on' or 'Runs on'. Option C is correct because the `cmdb_rel_ci` table stores the actual relationship instances, linking two CIs together with a specific relationship type. Together, these two tables provide the schema and data for CI relationships in the ServiceNow CMDB.

Answer

cmdb_ci_service

Answer

cmdb_ci

Answer

cmdb_ci_relationship

Question 6

An administrator notices that a custom table 'u_custom_infrastructure' was created as a child of 'cmdb_ci'. However, records in this table are not appearing in the CMDB dashboard reports that show all CIs. What is the likely reason?

Accepted Answer

The table is not included in the 'CMDB Base Class' report definition. CMDB reports typically use the 'cmdb_ci' base table. Custom child classes must be included in report definitions if they are not automatically included. The table might be excluded due to class hierarchy filtering. Table permissions would prevent viewing but not necessarily reporting. Data certification would flag data quality. Sharing settings do not affect reporting.

Answer

The table has permissions that restrict report access

Answer

The records have not passed data certification

Answer

The table's 'Display in CMDB dashboard' property is disabled

Question 7

An administrator wants to improve the performance of a report that aggregates data from a large custom table. Which database administration technique is most effective?

Accepted Answer

Use a glide aggregate query with a group by clause.. Option D is correct because GlideAggregate performs aggregation server-side, reducing data transfer and improving performance. Option A is incorrect because indexing sys_updated_by may not help aggregation. Option B is incorrect because a view pre-aggregates but is static and may not reflect live data. Option C is incorrect because archiving reduces table size but is not a performance optimization for current queries.

Answer

Create a database view that pre-aggregates the data.

Answer

Schedule a job to archive old records.

Answer

Add an index on the table's sys_updated_by field.

Question 8

A junior administrator wants to see which CIs have been updated in the last 24 hours. Which table contains the change log for CMDB CIs?

Accepted Answer

cmdb_ci_history. The `cmdb_ci_history` table is specifically designed to track changes to CMDB CIs, including updates made in the last 24 hours. It stores historical snapshots of CI attribute changes, making it the correct table for a junior administrator to query for recent CI updates.

Answer

sys_journal_field

Answer

sys_audit

Answer

cmdb_ci

Question 9

An administrator needs to enforce data consistency in the CMDB. Which two methods are effective for ensuring CI data quality? (Choose two.)

Accepted Answer

Configuring data certification policies.. Data certification policies in ServiceNow allow administrators to define rules that automatically validate CI data against specified criteria, such as mandatory fields or value ranges, and flag or correct non-compliant records. This proactive enforcement ensures ongoing data consistency without manual intervention, making it a core method for maintaining CMDB data quality.

Answer

Exporting CMDB data to CSV for manual review.

Answer

Running the CI Class Manager regularly.

Answer

Setting up reconciliation rules.

Question 10

Which table is the base table for all configuration items in the CMDB?

Accepted Answer

cmdb_ci. The `cmdb_ci` table is the base (parent) table for all configuration items in the CMDB. It contains common attributes such as name, sys_class_name, and operational status, and all specialized CI tables (like `cmdb_ci_server`, `cmdb_ci_storage`, and `cmdb_ci_network`) extend from it via class inheritance. This hierarchical structure ensures that any CI record, regardless of its specific type, has a corresponding row in `cmdb_ci`.

Answer

cmdb_ci_storage

Answer

cmdb_ci_server

Answer

cmdb_ci_network

Question 11

During a CMDB health assessment, an administrator finds that the 'cmdb_ci_computer' table has 5000 records, but only 3000 have an 'operational_status' of 'In Use'. The administrator wants to view only the records with 'In Use' status in the CMDB reports. What is the most efficient approach?

Accepted Answer

Create a report with a condition where operational_status = 'In Use'. Option C is correct because the most efficient approach to view only records with 'In Use' status in CMDB reports is to apply a condition directly within the report definition. This method filters the data at query time without altering the underlying table structure or affecting other users, ensuring that the report shows only the desired subset of records while preserving the full dataset for other purposes.

Answer

Change the 'Display condition' of the table

Answer

Create a domain separation for 'In Use' CIs

Answer

Modify the table's 'Condition Builder' to only show 'In Use' records

Question 12

An administrator wants to ensure that the CMDB remains accurate after a change management process. Which TWO actions should the administrator take? (Select two.)

Accepted Answer

Use CI Change Request to link CIs to change requests.. Running CMDB Health Verification helps identify stale or incorrect CIs. Enabling CI Change Request links CIs to change requests, automatically updating status. Option A (CI Class Manager) is for structure, not accuracy. Option C (Data Manager) is for bulk updates. Option D (business rule) is a custom approach, not a standard best practice.

Answer

Create a business rule to update CI status when a change request is approved.

Answer

Set up CMDB Data Manager to automatically update CIs based on change requests.

Answer

Enable CMDB CI Class Manager to enforce class hierarchy.

Question 13

An administrator needs to archive old incident records to reduce the size of the incident table. Which approach is recommended for optimal performance?

Accepted Answer

Use the 'Archive' functionality in the Application Navigator.. Option C is correct because ServiceNow's built-in Archive functionality is designed to move old records efficiently while maintaining referential integrity. Option A is wrong because direct database deletion bypasses application logic and can cause data corruption. Option B is wrong because the 'Delete Records' module is for deletion, not archival. Option D is wrong because manual copy-and-delete is error-prone and not scalable.

Answer

Use the 'Delete Records' module to remove records older than 6 months.

Answer

Delete records older than 6 months directly from the database.

Answer

Create a scheduled job to copy records to a custom table and then delete from incident table.

Question 14

A company has a large CMDB and wants to improve query performance on CI tables. Which two actions would help achieve this? (Choose two.)

Accepted Answer

Adding indexes to frequently queried columns.. Adding indexes to frequently queried columns (Option A) improves query performance by allowing the database to locate rows more efficiently, reducing full table scans. This is a standard database optimization technique that directly addresses slow CI table queries in ServiceNow.

Answer

Disabling all CMDB audit history.

Answer

Increasing the database heap size.

Answer

Using the CI Cache feature.

Question 15

Your organization uses multiple data sources to populate the CMDB, including ServiceNow Discovery, manual imports, and integrations with an external asset management system. Recently, you have noticed that some CIs appear to be duplicated despite having identification rules configured. Investigation reveals that the identification rules are not correctly matching CIs from the external system. What should you do to resolve the duplication without losing existing relationships?

Accepted Answer

Modify the identification rule to include a unique identifier from the external system.. Option C is correct because modifying the identification rule to include a unique identifier from the external system will allow the IRE to correctly match existing CIs. Option A is wrong because manual merging is time-consuming and may not prevent recurrence. Option B is wrong because deleting and re-importing could remove change history and relationships. Option D is wrong because disabling the integration stops data flow and does not fix the existing duplicates.

Answer

Delete all CIs from the external system and re-import.

Answer

Manually merge all duplicate CIs using the UI.

Answer

Disable the external integration to prevent further duplicates.