20+ practice questions focused on Working with Data — one of the most tested topics on the ServiceNow Certified Application Developer CAD exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Working with Data PracticeA developer runs a GlideAggregate to count the number of incidents per category. The query returns unexpected results: some categories show zero counts but should have incidents. What is the most likely cause?
Explanation: In GlideAggregate, after adding aggregates and grouping, the query() method must be called to execute the query. If it is omitted, no results are returned, which can explain why some categories show zero counts. Option A is incorrect because addAggregate('COUNT', 'category') is not a valid method signature; the correct approach is to use addAggregate('COUNT') and then groupBy('category'). Option B is incorrect because the issue is not related to filtering by active incidents; the query should return all incidents regardless of active status unless specified. Option D is incorrect because GlideAggregate can handle null values in grouped fields; they would typically appear as a separate group or be ignored.
An administrator wants to create a database view that joins the 'incident' and 'task' tables to show incident details with task assignments. Which table is the most appropriate base table?
Explanation: 'task' is the parent table for both 'incident' and 'task' tables. A database view created on the 'task' table can include fields from child tables like 'incident' and other task records. Option A is incorrect because 'incident' is a child table and cannot include task records that are not incidents. Option B is incorrect because 'sys_attachment' is unrelated to incident or task records. Option C is incorrect because 'task_assignment' is not a standard table in ServiceNow.
A service desk manager wants to create a report that shows the number of incidents assigned to each support group over the past month. The manager wants the report to update automatically every week and be emailed to the team leads. The developer needs to implement this efficiently without creating custom tables or scheduled jobs. Which approach should the developer take?
Explanation: ServiceNow's built-in Report module allows scheduling reports to run at specified intervals and automatically email the results to recipients, meeting all requirements without custom development. Option A (database view and data export) adds unnecessary complexity and is not the standard method for scheduled email reports. Option B (scheduled job to run a report and email results) is possible but requires custom scripting, making it less efficient than using the built-in scheduling feature. Option D (transform map and custom table) introduces overhead and is not efficient for this simple reporting need.
A company is building a ServiceNow application to manage employee onboarding. They need to store personal data like social security numbers (SSNs) and medical information. Which data classification scheme should they apply to these fields to ensure proper encryption and access controls?
Explanation: 'Highly Confidential' is the ServiceNow data classification level designed for sensitive personal data such as social security numbers and medical information. This classification enforces mandatory encryption at rest and in transit, strict role-based access controls, and audit logging, aligning with regulatory requirements like GDPR and HIPAA.
An administrator notices that a scheduled job, 'Update Asset Status', fails every night with a 'Script timeout' error. The job updates a large number of records in the Asset table. Which approach should the administrator take to resolve the timeout issue?
Explanation: The script timeout error indicates that the scheduled job is taking too long to process individual record updates. Rewriting the job to use GlideAggregate with bulk update operations reduces the number of database round-trips and processes records in batches, which is the standard approach for handling large data sets in ServiceNow without hitting script timeout limits.
+15 more Working with Data questions available
Practice all Working with Data questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Working with Data. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Working with Data questions on the SNOW-CAD frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Working with Data is tested as part of the ServiceNow Certified Application Developer CAD blueprint. Practicing with targeted Working with Data questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free SNOW-CAD practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Working with Data is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Working with Data practice session with instant scoring and detailed explanations.
Start Working with Data Practice →