SNOW-CAD Practice Test 13 — 15 Questions

Question 1

Which TWO of the following are valid ways to retrieve a single record from a GlideRecord query on the task table?

Accepted Answer

gr.next(). `gr.next()` is the standard method to advance the cursor to the next record in a GlideRecord query result set. When called after a `query()`, it retrieves the first record (or subsequent records) and returns true if a record exists, making it a valid way to access a single record. Option D is correct because `gr.get(sys_id)` retrieves a single record by its sys_id directly, without needing a prior query, and returns true if the record is found.

Answer

gr.getRow()

Answer

gr.getUniqueValue()

Answer

gr.getByID()

Question 2

A developer is creating a custom table 'u_project_risk' to track risks associated with projects. The table must: (1) Automatically set the 'state' field to 'Open' when a new record is created. (2) Prevent deletion of records if the state is 'Closed'. (3) Display a warning message when a user changes the state from 'In Progress' to 'Closed'. Which THREE approaches should the developer use?

Accepted Answer

Set a default value for the 'state' field to 'Open'. Setting a default value on the 'state' field to 'Open' ensures that whenever a new record is created in the 'u_project_risk' table, the field automatically populates with 'Open' without requiring any script or business rule. This is a declarative, low-code approach that leverages the platform's built-in default value functionality at the field level, guaranteeing the requirement is met even if the record is created via web services or import sets.

Answer

Create a before business rule to check state on update

Answer

Define a reference qualifier on the 'project' field

Question 3

Which TWO conditions must be met for a transform map to automatically ignore duplicate records during an import?

Accepted Answer

The target table has a unique index on the coalesce field.. For duplicate detection to automatically ignore duplicate records already in the target table, two conditions must be met: the transform map must have 'Enable Duplicate Detection' set to true (option E), and the target table must have a unique index on the coalesce field (option B). The coalesce field mapping identifies the field used to check for duplicates; a unique index on the target table enforces uniqueness, allowing the system to detect that a record already exists. Options A, C, and D are incorrect: a unique index on the source table (A) is not required for target duplicate detection; the 'Ignore if Empty' checkbox (C) relates to handling empty values, not duplicate detection; and an index on the import set table (D) is used for detecting duplicates within the same import set, not for ignoring duplicates already in the target.

Answer

The source table has a unique index on the coalesce field.

Answer

The coalesce field mapping uses the 'Ignore if Empty' checkbox.

Answer

The import set table has a unique index on the coalesce field.

Question 4

A custom table 'u_asset' stores asset data. The developer wants to add a field that calculates the depreciation value based on acquisition date and cost. Which field type should be used?

Accepted Answer

Calculated. A calculated field using a script (e.g., calculated value via business rule or calculated field attribute) can compute depreciation. Option A is wrong because Lookup select is for selection lists, not dynamic calculation. Option B is wrong because Currency is just a data type, not dynamic calculation. Option D is wrong because Condition string is for conditions.

Answer

Lookup select

Answer

Currency

Answer

Condition string

Question 5

You are a ServiceNow developer at a company that manages IT assets. You are asked to create a new table called 'u_software_license' to track software licenses. The table must have fields for license name, vendor, purchase date, expiration date, cost, and number of seats. Additionally, the table must be accessible from the 'Software' module in the application navigator. You have created the table with the appropriate fields. However, after creating the table, it does not appear in the 'Software' module. You verify that the table is set to extend 'Task' and that the application scope is correct. What is the most likely reason the table does not appear in the module?

Accepted Answer

A module has not been created to reference the new table.. The table does not appear in the 'Software' module because no module record exists that maps the table to that module. To display a table under a specific module in the application navigator, you must create a module record that references the table. The 'Display in application navigator' checkbox only adds the table as a top-level entry, not under a module. Since the user verified the table extends Task and the application scope is correct, the missing step is creating a module record.

Answer

The table name 'u_software_license' is not compatible with the Software module.

Answer

The 'Display in application navigator' checkbox is not checked on the table configuration.

Answer

The table extends 'Task' instead of 'Software', so it cannot appear in the Software module.

Question 6

Which THREE factors should be considered when deciding between using a REST API integration and an Import Set for data ingestion?

Accepted Answer

Real-time vs batch processing requirement. Options A, B, and D are correct. Real-time vs batch processing (A) is a key difference between REST API and Import Sets. Volume of data (B) affects performance and feasibility of each method. Complexity of data transformation (D) determines which method is more suitable, as Import Sets handle transformations well while REST APIs may require custom scripting. Authentication and authorization (C) is needed for both, so it's not a deciding factor. Support for OAuth 2.0 (E) is a specific authentication method, not a general consideration.

Answer

Need for authentication and authorization

Answer

Support for OAuth 2.0

Question 7

A developer needs to create a catalog item that requires approval from the user's manager. What is the best practice to configure this?

Accepted Answer

Add an 'Approval' activity in the workflow. Adding an 'Approval' activity in a workflow is the standard and best practice for managing approvals in catalog items in ServiceNow. Option A is incorrect because 'Get Approvals' is not a standard action in Flow; Flow does not have a direct 'Get Approvals' action for approval routing. Option C is incorrect because Client Scripts handle client-side behavior and cannot trigger approval requests; approvals are server-side. Option D is incorrect because Business Rules are not designed for approval routing; they are used for server-side logic on tables, not for orchestrating approval processes.

Answer

Use a Flow with a 'Get Approvals' action

Answer

Use a Client Script to trigger an approval request

Answer

Use a Business Rule to set the approval state

Question 8

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 9

Which TWO are best practices when implementing data integrations using ServiceNow import sets?

Accepted Answer

Schedule the import to run during off-peak hours. Options A and D are correct. A: Scheduling imports during off-peak hours minimizes impact on system performance and user experience. D: Using coalesce in the transform map on a unique field prevents duplicate records by matching existing records based on that field. B is incorrect because REST API is an alternative integration method, not a performance improvement over import sets. C is incorrect because update sets are used to move configurations between instances, not to manage import set configurations. E is incorrect because while staging tables are commonly used, they are not always required for all data sources.

Answer

Use REST API instead of import sets for better performance

Answer

Use update sets to manage import set configurations

Answer

Always use a staging table for all data sources

Question 10

As a best practice, which method should be used to schedule recurring data imports from external sources?

Accepted Answer

Configure a scheduled job to use the Import Set API or transform. A scheduled job can be configured to run at recurring intervals and use the Import Set API or transform to import data from external sources. Option A is incorrect because update sets are used for version control and deployment, not for scheduling data imports. Option B is incorrect because a Flow Designer flow with an HTTP trigger is designed for real-time HTTP requests, not for recurring scheduled imports. Option D is incorrect because business rules trigger on database operations (like insert, update, delete) and are not suited for scheduling recurring imports.

Answer

Deploy an update set for each import

Answer

Use a Flow Designer flow with an HTTP trigger

Answer

Create a business rule that triggers on a condition

Question 11

A developer is creating an application in ServiceNow Studio and needs to ensure that all new records created in a custom table are automatically assigned a number. Which THREE methods can be used to achieve this? (Choose three.)

Accepted Answer

Use a default value on the number field.. Options A, B, and E are correct. A default value on the number field will automatically assign a number to new records. A flow with a create record action can set the number during record creation. A business rule with a script can also assign a number on insert. Option C (database view) is incorrect because database views do not generate numbers; they are virtual tables that display data. Option D (client script) is unreliable as it runs client-side and can be bypassed, so it is not suitable for ensuring automatic numbering.

Answer

Use a database view to generate numbers.

Answer

Use a client script to set the number on load.

Question 12

Which TWO are best practices for integrating with external systems via REST API in ServiceNow?

Accepted Answer

Store credentials in a credential store or use OAuth for authentication.. Options B and E are best practices. Storing credentials in a credential store or using OAuth (option B) enhances security over basic authentication (option C is incorrect). Using HTTPS (option E) encrypts data in transit, protecting it from interception. Option A is wrong because GlideRecordSecure API is actually recommended for secure REST endpoint operations. Option D is incorrect because the sysparm_query parameter filters records but does not limit the number of records returned; use sysparm_limit for that purpose.

Answer

Avoid using the GlideRecordSecure API for REST endpoints.

Answer

Use basic authentication with username and password for all REST API requests.

Answer

Use the sysparm_query parameter to limit the number of records returned.

Question 13

A ServiceNow developer needs to implement a business rule that automatically sets the 'state' field to 'In Progress' when a user is assigned to an incident. The rule should run only when the 'assigned_to' field changes, and should not run on any other updates. Which condition type and condition script should be used?

Accepted Answer

Condition type: 'when to run' set to 'on update' with condition 'current.assigned_to.changes()'. The 'when to run' condition type set to 'on update' with the condition 'current.assigned_to.changes()' ensures the business rule triggers only when the 'assigned_to' field is updated, and not on insert or other field changes. The 'changes()' method returns true only when the specified field has been modified during the current transaction, which precisely meets the requirement.

Answer

Condition type: 'when to run' set to 'on update' with condition 'current.assigned_to.changes() || current.state.changes()'

Answer

Condition type: 'when to run' set to 'on insert or update' with condition 'current.assigned_to.changes()'

Answer

Condition type: 'advanced' with condition script 'current.assigned_to.changes()' and run on 'update'

Question 14

When building a custom application using ServiceNow Studio, which of the following is NOT a recommended practice for version control?

Accepted Answer

Directly edit system tables outside of the application scope.. Directly editing system tables outside of the application scope bypasses version control and can cause conflicts, making it not a recommended practice. Options A, B, and C are all recommended practices for version control in ServiceNow Studio.

Answer

Create a new application version for each major release.

Answer

Track changes using update sets.

Answer

Use application scope to isolate changes.

Question 15

A ServiceNow developer is building an integration using IntegrationHub to connect to a third-party system via REST. The system requires OAuth 2.0 with client credentials grant flow. Which TWO configurations are mandatory for setting up this integration in IntegrationHub?

Accepted Answer

Token request endpoint URL (e.g., https://example.com/oauth/token). The client credentials grant flow requires a direct token request endpoint URL where the client sends its credentials (client ID and secret) to obtain an access token. IntegrationHub must be configured with this specific endpoint to complete the OAuth 2.0 handshake, as the grant type does not involve user interaction or discovery endpoints.

Answer

OAuth server discovery URL (well-known endpoint)

Answer

Base64 encoding of the client secret

Answer

Username and password for user impersonation