SNOW-CAD Working with Data — 10 Questions

Question 1

A 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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

The developer forgot to call the query() method after grouping.. 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.

Answer

The developer used addAggregate('COUNT', 'category') instead of addAggregate('COUNT').

Answer

The developer must use addQuery('active', true) to include only active incidents.

Answer

The GlideAggregate cannot handle null values in the grouped field.

Question 2

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?

Accepted Answer

task. '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.

Answer

incident

Answer

sys_attachment

Answer

task_assignment

Question 3

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?

Accepted Answer

Create a report using the 'Report' module and schedule it to run weekly with email delivery.. 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.

Answer

Create a database view that aggregates the data and schedule a data export.

Answer

Create a scheduled job that runs a report and emails the results.

Answer

Create a transform map to import the incident data into a custom table and then report.

Question 4

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?

Accepted Answer

Highly Confidential. '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.

Answer

Confidential

Answer

Internal

Answer

Public

Question 5

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?

Accepted Answer

Rewrite the job to use GlideAggregate with query and update in bulk. 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.

Answer

Add a business rule to run asynchronously for each update

Answer

Increase the timeout value in the scheduled job configuration

Answer

Split the job into multiple smaller jobs running sequentially

Question 6

A developer needs to create a new table in ServiceNow to track project milestones. The table should have a reference field to the Project table and a date field for the milestone date. Which data type should be used for the reference field?

Accepted Answer

Reference. In ServiceNow, a reference field is specifically designed to create a relationship between two tables by storing the sys_id of the referenced record. This allows the developer to link a project milestone record to a specific project record in the Project table, enabling dot-walking and data integrity through referential integrity constraints.

Answer

GlideRecord

Answer

Integer

Answer

String

Question 7

During development, a developer creates a new application module and adds a table 'x_abc_incident' with a reference field to the 'sys_user' table. The developer wants to ensure that when a user is deleted, all related incident records are also deleted. What database constraint should be configured on the reference field?

Accepted Answer

Cascade delete. A cascade delete constraint ensures that when a record in the parent table (sys_user) is deleted, all child records in the referencing table (x_abc_incident) that have a foreign key pointing to that parent are automatically deleted. In ServiceNow, this is configured on the reference field's 'Delete constraint' property by selecting 'Cascade delete', which enforces referential integrity at the database level.

Answer

No action

Answer

Restrict delete

Answer

Set null on delete

Question 8

A company has a custom table 'u_training_course' with a reference field to 'sys_user' named 'u_instructor'. The requirement is that only users with the 'instructor' role can be selected in this field. Which approach should be used to enforce this?

Accepted Answer

Add a reference qualifier on the field to filter users with the 'instructor' role. A reference qualifier is the declarative way to filter the records available in a reference field on ServiceNow. By adding a condition like 'roles=instructor' to the reference qualifier of the 'u_instructor' field, only users with the 'instructor' role will appear in the lookup, enforcing the requirement at the database query level without custom scripting.

Answer

Create a business rule on the table to check the role and reject invalid selections

Answer

Use a client script to validate the selection before form submission

Answer

Configure an ACL on the reference field to restrict write access

Question 9

A developer needs to import data from a CSV file into a custom table. Which ServiceNow module should be used for this task?

Accepted Answer

Import Sets. Import Sets are the correct ServiceNow module for importing data from a CSV file into a custom table. They provide a structured pipeline that maps CSV columns to table fields, with staging tables for validation before final insertion. This is the standard approach for one-time or recurring data imports in ServiceNow.

Answer

Scheduled Jobs

Answer

Update Sets

Answer

Data Source

Question 10

An admin wants to create a report showing the number of incidents created each day for the past month. Which type of report should be used?

Accepted Answer

Bar chart. A bar chart is the correct choice because it is ideal for comparing discrete categories (such as days) over a period (the past month), showing the count of incidents per day. In ServiceNow, the 'Report Builder' allows you to create a bar chart with the 'Created on' field grouped by day and the 'Count' aggregation, which directly visualizes the number of incidents created each day.

Answer

List report

Answer

Pie chart

Answer

Line chart