Database Administration and CMDB →hardMultiple ChoiceObjective-mapped

SNOW-CSA Database Administration and CMDB Practice Question

Exhibit

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

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

⚠ Common exam trap

ServiceNow often tests the misconception that a Business Rule updating a related record's timestamp is for logging or deletion, when in fact it is purely for maintaining a freshness indicator in a parent-child CI relationship.

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

✓

To update a timestamp field on the parent CI whenever a child CI is updated.

The Business Rule shown is an 'After' update rule that triggers on the 'cmdb_ci' table. It uses a 'setValue' call on the parent record (via 'current.parent') to update the 'sys_updated_on' field, which is the system timestamp. This ensures that whenever a child CI is updated, the parent CI's timestamp is refreshed, maintaining an accurate audit trail of changes in the CMDB hierarchy.

Answer analysis

Option-by-option breakdown

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

✓
To update a timestamp field on the parent CI whenever a child CI is updated.
Why this is correct
The script retrieves the parent and sets a timestamp field.
✗
To prevent updates to child CIs if the parent CI has not been updated recently.
Why it's wrong here
No condition prevents updates; it always updates the parent.
✗
To log all changes made to a CI in a custom table.
Why it's wrong here
No logging is performed; only a timestamp field is set.
✗
To delete child CIs when the parent CI is deleted.
Why it's wrong here
The script does not handle deletion; it runs on update of the child.

Go deeper

SNOW-CSA Database Administration and CMDB Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question