SNOW-CAD Working with Data — Timed 20 Questions

Question 1

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. Option C is correct because '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 2

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. Option D is correct because 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 3

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. Option D is correct because 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 4

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. Option A is correct because 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 5

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. Option B is correct because 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 6

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 7

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 8

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. Option B is correct because 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 9

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 10

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.. Option B is correct because 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 11

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 12

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.

Question 13

A ServiceNow developer is working on a custom application that tracks employee training completions. The application has a table 'u_training' with fields: u_name (string), u_completion_date (date), u_employee (reference to sys_user). The requirement is to automatically send an email to the employee one week before the training completion date. The developer created a scheduled job that runs daily and queries for trainings where the completion date is exactly 7 days from today. However, the email is not being sent. The developer has verified the email notification is configured correctly and the scheduled job runs without errors. The script uses GlideRecord to query the table. What is the most likely reason the email is not sent?

Accepted Answer

The scheduled job runs with a system user that does not have read access to the 'u_training' table.. The most likely reason the email is not sent is that the scheduled job runs with a system user that lacks read access to the 'u_training' table. In ServiceNow, scheduled jobs execute under a specific user context (often the 'system' user or the user who created the job). If that user does not have the required read ACL on the table, the GlideRecord query will return zero records, even though the job runs without errors and the email notification is correctly configured. The developer verified the email configuration and job execution, but did not check the security context of the running job.

Answer

The scheduled job is running in a different time zone than the completion date field.

Answer

The email notification requires an ACL that the system user does not have.

Answer

The 'u_completion_date' field is a date/time field but the script compares using date only.

Question 14

Drag and drop the steps to create a new application in ServiceNow Studio into the correct order.

Question 15

Drag and drop the steps to create a new Notification in ServiceNow into the correct order.

Question 16

Match each ServiceNow acronym to its definition.

Question 17

Match each ServiceNow portal widget property to its purpose.

Question 18

A company needs to retrieve all active users whose department is 'Sales' and who have a manager assigned. They are using GlideRecord. Which script will correctly accomplish this?

Accepted Answer

var gr = new GlideRecord('sys_user'); gr.addQuery('active', true); gr.addQuery('department', 'Sales'); gr.addQuery('manager', 'ISNOTEMPTY'); gr.query();. Option A is correct because it uses addQuery for both conditions and uses 'ISNOTEMPTY' for the manager field. Option B is wrong because get() only retrieves one record. Option C is wrong because it lacks a condition for manager. Option D is wrong because it uses getRow() which is not a GlideRecord method.

Answer

var gr = new GlideRecord('sys_user'); gr.addQuery('active', true); gr.addQuery('department', 'Sales'); gr.addQuery('manager', 'ISNOTEMPTY'); var rows = gr.getRow();

Answer

var gr = new GlideRecord('sys_user'); gr.addQuery('active', true); gr.addQuery('department', 'Sales'); gr.query();

Answer

var gr = new GlideRecord('sys_user'); gr.get('active', true); gr.get('department', 'Sales'); gr.get('manager', 'ISNOTEMPTY');

Question 19

A developer is working on a catalog client script that references the 'caller_id' field on the 'sc_req_item' table. The caller_id field references the 'sys_user' table. To get the caller's email, which dot-walking syntax is correct?

Accepted Answer

current.caller_id.email. Option D is correct because dot-walking uses dot notation from the reference field to the target field. Option A is wrong because 'caller' is not a field. Option B is wrong because the table is sys_user, not sys_user_email. Option C is wrong because parentheses are not used.

Answer

current.caller.email

Answer

current.caller_id(email)

Answer

current.caller_id.sys_user.email

Question 20

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?

Accepted Answer

The developer forgot to call the query() method after grouping.. Option C is correct because if the query is not started properly (missing query() call), no results are returned. Option A is wrong because GlideAggregate can handle null categories. Option B is wrong because addAggregate('COUNT') is correct. Option D is wrong because GlideAggregate does not require addQuery for counts.

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.