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

Question 1

Match each ServiceNow acronym to its definition.

Question 2

Match each ServiceNow portal widget property to its purpose.

Question 3

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 4

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 5

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.

Question 6

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();. Option A is correct because it adds a query for open incidents, groups by assignment_group, and uses addAggregate('COUNT'). Option B is wrong because it uses getRowCount() incorrectly. Option C is wrong because addAggregate('COUNT', 'assignment_group') is not a valid way to group. Option D is wrong because it uses get() instead of query().

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 7

A company is importing data from a CSV into the 'cmdb_ci' table using an Import Set Row transform map. After running the import, some records were not created. The transform map has a 'Coalese' field set to true on the 'name' field. What is the most likely reason for records not being created?

Accepted Answer

The 'Coalese' field is set to true on the 'name' field, so existing records are updated instead of new ones created.. Option B is correct because coalese=true on name means if a record with the same name exists, it will update instead of insert. If the name matches an existing record, no new record is created. Option A is wrong because missing fields trigger errors, not silent failure. Option C is wrong because field mapping issues cause different problems. Option D is wrong because coalesce is for matching, not data type.

Answer

The transform map has incorrect field mappings for the CSV columns.

Answer

The target table has a data policy that prevents insert from import sets.

Answer

The CSV file has missing fields that are mandatory on the target table.

Question 8

A developer is writing a scripted REST API endpoint that returns a list of users. The requirement is to return only users who are in the 'IT' department and have a role of 'itil' or 'admin'. The endpoint uses GlideRecord. Which query condition is most efficient?

Accepted Answer

gr.addQuery('department', 'IT'); gr.addQuery('role', 'itil'); gr.addOrCondition('role', 'admin');. Option D is correct because it uses an OR condition with addQuery and addOrCondition. Option A is wrong because it does not filter by role. Option B is wrong because it uses two separate queries. Option C is wrong because addQuery for role with multiple values requires multiple conditions or an IN clause.

Answer

gr.addQuery('department', 'IT'); gr.addQuery('role', 'itil');

Answer

gr.addQuery('department', 'IT'); gr.query(); then iterate and check role.

Answer

gr.addQuery('department', 'IT'); gr.addQuery('role', 'itil,admin');

Question 9

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. Option C is correct because 'task' is the parent table for both incident and task, so a view from 'task' can include child records. Option A is wrong because 'incident' is a child of 'task', so it cannot include tasks that are not incidents. Option B is wrong because 'sys_attachment' is unrelated. Option D is wrong because 'task_assignment' is not a standard table.

Answer

incident

Answer

sys_attachment

Answer

task_assignment

Question 10

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. Option B is correct because reference qualifiers are defined in the 'Reference qual' field on the dictionary entry. Option A is wrong because that's for display fields. Option C is wrong because that's for default values. Option D is wrong because that's for dependent fields.

Answer

Reference specification

Answer

Default value

Answer

Dependent fields

Question 11

A developer has a GlideRecord query that retrieves 10,000 records. They need to perform an update on each record. Which approach is most efficient to avoid performance issues?

Accepted Answer

Use setWorkflow(false) and setAutoSysFields(false) before updating each record.. Option A is correct because using setWorkflow(false) and setAutoSysFields(false) reduces system processing. Option B is wrong because using multiple queries increases load. Option C is wrong because batch mode without disabling workflow still runs business rules. Option D is wrong because setLimit restricts the number of records, which may miss updates.

Answer

Use GlideRecord's batch mode without any modifications.

Answer

Use multiple GlideRecord queries to process records in batches.

Answer

Use setLimit(100) and run the script multiple times.

Question 12

Which TWO methods are valid for adding a condition to a GlideRecord query? (Choose two.)

Accepted Answer

addQuery. Options B and D are correct. addOrCondition is indeed a valid method for adding an OR condition. addQuery is the standard method for AND conditions. Option A is wrong because addAndCondition is not a valid GlideRecord method. Option C is wrong because addWhere is not a valid method. Option E is wrong because setCondition is not a method.

Answer

addAndCondition

Answer

setCondition

Answer

addWhere

Question 13

Which THREE are best practices when working with data imports via Import Sets? (Choose three.)

Accepted Answer

Ensure all target fields are mapped to avoid missing data.. Options A, D, and E are correct. Using a staging table is a best practice to validate data before transform. Mapping all fields reduces errors. Setting coalese ensures duplicates are handled. Option B is wrong because skipping transform map creation would bypass transforms. Option C is wrong because direct mapping to target table without transform is not standard; transforms allow data manipulation.

Answer

Map import set rows directly to the target table columns without using a transform.

Answer

Skip creating a transform map to speed up the import.

Question 14

A developer is designing a data architecture for a multi-tenant environment where each company's data must be isolated. Which TWO strategies can achieve this? (Choose two.)

Accepted Answer

Implement domain separation.. Options B and E are correct. Using domain separation provides built-in data isolation. Creating separate tables per company physically isolates data. Option A is wrong because ACLs alone can be complex and may not fully isolate. Option C is wrong because database views do not enforce isolation. Option D is wrong because conditions on queries rely on correct coding, not architecture.

Answer

Use access control lists (ACLs) on each record.

Answer

Create database views that filter data by company.

Answer

Add a condition to every GlideRecord query to filter by company.

Question 15

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.. Option B is correct because setLimit(10) limits the result set to 10 records. Option A is wrong because the query is correct. Option C is wrong because setLimit does not restrict to today's records. Option D is wrong because there is no join.

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.