SNOW-CAD Working with Data Practice Question
A developer wants to automatically calculate the number of days an incident has been in the 'On Hold' state. Which approach is most efficient and maintainable?
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
✓
Use a business rule on state update to calculate and store the duration in a custom field.
A business rule triggered on state update can calculate the number of days an incident has been in 'On Hold' at the moment the state changes, storing the result in a custom field for persistence and real-time accuracy. Option B (report) calculates duration on demand without storing, so it cannot be used for automated workflows or historical tracking. Option C (scheduled job) runs periodically, introducing delays and inefficiency, and does not update in real time when the state changes. Option D (calculated field) cannot reference subrecords or perform complex lookups needed to determine the duration an incident has been in a specific state.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Use a business rule on state update to calculate and store the duration in a custom field.
Why this is correct
This approach is efficient and updates in real time.
- ✗
Use a report to calculate the duration on demand.
Why it's wrong here
Reports do not store the calculated value for further use.
- ✗
Use a scheduled job to recalculate and update a field daily.
Why it's wrong here
Scheduled jobs are not real-time and add overhead.
- ✗
Use a calculated field with a formula that references the 'hold_duration' field.
Why it's wrong here
Calculated fields cannot access subrecords like time entries.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SNOW-CAD question from scratch — 481 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SNOW-CAD practice question is part of Courseiva's free ServiceNow certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SNOW-CAD exam.