SNOW-CSA Reporting, SLA and Imports Practice Test 3 — 15 Questions

Question 1

An import set row fails with the error 'Coalesce field not found on target table'. What is the most common cause?

Accepted Answer

The coalesce field is not mapped in the transform map.. The 'Coalesce field not found on target table' error occurs when the transform map specifies a coalesce field that is not mapped to any target column in the transform map. The coalesce field is used to determine whether an import set row should update an existing record or create a new one; if the field is not mapped, the system cannot locate it on the target table during the coalesce operation, triggering this error. Option A correctly identifies that the coalesce field is missing from the transform map's field mappings, which is the most common root cause.

Answer

The import set row is missing data in the coalesce field.

Answer

The staging table is incorrectly configured.

Answer

The target table does not have the specified coalesce field.

Question 2

Which two actions should be taken to ensure a dashboard is visible to all members of the 'service_desk' role? (Choose two.)

Accepted Answer

Set the dashboard's visibility to 'Public'.. Setting a dashboard's visibility to 'Public' (Option A) makes it accessible to all users, including those in the 'service_desk' role, without requiring individual ACL entries. This is the simplest method to ensure universal visibility within the instance. Additionally, configuring the 'Can read' ACL (Option D) to explicitly include the 'service_desk' role grants read-level access, which is necessary when the dashboard is not set to Public but must be restricted to specific roles. Together, these actions ensure the dashboard is visible to all members of the 'service_desk' role.

Answer

Add the dashboard to a module in the application menu.

Answer

Publish the dashboard to a homepage.

Answer

Grant the 'report_admin' role to all service desk members.

Question 3

Which three conditions must be met for an SLA to start automatically when a new incident is created? (Choose three.)

Accepted Answer

The incident matches the SLA's conditions.. An SLA timer will only start automatically for a new incident if the incident record matches the conditions defined in the SLA definition. These conditions are typically set as a filter condition on the SLA Definition record (e.g., 'Priority is 1' or 'Category is Network'). If the incident does not satisfy these conditions, the SLA will not be applied or started.

Answer

The SLA schedule includes the current time.

Answer

The incident has a 'watch_list' set.

Question 4

An import set row is being transformed but the target record is not updated. Which two possible causes should the administrator investigate? (Choose two.)

Accepted Answer

The transform map's 'Action' field is set to 'Create' instead of 'Create or Update'.. The transform map's 'Action' field determines whether the import set row creates a new record or updates an existing one. If set to 'Create', the system will never attempt to update an existing target record, even if a matching record is found. Setting it to 'Create or Update' allows the transform to update the target record when a match exists.

Answer

The staging table's 'Target table' field is set to the wrong table.

Answer

The transform map has the 'Coalesce' field set but no matching record exists.

Answer

The import set row has a 'state' value that is invalid.

Question 5

An administrator imports a CSV file into the incident table using an import set. After the import, several records are duplicated. What is the most likely cause?

Accepted Answer

The transform map does not have a coalesce field set.. The transform map lacks a coalesce field, which is required to match incoming records to existing records in the target table. Without a coalesce field, the import set treats every row as a new record, causing duplicates even if the CSV contains unique data. Coalesce fields define the unique key (e.g., sys_id or number) used to prevent duplicate inserts.

Answer

The CSV contained duplicate rows.

Answer

The target table has an index on the number field.

Answer

The import set row limit was exceeded.

Question 6

A scheduled report is set to run daily but does not execute. What is the most likely cause?

Accepted Answer

The user who created the schedule is inactive.. ServiceNow schedules are tied to the user who created them. If that user becomes inactive, the system disables the schedule to prevent unauthorized execution. The scheduled report will not run until the user is reactivated or the schedule is reassigned to an active user.

Answer

The schedule is not active.

Answer

The report is not shared.

Answer

The report contains too many rows.

Question 7

An SLA is paused due to a pause condition. The administrator wants to permanently stop tracking SLA for a specific incident. What should be done?

Accepted Answer

Set the SLA state to 'Cancelled' on the indicator.. Setting the SLA state to 'Cancelled' on the indicator permanently stops tracking for that specific incident without affecting other incidents or the SLA definition. This action marks the SLA as no longer applicable, and the system will not continue to calculate or update the SLA for that record.

Answer

Remove the incident from the SLA definition condition.

Answer

Set the SLA definition to inactive.

Answer

Delete the SLA record from the SLA table.

Question 8

An import set row shows as 'Error' with message 'Invalid table name'. What is the cause?

Accepted Answer

The target table does not exist.. The 'Invalid table name' error occurs when the import set row references a target table that does not exist in the ServiceNow instance. The import set table stores the raw data, but the transform map must map to an existing target table (e.g., 'incident', 'cmdb_ci_server'). If the target table name is misspelled, deleted, or never created, the system cannot resolve it and throws this error.

Answer

The staging table is not defined.

Answer

The import set source file is corrupt.

Answer

The transform map references a missing table.

Question 9

During an import, a transform field mapping uses a script to generate a value. The script runs but the target field is empty. What is the first thing to check?

Accepted Answer

The script returns a value.. The most common reason a script runs but the target field remains empty is that the script does not return a value. In ServiceNow transform maps, the script must explicitly use the `return` statement to output a value that will be written to the target field. If the script executes but lacks a return, or returns null/undefined, the field will be empty regardless of other correct configurations.

Answer

The field mapping's 'Field name' is correct.

Answer

The script is in the correct script include.

Answer

The staging table has the field.

Question 10

An SLA definition has a duration of 8 hours and a schedule of 9am-5pm weekdays. An incident is updated to a state that triggers the SLA at 3pm on Friday. What is the expected breach time?

Accepted Answer

3pm Monday. The SLA is defined with a duration of 8 hours and a schedule of 9am-5pm weekdays. The incident triggers the SLA at 3pm on Friday. Since the SLA clock only runs during the defined schedule (9am-5pm weekdays), only 2 hours of the 8-hour duration are consumed on Friday (3pm to 5pm). The remaining 6 hours must be completed starting at 9am on Monday, resulting in a breach time of 3pm on Monday.

Answer

11am Monday

Answer

7pm Friday

Answer

9am Monday

Question 11

Refer to the exhibit. An SLA definition has the condition shown. An incident is created with state=2, category='network', assignment_group=null, and caller_id=user1. Will the SLA start?

Accepted Answer

No, because the assignment_group is empty.. The SLA definition includes a condition that requires assignment_group to be populated. Since the incident has assignment_group=null, the condition is not fully met, and the SLA will not start. SLAs in ServiceNow only start when all conditions in the definition are satisfied; a null value for a required field causes the condition to fail.

Answer

No, because the caller_id condition is not met.

Answer

No, because the category does not match.

Answer

Yes, because the condition is partially met.

Question 12

Refer to the exhibit. An import set has a row with short_description='Test', category='network', and number='INC001'. The target table has an existing record with number='INC001' and description='Old Desc'. What will happen when the transform runs?

Accepted Answer

The existing record is updated with description='Test'.. The transform uses the coalesce field 'number' to match the incoming record (number='INC001') with the existing target record (number='INC001'). Since a match is found, the transform performs an update operation. The short_description field from the import set row ('Test') is mapped to the description field on the target table, so the existing record's description is updated to 'Test'.

Answer

The transform fails due to coalesce conflict.

Answer

A new record is created.

Answer

No action because coalesce field is invalid.

Question 13

Refer to the exhibit. A scheduled report is configured as shown but does not execute. What is the most likely cause?

Accepted Answer

The state is set to 'ready' instead of 'active'.. A scheduled report must have its state set to 'active' to execute. The 'ready' state indicates the report is configured and ready to run but is not yet enabled for automatic execution. Only reports in the 'active' state will trigger based on their schedule.

Answer

The time_of_day is set incorrectly.

Answer

The frequency is set to daily but the report is not scheduled.

Answer

The report lacks required roles.

Question 14

A service desk manager wants to create a report showing the number of incidents resolved within SLA for each assignment group over the last 30 days. Which report type should be used?

Accepted Answer

Bar chart grouped by assignment group with color for SLA status. A bar chart grouped by assignment group with color for SLA status allows the manager to see both the count of incidents per group and how many were resolved within versus outside SLA. This directly answers the requirement to show 'the number of incidents resolved within SLA for each assignment group' over the last 30 days.

Answer

Line chart of daily resolved incidents

Answer

Bar chart showing total incidents per group

Answer

Pie chart showing SLA compliance percentage

Question 15

An administrator notices that a scheduled import set runs successfully, but the imported records do not appear in the target table. The import log shows no errors. What is the most likely cause?

Accepted Answer

The transform map has no field mappings defined. When an import set runs successfully with no errors but records do not appear in the target table, the most likely cause is that the transform map has no field mappings defined. Without field mappings, the transform map cannot map source fields to target table columns, so no data is written to the target table even though the import set job completes without errors.

Answer

The coalesce field is set incorrectly

Answer

The import set run was scheduled during off-hours

Answer

The data source has been aborted