Question 1easymultiple choice
Read the full Database Administration and CMDB explanation →SNOW-CSA Database Administration and CMDB • Complete Question Bank
Complete SNOW-CSA Database Administration and CMDB question bank — all 0 questions with answers and detailed explanations.
Refer to the exhibit. Exhibit: ``` CMDB Query: sys_class_name: cmdb_ci_server Number of CIs: 2500 Number of CIs with missing serial_number: 800 Number of CIs with missing os: 300 Number of CIs with missing manufacturer: 150 Number of CIs with missing model_id: 200 Number of CIs with missing ip_address: 50 ```
Refer to the exhibit.
Exhibit:
```
IRE Log Entry:
Input CI: { name: 'WebServer01', serial_number: 'SN123', class: 'cmdb_ci_server' }
Match found: CI sys_id 'abc123' with serial_number 'SN123'
Action: Insert (new record created)
```Refer to the exhibit.
Error log from CMDB IRE:
```
2024-03-15 10:32:45 Error: IdentificationReconcileEngine: Class 'cmdb_ci_server' - Identification rule 'Default Server Identification' failed.
Rule definition:
- Identifier: serial_number
- Condition: serial_number IS NOT EMPTY
- Dependency: None
Source payload:
{
"name": "SRV-APP-01",
"serial_number": "",
"ip_address": "10.1.1.50"
}
```Refer to the exhibit.
Exhibit: Excerpt from a Business Rule script on the cmdb_ci table:
(function executeRule(current, previous /*null when async*/ ) {
var gr = new GlideRecord('cmdb_ci');
gr.addQuery('sys_id', current.parent.sys_id);
gr.query();
if (gr.next()) {
gr.setValue('u_last_child_update', new GlideDateTime());
gr.update();
}
})(current, previous);Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Drag a concept onto its matching description — or click a concept then click the description.
Top-level table in a class hierarchy
Table that inherits fields from a parent table
Parent table for work-related records like incidents and changes
Stores system configuration data
Stores audit trail and activity log entries
Drag a concept onto its matching description — or click a concept then click the description.
Update set is being worked on
All changes have been captured and are ready to commit
Update set has been applied to the target instance
Update set will not be processed
Changes are reviewed before committing
Refer to the exhibit.
{
"identifier": "business_application",
"rules": [
{ "field": "name", "operator": "equals" },
{ "field": "business_service", "operator": "equals" }
],
"action": "create_or_reconcile"
}Refer to the exhibit. Running: sys_audit Showing 5 records: sys_id | record_id | fieldname | oldvalue | newvalue | user 1 | CI001 | operational_status | 1 | 2 | admin 2 | CI001 | asset_tag | null | 12345 | admin 3 | CI001 | operational_status | 2 | 1 | system 4 | CI002 | operational_status | 1 | 2 | admin 5 | CI002 | operational_status | 2 | 3 | admin
Refer to the exhibit. Name: server_by_os Tables: cmdb_ci_server (alias: s), cmdb_ci_os (alias: o) Join: s.os_id = o.sys_id Fields: s.name, s.os, o.version, o.build
```javascript
var gr = new GlideRecord('cmdb_ci');
gr.addQuery('sys_class_name', 'cmdb_ci_server');
gr.addQuery('u_environment', 'production');
gr.setLimit(1);
gr.orderByDesc('sys_updated_on');
gr.query();
if(gr.next()) {
gs.info(gr.getValue('name'));
}
``````json
{
"name": "Linux Server Probe",
"table": "cmdb_ci_linux_server",
"condition": "sys_class_name=cmdb_ci_linux_server AND operational_status=1",
"fields": ["name", "serial_number", "cpu_type"],
"source": "ServiceNow Discovery"
}
```A CMDB Health Dashboard shows a metric: 'Completeness: 85%', with a note: 'Fields with missing data: asset_tag, model_id, cost_center'.
Error: Target table 'u_cmdb_ci_custom' does not exist in instance.
var gr = new GlideRecord('cmdb_ci');
gr.addQuery('sys_class_name', 'cmdb_ci_server');
gr.query();
while(gr.next()){
gs.info(gr.name);
}Discovery probe output:
{
"ip": "10.0.0.1",
"class": "Network Gear",
"name": "switch-01",
"attributes": {
"snmp_location": "DataCenter A",
"model_id": "Cisco Catalyst 3850"
}
}