Database Administration and CMDB

A custom table 'u_custom_server' extends 'cmdb_ci_server' and has additional fields. The admin notices that while regular attribute updates on the parent table propagate correctly to the child, some custom fields are not being updated during discovery. What is the most likely cause?

An organization uses ServiceNow Discovery to populate the CMDB. They notice that some CIs are missing required relationships after discovery. What is the most likely reason?

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?

Given the IRE identification rule shown, what will happen when a Discovery probe sends a CI with a name that already exists in the CMDB but with a different business_service?

A company wants to ensure that when a server CI is retired, all its associated running services are automatically updated to reflect the retirement. What is the best practice?

Which TWO attributes are essential for identifying configuration items in the CMDB to ensure uniqueness? (Choose exactly 2.)

An administrator is troubleshooting issues with the CMDB identification and reconciliation engine. Which three components are part of the identification and reconciliation process? (Choose three.)

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?

A company has a custom application that automatically updates the CMDB via web services. After a recent update, several CI records were incorrectly modified, causing incorrect relationships. The administrator does not know exactly which web service calls caused the issue. What is the best way to identify the source of the incorrect updates and prevent future occurrences?

An administrator needs to create a new CI class for 'Database Instance' that extends the existing 'cmdb_ci' table. Which tool should be used?

In the CMDB, what is the purpose of the 'cmdb_ci' table?

What is the purpose of the 'Operational Status' field on a CMDB CI?

Which two statements are true about CMDB relationships? (Select two.)

A CMDB administrator is planning to use the CMDB Data Manager to perform data imports. Which THREE statements about the Data Manager are true? (Select exactly 3)

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?

A large enterprise has implemented ServiceNow CMDB with multiple discovery sources including Service Mapping, Cloud Management, and manual imports. Over the past six months, the CMDB has grown to over 2 million CI records, and users are reporting that CMDB queries and reports take a long time to load. The administrator checks the database and finds that the cmdb_ci table has over 1.5 million records, including many retired and historical CIs. The average query time for reports on active hardware CIs is 30 seconds. The instance is hosted on a standard mid-range node. The administrator has verified that no duplicate CIs exist and that all CI classes are properly configured. The instance's performance dashboard shows high database contention. Which action should the administrator take first to improve CMDB performance?

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?

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?

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?

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

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

A scheduled job runs a transform map to import data into the CMDB from an external asset management system. The transform map has a field mapping that uses script to derive the CI class based on asset type. Recently, imports have been failing with a 'GlideRecord: Invalid table name' error. What is the most likely cause?

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?

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?

A company wants to ensure that critical servers in the CMDB have accurate operational status. Which CMDB feature should the administrator configure to automatically update the operational status based on monitoring tools?

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

Refer to the exhibit. An administrator is trying to import data into a custom CI table but receives this error. What is the most likely cause?

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

Based on the sys_audit output, which CI has undergone the most recent change to its operational_status?

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?

Refer to the exhibit. What action should the administrator take to improve the completeness score?

A company has an enterprise ServiceNow instance with a CMDB that contains over 50,000 CIs. The instance is integrated with multiple discovery tools: ServiceNow Discovery, a third-party IPAM tool, and a cloud management platform. Recently, the CMDB health score dropped significantly due to an increase in duplicate CIs. Upon investigation, you find that many CIs from the IPAM tool have the same serial number as CIs discovered by ServiceNow Discovery, but with slight differences in the hardware model field. Also, the cloud management platform creates CIs with the same name but different serial numbers. The business requires that each physical device should have only one CI record, and the serial number is the authoritative identifier. The current reconciliation rules are set to merge based on name and IP address, but they are not effectively resolving duplicates. What should the administrator do to resolve this issue most effectively?

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?

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

A company is implementing a CMDB cleanup strategy and needs to identify CIs that are no longer in use. Which THREE methods can help identify outdated CIs? (Select three.)

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?

Which three are components of CMDB Reconciliation? (Select three.)

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

An administrator is managing a CMDB that contains both physical and virtual servers. The company uses a custom field 'u_os_version' to track the operating system version. When new servers are discovered, the field is populated correctly. However, when the operating system is updated manually by the IT team, the field is not updated. The administrator wants the CMDB to automatically reflect manual changes made to server operating systems. Which approach should be taken?

During a CMDB audit, an administrator discovers duplicate CI records for the same network switch. The switch is identified by its serial number. The identification rule currently uses IP address and MAC address as identifiers. What is the most likely cause of the duplicate records?

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?

A system administrator receives a request to add a new field called 'Business Impact' to the 'cmdb_ci' table. Which method should be used to ensure the field is available to all CI classes?

A consultant is designing a CMDB for a large enterprise. The data from multiple discovery tools is being imported into the CMDB. Some CIs are being duplicated due to minor differences in serial numbers. Which approach best prevents duplicates without losing data integrity?

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

Match each ServiceNow update set state to its meaning.

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?

A company wants to restrict access to CI records based on the business service they belong to. What feature should they use?

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.)

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

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?

An administrator needs to delete a large number of records from the cmdb_ci table based on a condition. Which method is recommended for bulk deletion to ensure data integrity and performance?

Which THREE of the following are best practices for CMDB data maintenance? (Choose exactly 3.)

An administrator is troubleshooting why a CMDB CI's last discovered date is not updating after a successful discovery run. The CI is in a valid state and the discovery schedule runs. What could be the cause?

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?

A report using the 'server_by_os' database view is expected to show a record for each server. However, a server without an operating system entry is not appearing in the report. What is the most likely reason?

Which TWO of the following are valid CMDB base classes? (Choose exactly 2.)

Which CMDB relationship type should be used to represent that a server is physically installed in a rack?

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?

An administrator needs to identify which CI(s) are affected by a recent network outage. Which table should be queried to find the relationship between CIs and incidents?

An administrator is asked to design a solution to prevent unauthorized changes to the CMDB. The requirement is that any update to a CI's critical attributes (e.g., serial number, model) must be logged and require an approval. Which approach should be taken?

You are a ServiceNow administrator at a mid-sized company. The CMDB currently has over 100,000 CIs, and end users report that the CI search results are slow, often taking more than 10 seconds. The database has been optimized, but the issue persists. You have noticed that many CIs have empty or outdated fields. What is the best course of action to improve search performance without impacting data integrity?

A company is implementing ServiceNow CMDB and wants to ensure that all CIs in the 'Production' environment are backed up daily. What is the best practice to achieve this?

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

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

After upgrading to a new version, a CMDB administrator notices that many CI records have been flagged as 'unverified' and their operational status changed. What is the most likely cause?

A company uses Discovery to populate the CMDB. After a recent change, some CIs are incorrectly classified as 'Network Gear' instead of 'Server'. What is the most efficient way to correct the classification for these specific CIs?

A CMDB administrator wants to ensure that all changes to CI records are tracked with the user who made the change. What system property must be set to true?

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

Which THREE of the following are valid options when configuring an Identification and Reconciliation (IRE) rule? (Select exactly 3)

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?

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?

An administrator notices that a scheduled job that queries the cmdb_ci table is taking longer than expected. The job uses a glide query with multiple encoded queries. What is the best approach to improve performance without altering the job's results?

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?

An administrator wants to ensure that CI relationship data is accurate. Which tool should be used to identify CIs that have missing or invalid relationships?

Match each database table type to its description.

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?

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?

A CMDB administrator runs a report and finds that the count of CIs in a certain class is unexpectedly low. They suspect that some CIs were deleted accidentally. How can they verify this?

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

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?

An administrator notices that a CMDB CI class is not visible in the class hierarchy. The class exists in the database but cannot be selected when creating a new CI. What is the likely cause?

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

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

Refer to the exhibit. The script runs but no output is produced. What is the most likely cause?

Refer to the exhibit. An administrator runs Discovery on a switch and receives this payload. However, the CI is not created in the CMDB. The Discovery log shows 'Identification rule did not match any CI. Creating new CI failed because of duplicate serial number?'. What is the most likely cause?

Refer to the exhibit. An administrator runs this script in a background script. The script runs without errors but does not output any CI names. All servers exist in the CMDB. What could be the issue?

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

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?

What is the purpose of the 'cmdb_rel_ci' table?

A ServiceNow administrator wants to archive old CMDB history records that are older than 12 months to improve performance. Which approach should be used?

During a CMDB audit, an administrator discovers that some CIs have a 'sys_class_name' of 'cmdb_ci' instead of a specific subclass like 'cmdb_ci_server'. What is the most likely cause?

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?

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

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

What is the purpose of the CMDB Health Dashboard?

A ServiceNow administrator is configuring Data Segmentation for CMDB. Which TWO statements are true about Data Segmentation? (Select exactly 2)