Database Administration and CMDB →hardMultiple ChoiceObjective-mapped

SNOW-CSA Database Administration and CMDB Practice Question

Exhibit

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

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

⚠ Common exam trap

Candidates often assume the most recently created CI (based on sys_created_on) is the most recently changed, but the question specifically asks about changes to operational_status, which requires checking the sys_audit table for that field's update history.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

CI002

The sys_audit table records the timestamp of each change to a CI's operational_status field. CI002 has the most recent sys_audit record for operational_status, indicating it was changed last. The correct answer is B because the audit trail shows CI002's status was updated after CI001's.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Both CI001 and CI002
Why it's wrong here
Only CI002 has a more recent change.
✓
CI002
Why this is correct
Record 5 is the most recent and shows a change to CI002.
✗
Cannot be determined
Why it's wrong here
The order is chronological; the last entry is the most recent.
✗
CI001
Why it's wrong here
CI001's last operational_status change is earlier (record 3).

Go deeper

SNOW-CSA Database Administration and CMDB Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question