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

Question 1

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.. The script uses the setLimit(10) method, which restricts the GlideRecord query to return only 10 records, even though there are more matching records. Option A is incorrect because the script does not limit by session. Option B is incorrect because there is no filter for created today. Option C is incorrect because the issue is about the limit, not joins.

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.

Question 2

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?

Accepted Answer

The business rule condition is not met for this specific record.. The business rule condition is not met for this specific record. In a 'before' business rule, the script runs before the database operation. The setAbortAction(true) method should prevent the update. However, if the condition defined in the business rule (or a condition within the script) is not satisfied, the setAbortAction may not be called, allowing the update to proceed. The error message shown may come from a different part of the script (e.g., gs.addErrorMessage) that runs regardless, but the abort action is conditional. Option B is incorrect because setAbortAction works on existing records, not new ones; the exhibit likely shows an update. Option C is incorrect because ACLs do not override setAbortAction; setAbortAction is a server-side abort that prevents the database operation. Option D is incorrect because 'after' business rules cannot abort the operation; 'before' is correct for aborting.

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 3

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 coalesce is set to true on a reference field like 'model_id', the transform engine uses the source value (u_model_id) to look up an existing record in the referenced table (cmdb_ci_model). If a matching record is found, the transform sets the reference field to that existing record without creating a new one. Option A is incorrect because coalesce does not ignore the field; it actively searches for a matching record. Option B is incorrect because coalesce does not create new records; it only matches existing ones. Option D is incorrect because the transform does not skip the record; it proceeds with the transformation, setting the reference to the existing model.

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 4

A developer needs to import user records from a CSV file. The CSV contains a field 'department' that should map to a reference field 'department' on the sys_user table. However, the CSV contains department names, not sys_ids. What is the best approach to map the department names to the correct sys_ids?

Accepted Answer

Use a transform script to query the department table and set the reference field.. A transform script allows you to write custom logic to query the department table and retrieve the sys_id based on the department name from the CSV. Option A (default value) would set a static value for all records, not map dynamically. Option B (coalesce) is used for deduplication during import, not for field mapping. Option C (reference qualifier) filters the reference picker in forms but does not affect import mapping.

Answer

Set a default value for the department field in the transform map.

Answer

Use a coalesce field mapping on the department field.

Answer

Add a reference qualifier to the department field in the target table.

Question 5

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.. Data policies enforce field requirements on server-side updates and apply regardless of how the record is updated (UI, web services, etc.). In this scenario, a data policy with condition state='Resolved' and mandatory resolution_code ensures that the field must be populated when the state is set to Resolved. Option A (client script) is client-side only and can be bypassed. Option B (UI policy) is also client-side only. Option C (business rule) could be used to enforce the requirement, but data policy is the recommended mechanism for field-level validation because it is simpler and automatically handles all server-side operations. Therefore, option D is correct.

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 6

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 triggered on state update can calculate the number of days an incident has been in 'On Hold' at the moment the state changes, storing the result in a custom field for persistence and real-time accuracy. Option B (report) calculates duration on demand without storing, so it cannot be used for automated workflows or historical tracking. Option C (scheduled job) runs periodically, introducing delays and inefficiency, and does not update in real time when the state changes. Option D (calculated field) cannot reference subrecords or perform complex lookups needed to determine the duration an incident has been in a specific state.

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 7

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 8

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.. Scripted transforms allow custom JavaScript to parse and map nested XML elements using GlideRecord or other APIs, providing full flexibility when dot-walk notation is insufficient or not supported. Option A is incorrect because field mapping with dot-walk notation may not handle complex nested structures or special cases, and the reference to 'setEngine(false)' is invalid. Option B is incorrect because adjusting XML parsing settings affects parsing but not mapping. Option C is incorrect because choice mapping is for choice fields, not for nested data.

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 9

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 with a 'before delete' or 'after delete' condition can query all incident records referencing the deleted CI and set the CI field to empty/null. Option A ('cascade') would delete the related incidents instead of clearing the CI field. Option B (workflow) is unnecessarily complex; a business rule is more efficient and direct. Option D (database trigger) is not supported 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 10

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.. A UI policy can conditionally set the choices of a choice field on the client side using the 'Choice' action with 'Set choices' conditionally. This allows dynamic filtering of choice values based on other field values on the same record. Option A (data policy) is server-side and cannot dynamically change client-side choices. Option C (reference qualifier) applies only to reference fields, not choice fields. Option D (client script) can hide or show options but is not the standard declarative approach; UI policy is preferred for this requirement.

Answer

Data policy with conditions.

Answer

Reference qualifier on the choice field.

Answer

Client script that hides or shows options.

Question 11

When using an Import Set, the developer notices that some records are not being inserted even though no errors appear. The transform map has a condition script. What is the most likely cause?

Accepted Answer

The condition script returns false for those records.. The condition script in the transform map runs for each record. If it returns false, the record is skipped without any error. This explains why some records are not inserted despite no errors. Option A (data source filter) could also filter records, but the question specifically mentions a condition script, making D the most direct cause. Option B (incorrect field mappings) would typically result in mapping errors, not silent failure. Option C (business rule on target table) would usually generate errors or cause a rollback, not silent omission.

Answer

The data source has a filter that excludes those records.

Answer

The field mappings are incorrect for those records.

Answer

A business rule on the target table rejects the records silently.

Question 12

A company has a custom table 'project_task' with a reference field to 'project'. The requirement is to ensure that only users in a specific group can select projects in a certain state. Which approach provides the most secure and maintainable solution?

Accepted Answer

Use a reference qualifier on the project field that checks user group and project state.. Reference qualifiers are the standard way to dynamically filter the list of selectable records in a reference field based on conditions such as user group and project state. This approach provides immediate feedback in the UI and prevents invalid selections altogether. Option B (data policy) can enforce rules on submit but does not filter the picker, so users can still select invalid projects before submission. Option C (security rule) is designed for access control to records or modules, not for field-level filtering. Option D (business rule) would allow selection and then reject on insert/update, leading to a poor user experience and requiring rollback logic. Therefore, a reference qualifier is the most secure and maintainable solution.

Answer

Use a data policy with a condition to restrict the reference field.

Answer

Use a security rule to prevent selection of certain projects.

Answer

Use a business rule to check group membership on insert/update.

Question 13

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

Accepted Answer

JDBC. The correct answers are A and B. REST and JDBC are both valid data source types for Import Sets. LDAP, SNMP, and Syslog are not supported as data source types.

Answer

LDAP

Answer

SNMP

Answer

Syslog

Question 14

Which THREE are required components of a Transform Map? (Choose three.)

Accepted Answer

Source table (import set table). The correct answers are C, D, and E. A Transform Map requires a Source table (the import set table), Field mappings to define how data is mapped, and a Target table where the data is imported. Condition scripts (A) are optional, and the Data source (B) is configured separately before the Transform Map.

Answer

Condition script

Answer

Data source

Question 15

Which THREE are true about Data Policies? (Choose three.)

Accepted Answer

They can be used to enforce field requirements.. The correct answers are A, B, and D. Data Policies enforce field requirements (mandatory/read-only) on the server side, can reference current record values using conditions, and can be restricted to specific user roles via the 'Roles' condition. They do not run on the client side only; they execute server-side. They can fire on both insert and update, not just insert.

Answer

They can fire on insert only.

Answer

They run on the client side only.