SNOW-CAD Working with Data Practice Test 3 — 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?

Accepted Answer

The business rule condition is not met for this specific record.. Option D is correct because the ACL may have a higher priority or the business rule's setAbortAction may not be honored if the ACL allows the operation. Actually, setAbortAction should abort, but if the ACL allows update, it may override? The typical reason is that the business rule runs after the ACL check, but if setAbortAction is called, it should stop. However, if the script uses setAbortAction correctly, it should work. The most plausible cause is that the business rule is running after the update because the condition is on 'before' but the ACL might be checked earlier. Or the script is not being executed due to condition. Let's craft: Option D is correct because if the script is in a 'before' business rule, setAbortAction(true) prevents the update, but if there is also an ACL that allows the update, the ACL takes precedence. Actually, setAbortAction works regardless. Better: The business rule might be executing after the update due to the order of operations? Let's think: In ServiceNow, business rules run before the database operation. setAbortAction should prevent the update. If the record is still updated, maybe the script is not triggered because the condition is not met. Option D: 'The business rule condition is not met for this record.' That could cause it not to run. Let's make that correct.

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.. Option A is correct because coalesce=true on model_id will use the source value to look up the existing model_id record and set the reference. Option B is wrong because coalesce does not create new records. Option C is wrong because it does not skip the record. Option D is wrong because it does not ignore the field.

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 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.. Option A is correct because a transform script can look up the sys_id based on the department name. Option B (coalesce) is for deduplication, not lookup. Option C (default value) would not map to the correct record. Option D (reference qualifier) restricts the picker but does not handle 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 4

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.. Option B is correct because a data policy can enforce field requirements on server-side updates. Option A (business rule) could also work but data policies are specifically designed for field-level validation. Option C (client script) is client-side only. Option D (UI policy) is client-side and can be bypassed.

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 5

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.. Option C is correct because a business rule on state update can calculate the duration when the state changes to 'On Hold' and store it in a field. Option A (calculated field) cannot reference subrecords or perform complex lookups. Option B (scheduled job) is inefficient and does not update in real time. Option D (report) only calculates on demand and does not store the value.

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 6

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.. Option A is correct because enabling 'Coalesce' on the unique field allows the system to identify existing records and skip duplicates. Option B (Import set update only) would update existing records, not skip. Option C (Reject duplicates) is not a standard option. Option D (Update existing records) would update duplicates.

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 7

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

Field mapping using dot-walk notation in 'Field name to map to' column.. Option B is correct because dot-walk notation (e.g., parent.child) allows mapping to nested XML elements. Option A (scripted transform) could be used but is less direct. Option C (data source parsing options) affect how the data is initially parsed, not mapping. Option D (choice mapping) is for choice fields.

Answer

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

Answer

Use 'Choice mapping' to map nested values.

Answer

Scripted transform with GlideRecord queries.

Question 8

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.. Option D is correct because a business rule on the CI table with 'before delete' can query related incidents and update the CI field to empty. Option A (cascade) would delete incidents, not clear. Option B (database trigger) is not supported in ServiceNow. Option C (workflow) is overly complex for this requirement.

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 9

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.. Option C is correct because a UI policy can conditionally set the values of a choice field on the client side. Option A (data policy) is server-side and cannot dynamically change choices. Option B (client script) can accomplish this but UI policy is the standard declarative approach. Option D (reference qualifier) is for reference fields, not choice fields.

Answer

Data policy with conditions.

Answer

Reference qualifier on the choice field.

Answer

Client script that hides or shows options.

Question 10

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.. Option A is correct because the condition script determines whether each record is processed; if it returns false, the record is skipped. Option B (data source filter) could filter records, but the condition script is the most direct cause. Option C (business rule) would show errors or cause rollback. Option D (field mappings) would usually show mapping errors.

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 11

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.. Option C is correct because reference qualifiers are the standard way to filter available options in a reference field. Option A (business rule) would allow selection then reject, which is not user-friendly. Option B (data policy) can enforce on submit but does not filter the picker. Option D (security rule) is for access control, not field-level filtering.

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 12

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 13

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

Accepted Answer

Source table (import set table). The correct answers are A, B, and D. A Transform Map requires a source table (the import set table), a target table (where data is imported), and field mappings. Condition scripts are optional, and data source is configured separately.

Answer

Condition script

Answer

Data source

Question 14

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

Accepted Answer

They can be used to enforce field requirements.. The correct answers are A, C, and D. Data policies enforce field requirements (mandatory/read-only) on the server side, can reference current record values, and can be restricted to specific user roles. They do not run on the client side, and they can fire on both insert and update.

Answer

They can fire on insert only.

Answer

They run on the client side only.

Question 15

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

Accepted Answer

Makes 'short_description' mandatory when state is '1' (New).. The correct answer is B. 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'.

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

Exhibit

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

Exhibit