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

Question 1

Refer to the exhibit. This script is placed in a business rule on the 'incident' table with the 'When to run' set to 'before' and 'Update' action. The incident table has an ACL that also prevents updates. The business rule runs and shows the error message but the record is still updated. What is the most likely cause?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

The business rule condition is not met for this specific record.. If the business rule's condition evaluates to false for the record being updated, the script body (including setAbortAction and the error message) never executes — yet the record still updates normally. The most likely cause is that the condition does not match this record, so the abort logic is skipped entirely.

Answer

The setAbortAction method is being called on a new record.

Answer

The ACL is overriding the business rule's setAbortAction.

Answer

The business rule should be set to 'after' instead of 'before'.

Question 2

Refer to the exhibit. A transform map configuration is shown. What will happen if the source data has a 'u_model_id' value that matches an existing record in the 'cmdb_ci_model' table?

Accepted Answer

The transform will automatically set the model_id reference to the existing model record.. When a transform map field mapping uses a coalesce or reference lookup, ServiceNow will attempt to match the source value against the target table's display or sys_id. If a match is found in cmdb_ci_model, the transform sets the reference field to that existing record's sys_id, avoiding duplicate creation. This is standard behavior for reference fields with 'Coalesce' enabled or when using a 'Referenced' field mapping.

Answer

The transform will ignore the field because it is already mapped.

Answer

The transform will create a new model record with the given value.

Answer

The transform will skip the record because the model already exists.

Question 3

A company requires that when the 'state' field on an incident is set to 'Resolved', the 'resolution_code' field must be populated. Which mechanism should be used to enforce this rule?

Accepted Answer

Data policy with condition state = 'Resolved' and mandatory resolution_code.. A Data Policy in ServiceNow is the correct mechanism to enforce field-level mandatory rules at the database level, regardless of UI or API access. It applies to all data operations (insert, update, query) and cannot be bypassed by client-side scripts or UI policies. Setting the condition state = 'Resolved' and making resolution_code mandatory ensures the rule is enforced system-wide.

Answer

Client script that checks the state and pops up a message.

Answer

UI policy that sets the resolution_code field mandatory.

Answer

Business rule with a condition on state change.

Question 4

A developer wants to automatically calculate the number of days an incident has been in the 'On Hold' state. Which approach is most efficient and maintainable?

Accepted Answer

Use a business rule on state update to calculate and store the duration in a custom field.. A business rule on state update calculates and stores the duration in a custom field at the moment the state changes, so the value is computed once per transition and persisted for reporting and display without repeated recalculation. This is efficient because it avoids on-demand computation and keeps the value consistent and queryable. It is also maintainable because the logic lives in one business rule tied to the state change event.

Answer

Use a report to calculate the duration on demand.

Answer

Use a scheduled job to recalculate and update a field daily.

Answer

Use a calculated field with a formula that references the 'hold_duration' field.

Question 5

An import set is failing because some records have duplicate values in a unique field. The requirement is to skip duplicates and import only new records. Which transform map option should be used?

Accepted Answer

Enable 'Coalesce' on the unique field and set 'Action' to 'Insert' in the transform map.. Coalesce on the unique field allows the transform map to identify existing records by matching the incoming field to a unique field in the target table. Setting the Action to 'Insert' ensures that only new records are imported; if a match is found, the record is skipped (since it already exists). Option A ('Import set update only') is not a standard option in ServiceNow. Option B ('Update existing records') would update duplicates rather than skip them. Option C ('Reject duplicates') is not a typical option in data sources; the correct approach is using coalesce with Insert action.

Answer

Enable 'Import set update only' in the transform map.

Answer

Enable 'Update existing records' in the transform map.

Answer

Enable 'Reject duplicates' in the data source options.

Question 6

A data source is configured to import XML files from a REST endpoint. The XML contains nested elements. To properly map the data, which transform map feature is most useful?

Accepted Answer

Scripted transform with GlideRecord queries.. When XML contains nested elements, standard field mapping and choice mapping cannot flatten the hierarchy into ServiceNow table fields. A scripted transform using GlideRecord queries lets the developer parse the nested XML structure programmatically, iterate through child nodes, and insert or update records in the correct target tables with proper parent-child relationships.

Answer

Field mapping using dot-walk notation in 'Field name to map to' column.

Answer

Adjust the data source's 'XML parsing' settings.

Answer

Use 'Choice mapping' to map nested values.

Question 7

A developer needs to ensure that when a Configuration Item record is deleted, all related Incident records have their CI field set to empty. Which approach should be taken?

Accepted Answer

Create a business rule on the CI table that updates incidents on delete.. A business rule on the CI table that runs on delete is the correct approach. Business rules in ServiceNow execute server-side on database operations (before/after insert, update, delete, query) and can contain script logic to update related Incident records — for example, setting the CI reference field to empty on all incidents that reference the deleted CI. This is the standard, supported way to implement referential cleanup logic in ServiceNow.

Answer

Set the reference field's 'Delete action' to 'Cascade'.

Answer

Use a workflow on the CI table to update related incidents.

Answer

Use a database trigger on the CI table.

Question 8

A developer wants to restrict the values in a choice field based on the value of another field on the same record. Which tool should be used?

Accepted Answer

UI policy with 'Choice' action set to 'Set choices' conditionally.. In ServiceNow, a UI policy with the 'Set choices' action allows you to dynamically restrict the available options in a choice field based on another field's value on the same record. This is the native, declarative way to filter choice lists without writing client scripts. It runs on the client side and updates the choice list when the controlling field changes.

Answer

Data policy with conditions.

Answer

Reference qualifier on the choice field.

Answer

Client script that hides or shows options.

Question 9

Which TWO are valid data source types for Import Sets in ServiceNow? (Choose two.)

Accepted Answer

JDBC. Option A (JDBC) is correct because Import Sets support JDBC as a data source type, allowing ServiceNow to pull rows from an external relational database via a JDBC data source and transform them into staging records. Option B (REST) is correct because REST is also a supported Import Set data source type, enabling data to be retrieved from an external REST endpoint and loaded into a staging table. The unmarked options do not belong: LDAP is used for user authentication and directory integration rather than as an Import Set source, while SNMP and Syslog are monitoring/logging protocols that are not Import Set data source types.

Answer

LDAP

Answer

SNMP

Answer

Syslog

Question 10

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 11

Refer to the exhibit. What does this ACL condition allow?

Accepted Answer

Users with 'itil' role can update incidents in state 'On Hold'.. The ACL condition combines a role check ('itil') with a state check ('On Hold', which is state value 3 in the incident state model). When both match, users holding the itil role are permitted to update incidents that are currently in the On Hold state. This is the classic ServiceNow role-plus-state ACL pattern.

Answer

Any user can update incidents when state is '3'.

Answer

Only users without 'itil' role can update incidents in state '3'.

Answer

Users with 'itil' role can update incidents in state 'Resolved'.

Question 12

A developer needs to update a large number of records in the 'incident' table based on a specific condition. Which approach should be used to minimize performance impact?

Accepted Answer

Use GlideRecord with setWorkflow(false) and setEngine(false) to update records in a loop.. A is correct because using GlideRecord with setWorkflow(false) and setEngine(false) prevents unnecessary business rules and workflow execution, reducing performance impact. B is incorrect because GlideAggregate is used for aggregation and statistics, not for updating records. C is incorrect because an export set is designed for data export/import, not for bulk updates within the platform. D is incorrect because updateMultiple does perform bulk updates but still triggers business rules if not disabled, and it does not provide the same level of control as GlideRecord with disabled workflows.

Answer

Use GlideAggregate to perform the update.

Answer

Use an export set to update records in bulk.

Answer

Use the updateMultiple method on a GlideRecord object.

Question 13

An admin created a new table 'u_custom_asset' with a reference field to 'cmdb_ci'. After creating a form, users report that when they select a CI, additional fields do not auto-populate as expected. What is the most likely cause?

Accepted Answer

The reference field lacks a reference qualifier or default value configuration for auto-population.. In ServiceNow, a reference field does not automatically copy values from the referenced record onto the form. Auto-population is achieved by configuring the reference field with a reference qualifier and/or by using a 'Default value' or a client script/UI policy that pulls fields from the referenced record. Without such configuration, selecting a CI simply stores the sys_id and leaves other fields blank.

Answer

ACLs are blocking the read operation on the cmdb_ci table.

Answer

A business rule is missing on the reference field to trigger auto-population.

Answer

The cmdb_ci table is a system table and cannot be referenced from custom tables.

Question 14

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.. It consolidates multiple queries into a single database call, reducing the overhead of repeated round trips to the database. Using multiple conditions in one query and then calling .getRowCount() efficiently retrieves the count without fetching all records, which is optimal for performance when the script is invoked multiple times in a transaction. This approach minimizes database load and leverages the database's ability to filter and count in one operation.

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 15

Which method should be used to delete all records in the 'incident' table where the state is 'Closed' and the sys_updated_on is older than 90 days?

Accepted Answer

GlideRecord.deleteMultiple(). GlideRecord.deleteMultiple() is the correct method to delete multiple records that match a query. It is designed to efficiently delete all records returned by the query without iterating through each one. This is the standard way to perform bulk deletions in ServiceNow.

Answer

GlideAggregate.deleteMultiple()

Answer

GlideRecord.deleteRecord()

Answer

GlideRecord.setDelete(true)