SNOW-CAD Working with Data Practice Test 4 — 15 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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

Accepted Answer

Navigate to Notifications, then click New, then set the table and name, then define the condition, then configure email details, then submit.. The sequence: navigate to Notifications, create new, set table and name, define conditions, configure email details, and submit.

Answer

Navigate to Notifications, then click New, then configure email details, then define the condition, then set the table and name, then submit.

Answer

Navigate to Notifications, then click New, then define the condition, then set the table and name, then configure email details, then submit.

Answer

Click New, then navigate to Notifications, then set the table and name, then define the condition, then configure email details, then submit.

Question 7

Match each ServiceNow acronym to its definition.

Accepted Answer

ITSM: IT Service Management. Correct matches are ITSM: IT Service Management, ITOM: IT Operations Management, ITBM: IT Business Management, and CSM: Customer Service Management. Common confusions occur between ITSM and ITOM definitions.

Answer

ITSM: IT Operations Management

Answer

ITOM: IT Service Management

Question 8

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();. It correctly adds queries for active = true, department = 'Sales', and manager ISNOTEMPTY, then executes query() to retrieve all matching records. Option A is incorrect because getRow() is not a valid GlideRecord method. Option C lacks the manager condition. Option D incorrectly uses get() which retrieves a single record by sys_id, not a query.

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 9

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. Dot-walking uses the reference field name followed by a dot and the target field. 'caller_id' references the sys_user table, so current.caller_id.email retrieves the caller's email. Option B is wrong because 'caller' is not a field on sc_req_item. Option C is wrong because parentheses are not used in dot-walking. Option D is wrong because you do not need to specify the table name; the reference is automatically followed.

Answer

current.caller.email

Answer

current.caller_id(email)

Answer

current.caller_id.sys_user.email

Question 10

A developer needs to find the number of open incidents assigned to each assignment group. Which GlideAggregate script correctly groups by assignment group and counts?

Accepted Answer

var ga = new GlideAggregate('incident'); ga.addQuery('active', true); ga.addAggregate('COUNT'); ga.groupBy('assignment_group'); ga.query();. GlideAggregate requires the aggregate to be added with addAggregate('COUNT') and the grouping applied with groupBy('assignment_group') before query() is executed. Option D follows this exact sequence: addQuery to filter active incidents, addAggregate('COUNT'), groupBy('assignment_group'), then query(). This produces one row per assignment group with a COUNT aggregate, which is the correct pattern for counting open incidents per group.

Answer

var ga = new GlideAggregate('incident'); ga.addQuery('active', true); ga.addAggregate('COUNT', 'assignment_group'); ga.query();

Answer

var ga = new GlideAggregate('incident'); ga.addQuery('active', true); ga.groupBy('assignment_group'); var count = ga.getRowCount();

Answer

var ga = new GlideAggregate('incident'); ga.get('active', true); ga.groupBy('assignment_group'); ga.addAggregate('COUNT');

Question 11

A developer needs to filter a list of records based on a reference field condition using a reference qualifier. Which method is used to define a reference qualifier on a dictionary entry?

Accepted Answer

Reference qual. Reference qualifiers are defined in the 'Reference qual' field on the dictionary entry to filter records based on a reference field condition. Option A is incorrect because 'Reference specification' is used for setting the reference table, not for filtering with a qualifier. Option B is incorrect because 'Default value' sets a default value for the field, not a filter. Option D is incorrect because 'Dependent fields' are used to define field dependencies, not reference qualifiers.

Answer

Reference specification

Answer

Default value

Answer

Dependent fields

Question 12

Refer to the exhibit. A developer runs this script and notices it only returns 10 incidents even though there are more than 10 active priority 1 incidents. What is the reason?

Accepted Answer

The setLimit(10) method limits the number of records returned.. The script uses the setLimit(10) method, which restricts the GlideRecord query to return only 10 records, even though there are more matching records. Option A is incorrect because the script does not limit by session. Option B is incorrect because there is no filter for created today. Option C is incorrect because the issue is about the limit, not joins.

Answer

The script only gets incidents from the current session.

Answer

The script only retrieves incidents created today.

Answer

The incident table is not joined with any other table.

Question 13

A developer needs to import user records from a CSV file. The CSV contains a field 'department' that should map to a reference field 'department' on the sys_user table. However, the CSV contains department names, not sys_ids. What is the best approach to map the department names to the correct sys_ids?

Accepted Answer

Use a transform script to query the department table and set the reference field.. When importing data with a reference field that contains display values (like department names) instead of sys_ids, a transform script is needed to query the referenced table (e.g., cmn_department) to find the matching sys_id and set the reference field. This is done in the 'onBefore' transform script, where you can use GlideRecord to look up the department by name and assign its sys_id to the target field.

Answer

Set a default value for the department field in the transform map.

Answer

Use a coalesce field mapping on the department field.

Answer

Add a reference qualifier to the department field in the target table.

Question 14

When using an Import Set, the developer notices that some records are not being inserted even though no errors appear. The transform map has a condition script. What is the most likely cause?

Accepted Answer

The condition script returns false for those records.. The condition script in the transform map runs for each record. If it returns false, the record is skipped without any error. This explains why some records are not inserted despite no errors. Option A (data source filter) could also filter records, but the question specifically mentions a condition script, making D the most direct cause. Option B (incorrect field mappings) would typically result in mapping errors, not silent failure. Option C (business rule on target table) would usually generate errors or cause a rollback, not silent omission.

Answer

The data source has a filter that excludes those records.

Answer

The field mappings are incorrect for those records.

Answer

A business rule on the target table rejects the records silently.

Question 15

A company has a custom table 'project_task' with a reference field to 'project'. The requirement is to ensure that only users in a specific group can select projects in a certain state. Which approach provides the most secure and maintainable solution?

Accepted Answer

Use a reference qualifier on the project field that checks user group and project state.. Reference qualifiers are the standard way to dynamically filter the list of selectable records in a reference field based on conditions such as user group and project state. This approach provides immediate feedback in the UI and prevents invalid selections altogether. Option B (data policy) can enforce rules on submit but does not filter the picker, so users can still select invalid projects before submission. Option C (security rule) is designed for access control to records or modules, not for field-level filtering. Option D (business rule) would allow selection and then reject on insert/update, leading to a poor user experience and requiring rollback logic. Therefore, a reference qualifier is the most secure and maintainable solution.

Answer

Use a data policy with a condition to restrict the reference field.

Answer

Use a security rule to prevent selection of certain projects.

Answer

Use a business rule to check group membership on insert/update.