SNOW-CAD Practice Exam 3 — 20 Questions

Question 1

A developer wants to add a new field to a table that is part of a scoped application. What is the correct method in Studio?

Accepted Answer

Create a new field in the application's schema.. In a scoped application, the proper method to add a new field is to create it in the application's schema within Studio. Option A is incorrect because right-clicking a table does not provide an 'Add Field' option. Option C is incorrect because Application Builder is used for building applications, not adding fields directly. Option D is incorrect because System Definition > Tables is for global tables, not scoped application tables.

Answer

In Studio, right-click the table and select 'Add Field'.

Answer

Use the Application Builder to add a table extension.

Answer

Navigate to System Definition > Tables and add the field.

Question 2

Which THREE of the following are correct statements about Service Portal client controllers?

Accepted Answer

They can use AngularJS services like $http and $timeout.. Service Portal client controllers are AngularJS controllers that run in the browser. They can use standard AngularJS services such as $http for making AJAX calls to external APIs or the instance, and $timeout for delaying execution, which are both injected as dependencies.

Answer

They run on the server and are called via server-side includes.

Answer

They must define a $scope variable explicitly to bind data to the template.

Question 3

Which TWO application file types can be exported as XML from Studio?

Accepted Answer

Business Rules. Options A and D are correct because Business Rules and UI Policies are standard application files that can be exported as XML from Studio. Option B (Reports) is wrong because Reports are not application files; they are stored separately. Option C (System Properties) is wrong as they are configuration items, not exported via Studio. Option E (Homepages) is wrong because Homepages are not application files and cannot be exported as XML from Studio.

Answer

Reports

Answer

System Properties

Answer

Homepages

Question 4

Which TWO approaches are valid for importing data from an external database into ServiceNow on a recurring basis? (Choose two.)

Accepted Answer

Set up a MID Server to run a scheduled transform map from an external SQL query.. A MID Server can execute a scheduled SQL query against an external database and then run a transform map to map the retrieved data into ServiceNow tables. This approach is a standard pattern for recurring data imports using the MID Server's JDBC capabilities combined with scheduled import sets.

Answer

Use a REST API with a periodic flow that calls an external endpoint.

Answer

Write a business rule that triggers on an external event via web service.

Answer

Use an email inbound action to parse CSV attachments from the external system.

Question 5

A developer is troubleshooting a client script that hides a field on a form when a condition is met, but it is not working. The script is attached to the 'g_form' object in Studio. What is the most likely reason?

Accepted Answer

The client script is set to run on the 'Load' event instead of 'Change'.. The most likely reason because client scripts that need to react to a condition change must be set to run on 'Change' event rather than 'Load'. If the script runs only on 'Load', it executes once when the form loads and will not re-run when the condition changes, so the field remains visible. Option B is incorrect because the API for hiding fields (e.g., g_form.setVisible) is not deprecated. Option C is incorrect because client scripts do not have a 'Run As' role; that applies to server-side scripts. Option D is incorrect because client scripts can access any field present on the form regardless of the field's scope.

Answer

The script is using a deprecated API.

Answer

The script is not running due to a missing 'Run As' role.

Answer

The field is not part of the application scope.

Question 6

A company has a business rule on the Task table that runs on 'before' insert. The rule uses current.gotoField('short_description') and current.setValue('short_description', 'Default'). The rule is ordered to run at 500. However, a second business rule on the same table with order 100 also sets the short_description. What will be the final value of short_description?

Accepted Answer

'Default'. Business rules execute in ascending order based on their 'order' field. The rule at order 100 runs first and sets the short_description. Then the rule at order 500 runs and overrides that value with 'Default' using current.setValue(). Since both are 'before' insert rules, the final value written to the database is the one set by the last-executed rule, which is order 500.

Answer

Both values will be concatenated

Answer

The value set by the rule at order 100

Answer

The field will be empty because gotoField() clears it

Question 7

A large financial institution has a custom application for managing trade requests. The application uses a business rule on the 'Trade' table that calculates and sets the 'net_value' field based on 'quantity' and 'price'. Recently, traders have reported that when they update existing trades via a REST API integration, the 'net_value' field is not being recalculated. The business rule is set to run 'before' insert and 'before' update. The REST API uses GlideRecord to update the trade records. Upon investigation, the developer finds that the business rule script includes a check: 'if (current.changes('quantity') || current.changes('price')) { // recalculate }'. The script works correctly when updates are made from the UI. What is the most likely cause of the issue?

Accepted Answer

The GlideRecord used in the REST API does not load the record's previous values, so changes() returns false.. The GlideRecord API used in REST API integrations does not automatically load the previous values of fields into the `changes()` method. When a record is updated via GlideRecord in a scripted REST API, the `current` object in the business rule does not have the 'previous' values populated, so `current.changes('quantity')` and `current.changes('price')` both return `false`. This causes the recalculation logic to be skipped, even though the business rule is set to run 'before update'. In contrast, UI updates load previous values correctly, making `changes()` work as expected.

Answer

The business rule is set to run 'before' update, but the REST API triggers 'after' update.

Answer

The REST API sends the update request to a different instance, bypassing the business rule.

Answer

The condition 'current.changes('quantity') || current.changes('price')' is incorrectly formatted; it should use 'current.changes('quantity') || current.changes('price')'.

Question 8

A team is using a SOAP web service integration. The response contains namespaced XML, and the script that parses it is not extracting values correctly. What is the most likely issue?

Accepted Answer

Missing or incorrect namespace prefix handling in the script. Namespaced XML requires proper namespace prefix handling to extract values; if the script lacks or mismatches prefixes, parsing fails. Option A is incorrect because WSDL caching affects endpoint updates, not parsing. Option B is incorrect because SOAP version mismatch typically causes communication errors, not parsing issues. Option C is incorrect because HTTP timeout would result in no response, not incorrect value extraction.

Answer

WSDL caching prevents updated endpoint

Answer

SOAP version mismatch between request and response

Answer

HTTP timeout during response retrieval

Question 9

A company has a custom table 'u_employee' with fields: 'first_name', 'last_name', 'department'. They want to create a unique index on the combination of 'last_name' and 'department' to prevent duplicate entries. Where should this index be defined?

Accepted Answer

In the table's dictionary record via the Indexes related list. In ServiceNow, a unique index on a custom table is defined in the table's dictionary record via the Indexes related list. This is the correct location because ServiceNow uses the table's dictionary metadata to manage indexes, and the Indexes related list allows you to specify unique constraints directly on the table definition, ensuring the database enforces uniqueness on the combination of 'last_name' and 'department'.

Answer

In the table schema map

Answer

In the dictionary entry for each field

Answer

In the sys_dictionary table directly

Question 10

Which record type should be used to customize the look and feel of the UI16 interface?

Accepted Answer

UI Theme (sys_ui_theme). UI Theme (sys_ui_theme). In ServiceNow, the UI16 interface's look and feel is customized using UI Themes, which are stored in the 'sys_ui_theme' table. Option A (UI Script) is incorrect because UI Scripts are used for client-side JavaScript functions, not for theming. Option B (Portal Theme) is meant for Service Portal configurations, not the UI16 interface. Option D (Branding) handles logos, colors, and fonts but does not provide the full theme customization capabilities of UI Themes.

Answer

UI Script (sys_ui_script)

Answer

Portal Theme (sp_theme)

Answer

Branding (sys_brand)

Question 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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.