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

Question 1

A company needs to import data from a CSV file into the User table. The CSV includes fields for first name, last name, email, and department. However, the import fails because some email addresses are invalid. Which feature in ServiceNow can be used to prevent invalid emails from being imported?

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

Accepted Answer

Transform Map with condition scripts. A Transform Map with condition scripts allows you to validate incoming data before it is written to the target table. In this scenario, you can add a script to the transform map that checks each email address against a regular expression pattern (e.g., RFC 5322) and skips or rejects rows with invalid emails, preventing them from being imported into the User table.

Answer

Data Source configuration

Answer

Import Set Row

Answer

Import Set Table API

Question 2

Drag and drop the steps to configure an outbound email account in ServiceNow into the correct order.

Accepted Answer

Create a new outbound email account record, then select SMTP type, then provide server and authentication details, then test and activate.. Outbound email accounts require SMTP type and proper server details for sending emails.

Answer

Create a new outbound email account record, then provide server and authentication details, then select SMTP type, then test and activate.

Answer

Select SMTP type, then create a new outbound email account record, then provide server and authentication details, then test and activate.

Answer

Create a new outbound email account record, then select SMTP type, then test and activate, then provide server and authentication details.

Question 3

Drag and drop the steps to create a new report in ServiceNow into the correct order.

Accepted Answer

Open the Reports module, then Select a table, then Define report criteria, then Save the report.. The correct sequence for creating a new report in ServiceNow begins by opening the Reports module, then selecting a table as the data source, followed by defining report criteria such as filters or conditions, and finally saving the report. This order ensures that each step builds logically on the previous one, from accessing the tool to specifying data and saving the configuration.

Answer

Select a table, then Open the Reports module, then Define report criteria, then Save the report.

Answer

Open the Reports module, then Define report criteria, then Select a table, then Save the report.

Answer

Open the Reports module, then Select a table, then Save the report, then Define report criteria.

Question 4

Match each ServiceNow acronym to its full form.

Accepted Answer

CMDB: Configuration Management Database. These are common ServiceNow acronyms. The correct matches are: CMDB = Configuration Management Database, SLA = Service Level Agreement, ITSM = IT Service Management, KB = Knowledge Base. Common confusions involve swapping the definitions of CMDB and SLA.

Answer

CMDB: Service Level Agreement

Answer

SLA: Configuration Management Database

Question 5

An SLA definition is configured to start when an incident's state changes to 'In Progress'. However, the SLA is not starting for incidents that are moved to 'In Progress'. The incident's assignment group is 'IT Support' and the SLA condition includes an additional filter: 'category = network'. What is the most likely cause?

Accepted Answer

The incident's category is not 'network'.. The SLA condition includes an additional filter requiring 'category = network'. If the incident's category is not set to 'network', the SLA will not start regardless of the state change to 'In Progress'. This is because SLA conditions in ServiceNow are evaluated as a whole; all conditions must be met for the SLA to begin.

Answer

The SLA schedule is set to 24x7 but the incident was created outside business hours.

Answer

The SLA definition has a pause condition that triggers on state change.

Answer

The SLA definition is on the 'task' table instead of 'incident'.

Question 6

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.. Option A is correct because an SLA only attaches when the incident satisfies the conditions defined in the SLA's start condition (e.g., priority, category, or assignment group filters), so a matching incident is required for automatic attachment. Option B is correct because an SLA definition must be in an active state; inactive SLA definitions are ignored by the SLA engine and will never attach to a new incident. Option C is correct because the SLA definition must be defined on the 'incident' table or a parent table of 'incident' (such as 'task') so that the SLA engine evaluates it against the incident record. Option D is not required because the SLA schedule determines when the SLA clock runs (business hours vs. 24x7), not whether the SLA attaches; an SLA can attach outside schedule hours and simply pause. Option E is not required because the 'watch_list' field is unrelated to SLA attachment; it only controls who receives notifications, not whether an SLA starts.

Answer

The SLA schedule includes the current time.

Answer

The incident has a 'watch_list' set.

Question 7

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

An import set fails with error 'Import set row processing error'. The transform map uses a script that references a table that does not exist. What is the first step to resolve this?

Accepted Answer

Update the transform script to reference a valid table. The import set row processing error specifically states that the referenced table does not exist. The appropriate first step is to update the transform script to reference a valid table that exists in the instance. Changing the scope (Option C) would not resolve the issue if the table truly does not exist—it only changes which tables are accessible, but if the table is missing entirely, no scope change will make it appear. Therefore, the correct action is to fix the script.

Answer

Re-create the import set definition

Answer

Change the data source type

Answer

Run the import set in a different scope