SNOW-CAD Practice Test 6 — 10 Questions

Question 1

Which TWO actions are required to ensure that an Import Set can update existing records while inserting new ones? (Choose two.)

Accepted Answer

Set the 'On Success' field to 'Update' on the Transform Map.. Setting the 'On Success' field to 'Update' on the Transform Map instructs the transform engine to update existing records when a matching record is found, rather than skipping or inserting a duplicate. Option D is correct because the Coalesce field defines which source field is used to match against existing target records; without a coalesce field, the system cannot determine whether a record already exists, so it will always insert new records.

Answer

Enable the 'Run as advanced' checkbox on the Import Set Row.

Answer

Configure a data source to define the external system connection.

Answer

Define a Transform Map that maps source fields to target fields.

Question 2

An administrator is designing a data model to manage vendor contracts. The solution must allow contracts to be associated with multiple departments and multiple vendors. Which THREE approaches are valid to model this many-to-many relationship in ServiceNow? (Choose three.)

Accepted Answer

Create an intermediate table 'ContractDepartment' with reference fields to Contract and Department. Options A, C, and D are valid approaches for modeling a many-to-many relationship in ServiceNow. Option A creates an intermediate table with reference fields, which is a standard relational method. Option C uses a GlideList field, which allows storing multiple references in a single field and can be used for many-to-many relationships. Option D uses a multi-reference field, which is specifically designed for many-to-many relationships. Option B is invalid because a single 'Department' field cannot store multiple records. Option E is invalid because storing comma-separated sys_ids in a String field is not a recommended practice and breaks data integrity.

Answer

Create a single 'Department' field on the Contract table and use it to store all department records

Answer

Use a 'String' field on the Contract table to store a comma-separated list of department sys_ids

Question 3

Refer to the exhibit. A developer created this dictionary override for a new field. When saving, an error occurs. What is the cause?

Accepted Answer

Integer fields do not support the max_length property. Integer fields in ServiceNow do not support the max_length attribute; that property is only applicable to string fields. The system rejects the dictionary override because max_length is invalid for an integer. Option A is wrong because labels can contain spaces. Option C is wrong because 'integer' is correctly spelled; the issue is not a typo. Option D is wrong because the order of JSON properties does not matter in dictionary overrides.

Answer

The label 'Custom Count' contains spaces

Answer

internal_type should be 'integer' not 'integer' (typo)

Answer

The JSON properties must be in alphabetical order

Question 4

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

Accepted Answer

Navigate to Local Update Sets, then Click New, then Provide name and description, then Set state to In Progress, then Submit. The sequence: navigate to Local Update Sets, create new, provide details, set state to In Progress, and submit.

Answer

Navigate to Local Update Sets, then Click New, then Set state to In Progress, then Provide name and description, then Submit

Answer

Click New, then Navigate to Local Update Sets, then Provide name and description, then Set state to In Progress, then Submit

Answer

Navigate to Local Update Sets, then Click New, then Provide name and description, then Submit, then Set state to In Progress

Question 5

A developer writes a script include that uses GlideRecord to query a large table. The script is called multiple times in a single transaction. What is the best practice to optimize performance?

Accepted Answer

Use a single GlideRecord query with multiple conditions and call .getRowCount() at the end.. When a script include queries a large table multiple times in a single transaction, the best practice is to minimize database round-trips. Using a single GlideRecord query with multiple conditions (combined via OR/AND) reduces the number of queries executed. Calling .getRowCount() at the end forces the query to execute once and caches the result, avoiding redundant queries for counts. This is more efficient than separate queries (A), which each require a round-trip. createOrGetRecord (B) is designed for single-record operations and doesn't optimize multiple queries. setEncodeQuery(false) (D) disables encoding but does not improve performance for repeated calls.

Answer

Use separate GlideRecord queries for each call.

Answer

Use createOrGetRecord for each call to cache the result.

Answer

Use setEncodeQuery(false) to speed up the query.

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

Refer to the exhibit. What does this data policy do?

Accepted Answer

Makes 'short_description' mandatory when state is '1' (New).. The data policy sets the 'short_description' field as mandatory when the 'state' field equals '1' (New). Option A is wrong because it says mandatory when state is New, but the condition is on state, not on short description. Option C is wrong because it reverses the condition. Option D is wrong because it ignores the condition.

Answer

Makes 'short_description' mandatory for all incidents regardless of state.

Answer

Makes 'state' mandatory when 'short_description' is empty.

Answer

Makes 'short_description' read-only when state is '1'.

Question 8

A company needs to import data from a CSV file into a custom table. The import should update existing records if a unique identifier matches, and insert new records if no match is found. Which feature should be configured on the transform map to achieve this?

Accepted Answer

Coalesce. The Coalesce feature on a transform map determines which field(s) are used to match incoming records against existing records in the target table. When a match is found, the transform map updates the existing record; when no match is found, it inserts a new record. This directly enables the required upsert behavior.

Answer

Scheduled import

Answer

Field mapping

Answer

Data source

Question 9

Refer to the exhibit. What security risk is present in this implementation?

Accepted Answer

The data is not subject to the same ACLs as server-side calls. Using client-side $http calls bypasses the server-side ACL evaluation that occurs when using spUtil or server scripts. Client-side REST API calls still respect ACLs based on the user's session, but they may expose sensitive data that goes through different security checks. However, a more critical risk is that the endpoint might be susceptible to CSRF if not protected. In the context of Service Portal, the recommended approach is to use spUtil.get or a server script to ensure proper data access control. Option D highlights the risk of inconsistent ACL enforcement.

Answer

The request exposes internal API credentials

Answer

The endpoint does not require authentication

Answer

The client exposes the widget to XSS attacks

Question 10

A senior developer is troubleshooting a performance issue in a Production instance. The instance has a large number of Business Rules that run on the incident table. One particular Business Rule, 'Update CI Impact', runs on the 'After Update' order and performs a GlideRecord query on the cmdb_ci table based on the incident's configuration item (ci) field. The query uses a filter to find all CIs related to the same location as the incident. Recently, users have reported that saving an incident takes over 30 seconds. The developer suspects this Business Rule is the cause. The developer examines the script and finds it uses a synchronous GlideRecord query with no scoping on the query. The developer wants to minimize impact on performance without removing the functionality. Which approach should the developer take?

Accepted Answer

Change the Business Rule to run asynchronously using the 'Async' checkbox in the Business Rule form.. Enabling the 'Async' checkbox on the Business Rule moves the execution to the background job scheduler, allowing the incident save transaction to complete immediately without waiting for the GlideRecord query to finish. This eliminates the synchronous delay that causes the 30-second save time, while preserving the functionality of updating CI impact.

Answer

Add an index on the cmdb_ci table for the location field and use an efficient query.

Answer

Move the logic to a scheduled job that runs every hour instead of on every update.

Answer

Convert the GlideRecord query to use GlideRecordSecure to limit access.