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

Question 1

A company has an SLA definition that starts when the state is 'New' and pauses when the state is 'On Hold'. A task is created with state 'New' at 10:00 AM. At 10:30 AM, the state is changed to 'In Progress'. At 11:00 AM, the state is changed to 'On Hold' for 30 minutes, then back to 'In Progress' at 11:30 AM. The task is resolved at 12:00 PM. The SLA has a 2-hour duration. What is the elapsed time used for SLA compliance?

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

Accepted Answer

1 hour 30 minutes. The SLA definition starts when the state is 'New' and pauses when the state is 'On Hold'. The task was in 'New' from 10:00 to 10:30 (30 minutes), then 'In Progress' from 10:30 to 11:00 (30 minutes), then 'On Hold' from 11:00 to 11:30 (30 minutes, paused), then 'In Progress' from 11:30 to 12:00 (30 minutes). The total elapsed time for SLA compliance is the sum of non-paused time: 30 + 30 + 30 = 1 hour 30 minutes, which is within the 2-hour SLA duration.

Answer

2 hours

Answer

1 hour 30 minutes from state change to resolve

Answer

1 hour

Question 2

A report is created but shows no data. The table and conditions appear correct. What is the most likely cause?

Accepted Answer

The report is set to 'Run as' a user without roles to view the data. In ServiceNow, reports execute under the security context of the user specified in the 'Run as' field. If that user lacks the necessary roles (e.g., snc_internal or specific table read roles) to view the underlying data, the report will run without errors but return zero rows, even if the table and conditions are correct. This is a common misconfiguration when reports are shared or scheduled.

Answer

The report is scheduled to run daily

Answer

The report type is set to 'Bar chart' but the data is numeric

Answer

The report has a modulo condition on sys_id

Question 3

An administrator wants to create a dashboard with multiple reports that automatically refresh every 5 minutes. Which feature should be used?

Accepted Answer

Dashboard with auto-refresh property. A dashboard in ServiceNow can have its auto-refresh property set to a specific interval, such as every 5 minutes, which automatically refreshes all reports on the dashboard simultaneously. This meets the administrator's requirement without manual intervention or additional scheduling.

Answer

Homepage with iframe

Answer

Performance Analytics indicator

Answer

Report scheduling

Question 4

An SLA is defined with a condition of 'Priority is 1' and 'State is not Closed'. A task has Priority=1 and State=New. The SLA starts. Later the task is assigned and Priority is changed to 2, then back to 1. What happens to the SLA?

Accepted Answer

The SLA stops and a new SLA instance starts when priority returns to 1. When the priority changes from 1 to 2, the SLA condition 'Priority is 1' is no longer met, so the SLA stops. When priority returns to 1, a new SLA instance starts because the condition is re-evaluated from scratch; the SLA does not resume the previous timer. This is standard behavior for SLA definitions with conditions that are not based on a single continuous state.

Answer

The SLA pauses and resumes

Answer

The SLA stops and resumes with the same elapsed time

Answer

The SLA continues running because it started when conditions were met

Question 5

Which import set transform operation should be used to prevent duplicate records from being created when the source data contains a unique identifier column?

Accepted Answer

Coalesce. (Coalesce) is correct because the Coalesce transform operation in ServiceNow import sets is specifically designed to prevent duplicate records by matching on a unique identifier column. When configured, Coalesce checks if a record with the same value in the specified field already exists in the target table; if it does, the import updates the existing record instead of creating a duplicate.

Answer

Default value

Answer

Ignore

Answer

Run script

Question 6

A pivot table report shows 'Number' as the column and 'Assigned to' as the row. The 'Value' field is set to 'Count'. What does each cell represent?

Accepted Answer

The number of incidents assigned to that user. In a ServiceNow pivot table, when 'Number' is the column and 'Assigned to' is the row with 'Value' set to 'Count', each cell counts the number of records (incidents) that have a specific 'Number' value and are assigned to a specific user. This directly corresponds to the number of incidents assigned to that user for that particular number value, making D correct.

Answer

The average number of incidents per group

Answer

The number of tasks closed by each user

Answer

The total number of incidents in the system

Question 7

An import set transform map has a field mapping that uses a 'Run script' action. The script sets a reference field by querying the target table. However, the import fails with a 'Null reference' error. What is the most likely issue?

Accepted Answer

The script is not using the correct record identifier. The import fails with a 'Null reference' error because the script in the field mapping uses a query that does not find a matching record in the target table, resulting in a null value for the reference field. Option A is correct: the script is likely not using the correct record identifier (e.g., sys_id or a unique field) to locate the target record, so the query returns no results. Option B is incorrect because read-only fields do not cause null reference errors; they prevent field updates. Option C is incorrect because 'Atomic update' mode is unrelated to reference field errors; it affects how transforms are processed. Option D is incorrect because the coalesce field determines how source rows are matched to target rows, but the error here occurs during field mapping execution, not during coalescing.

Answer

The target field is read-only

Answer

The transform map is set to 'Atomic update'

Answer

The coalesce field is set incorrectly

Question 8

Which TWO options are valid ways to schedule a report in ServiceNow?

Accepted Answer

Schedule to run once at a specific time. ServiceNow allows scheduling a report to run once at a specific date and time, which is useful for one-time deliveries or ad-hoc reporting needs. This is configured in the report's Schedule tab by setting the frequency to 'Once' and specifying the exact run time.

Answer

Schedule to run hourly

Answer

Schedule to run immediately

Answer

Schedule to run only when conditions change

Question 9

Which THREE options are valid fields in an SLA definition?

Accepted Answer

Breach condition. In ServiceNow SLA definitions, the 'Breach condition' is a valid field that defines the condition under which the SLA is considered breached, typically based on a time threshold. This field is essential for triggering breach notifications and escalations when the SLA target is not met.

Answer

Reset condition

Answer

Exclusion condition

Question 10

Which TWO options are true regarding import set transform maps?

Accepted Answer

Transform scripts can access both source and target records. Transform scripts in ServiceNow run during the transform map execution and have access to both the source record (via the 'source' object) and the target record (via the 'target' object). This allows scripts to read, compare, and modify data from both sides, enabling complex data transformation logic.

Answer

Transform maps run in the context of the source table

Answer

Each field mapping can have a unique coalesce field

Answer

Import sets automatically deduplicate based on sys_id

Question 11

Based on the exhibit, why did the transform create or update zero records?

Accepted Answer

The script on the category field has an error. The script on the category field contains an error that causes the transform to fail silently, resulting in zero records being created or updated. In ServiceNow, a transform script that throws an unhandled exception or returns an unexpected value (e.g., 'false' or 'skip') will abort the mapping for that row, and if it affects all rows, no records are processed. The exhibit likely shows a script that either has a syntax error or logic that prevents any row from passing through the transform map.

Answer

The assigned_to field mapping is missing a coalesce

Answer

The staging table does not match the target table

Answer

The coalesce field is set incorrectly

Question 12

At the current time (09:45), what is the total pause duration for this SLA instance?

Accepted Answer

15 minutes. The SLA instance was paused at 09:30 and resumed at 09:45, resulting in a total pause duration of 15 minutes. In ServiceNow, SLA pause duration is calculated as the cumulative time between pause and resume actions, excluding the paused time from the SLA clock.

Answer

0 minutes

Answer

45 minutes

Answer

30 minutes

Question 13

A company needs to create a report that shows the average time taken to resolve incidents. Which report type would best fulfill this requirement?

Accepted Answer

Pivot table with average of resolved time. A pivot table with an average of resolved time is the correct choice because it directly computes the mean of the duration field (e.g., 'resolved_time' or 'time_to_resolve') for each grouping, such as by assignment group or category. This satisfies the requirement to show the average time taken to resolve incidents without visual clutter. In ServiceNow, pivot tables aggregate numeric data using functions like AVG, SUM, or COUNT, making them ideal for summary statistics.

Answer

Line chart with trend over time

Answer

Bar chart with count of incidents

Answer

Scorecard with gauge

Question 14

Which role is required to create a report in the Reporting module?

Accepted Answer

report_admin. The report_admin role is required to create reports in the Reporting module because it grants full administrative permissions over reports, including creation, editing, and deletion. The report_user role only allows viewing and running existing reports, not creating new ones.

Answer

admin

Answer

report_user

Answer

report_creator

Question 15

A user wants to view a daily trend of incidents created over the past month. Which report type is most appropriate?

Accepted Answer

Line chart with date series on x-axis and count on y-axis. A line chart with date series on the x-axis and count on the y-axis is the most appropriate report type for viewing a daily trend of incidents over the past month. Line charts are specifically designed to display data points over time, making trends clearly visible. While a bar chart could also show daily counts, line charts are more effective for trend analysis. List reports show raw data in tabular form and do not visualize trends. Pie charts are unsuitable because they represent proportions at a single point in time.

Answer

Bar chart grouped by day

Answer

List report

Answer

Pie chart