SNOW-CAD Working with Data Practice Test 1 — 15 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

Question 11

A developer writes a business rule that queries the 'incident' table using GlideRecord. The script loops through all incidents and updates a field. After running, the developer notices that only a subset of records were updated. What is the most likely cause?

Accepted Answer

The GlideRecord query did not include a condition, so it used a default filter that limited results. GlideRecord queries in ServiceNow automatically apply a default filter when no explicit condition is set, typically limiting results to records where the `active` field is `true`. This default behavior, known as the 'active filter,' causes the script to only process a subset of incidents (those that are active) rather than all records in the table, explaining why only some were updated.

Answer

The user running the script lacks write ACL on the table

Answer

The field name used in the update was misspelled

Answer

The script did not call getRowCount() before the loop

Question 12

Which TWO statements about Database Views in ServiceNow are correct?

Accepted Answer

Database Views can be used to join multiple tables for reporting purposes.. Database Views in ServiceNow are virtual tables that combine data from one or more tables without storing the data physically. They are primarily used for reporting and data analysis, allowing you to join multiple tables and present a unified dataset. Option D is correct because Database Views are specifically designed to join multiple tables for reporting, enabling complex queries across related records.

Answer

Database Views improve write performance by reducing the number of tables.

Answer

Database Views are stored as separate physical tables.

Answer

Database Views allow direct updates to the underlying tables through the view.

Question 13

Which THREE conditions must be met for a user to successfully see a record in a ServiceNow list view?

Accepted Answer

The user has read permission on the table via an ACL.. ServiceNow uses Access Control Lists (ACLs) to enforce read permissions on tables. Without a read ACL that evaluates to true for the user, the system will not display any records from that table in a list view, regardless of other conditions.

Answer

The user has write permission on the table.

Answer

The user has configured a personalized list view for the table.

Question 14

Which TWO data types are available in ServiceNow for storing date and time values?

Accepted Answer

Date/Time. ServiceNow provides two dedicated data types for storing date and time values: 'Date' for calendar dates without time, and 'Date/Time' for combined date and time values. These are the correct choices because they directly map to the platform's field types used in tables like Task and Incident for tracking creation and due dates.

Answer

Time

Answer

Duration

Answer

Timestamp

Question 15

A large enterprise runs ServiceNow on a single instance. They have a custom table 'u_project_task' that stores task details for projects. Each project task has a reference field to the 'u_project' table. The 'u_project' table has approximately 50,000 records, and the 'u_project_task' table has about 2 million records. Users report that opening a project record and viewing its related tasks takes over 30 seconds. The system uses an out-of-box related list to display tasks. The instance has standard hardware resources. The administrator has already confirmed that there are no performance issues with the database server or network. Which course of action should the administrator take to improve the performance of the related list?

Accepted Answer

Create a database index on the 'u_project' field in the 'u_project_task' table to speed up the join.. The performance bottleneck is the database query that joins the large 'u_project_task' table (2M records) with the 'u_project' table on the reference field. Without an index on the 'u_project' field in 'u_project_task', the database must perform a full table scan for each related list query. Creating a database index on that foreign key column allows the database to use an index seek, dramatically reducing query time.

Answer

Archive project tasks older than 1 year to a separate table to reduce the data volume.

Answer

Increase the glide.ui.related_list.max_timeout property to allow the query more time.

Answer

Add additional application nodes to the instance to distribute the load.