Question 4 of 510
Reporting, SLA and ImportsmediumMultiple ChoiceObjective-mapped

Quick Answer

The answer is a List report with an 'Average' aggregation on the 'Resolved' field. This is correct because List reports in ServiceNow perform dynamic average aggregation on a specified field, recalculating the value in real time as new records are added or updated, which perfectly meets the requirement for a self-updating metric like average resolution time. On the ServiceNow Certified System Administrator CSA exam, this question tests your understanding of report types and their aggregation behaviors, often appearing as a trap where candidates mistakenly choose a Bar chart or a Pie chart—those are static snapshots unless refreshed manually. The key distinction is that List reports support live field-level aggregations without needing scheduled runs, while other report types require manual or scheduled recalculation. A simple memory tip: think “List = Live” for dynamic averages, as the list report keeps its aggregation current with every new record.

SNOW-CSA Reporting, SLA and Imports Practice Question

This SNOW-CSA practice question tests your understanding of reporting, sla and imports. Examine the command output carefully: the correct answer depends on what the output actually shows, not on general recall alone. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

An administrator is creating a new report to show the average time to resolve incidents for the last quarter. They want the report to automatically update as new incidents are resolved. Which report type should they use?

Question 1mediummultiple choice
Full question →

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

List report with a 'Average' aggregation on the 'Resolved' field.

A List report with an 'Average' aggregation on the 'Resolved' field is the correct choice because it automatically recalculates the average as new records are added or updated, ensuring the report reflects the most current data without manual intervention. List reports in ServiceNow support real-time aggregation on specific fields, making them ideal for dynamic metrics like average resolution time.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Bar chart report with a condition for resolved incidents.

    Why it's wrong here

    Bar chart is a presentation type, not the underlying data aggregation.

  • Pivot table report with a 'Average' aggregation.

    Why it's wrong here

    Pivot tables are for multi-dimensional analysis, not simple average.

  • Scorecard report with a metric for average resolution time.

    Why it's wrong here

    Scorecards are for performance indicators, not dynamic data aggregation.

  • List report with a 'Average' aggregation on the 'Resolved' field.

    Why this is correct

    List reports can compute averages and update dynamically.

    Related concept

    Read the scenario before looking for a memorised answer.

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates confuse report types (List, Pivot, Scorecard) with visualization types (Bar chart) or assume that any report with an aggregation will auto-update, but only List reports with field-level aggregations dynamically reflect new records without manual refresh.

Detailed technical explanation

How to think about this question

Under the hood, ServiceNow List reports use the underlying table's glide record set to perform real-time aggregations via database queries, meaning the 'Average' aggregation on the 'Resolved' field recalculates each time the report is viewed. This contrasts with Scorecard metrics, which are computed by scheduled jobs or indicator sources and may have latency. In a real-world scenario, if an administrator needs a live dashboard for mean time to resolve (MTTR), a List report with aggregation ensures the value updates instantly as agents close incidents, avoiding stale data.

KKey Concepts to Remember

  • Read the scenario before looking for a memorised answer.
  • Find the constraint that changes the correct option.
  • Eliminate answers that are true in general but not in this case.

TExam Day Tips

  • Watch for words such as best, first, most likely and least administrative effort.
  • Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A practitioner preparing for the SNOW-CSA exam encounters this exact type of scenario on the job. The correct answer here is not the most general option — it is the best answer for the specific constraint described. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Real exam questions reward reading the full scenario before eliminating options, because the constraint defines which answer fits.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related practice questions

Related SNOW-CSA practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Practice this exam

Start a free SNOW-CSA practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

FAQ

Questions learners often ask

What does this SNOW-CSA question test?

Reporting, SLA and Imports — This question tests Reporting, SLA and Imports — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: List report with a 'Average' aggregation on the 'Resolved' field. — A List report with an 'Average' aggregation on the 'Resolved' field is the correct choice because it automatically recalculates the average as new records are added or updated, ensuring the report reflects the most current data without manual intervention. List reports in ServiceNow support real-time aggregation on specific fields, making them ideal for dynamic metrics like average resolution time.

What should I do if I get this SNOW-CSA question wrong?

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

2 more ways this is tested on SNOW-CSA

These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.

Variation 1. An administrator has configured a report on the Incident table showing the count of incidents by assignment group. The report shows data for the current week, but the numbers seem too low. The administrator suspects that incidents resolved before the current week are not being included. What should the administrator check first?

medium
  • A.Check the 'Time scale' setting and ensure it is set to 'All' instead of 'Current week'.
  • B.Check the type of the report (e.g., bar chart vs pie chart) as some types only show aggregated data.
  • C.Check the condition (prompt) filter of the report to see if there is a time-based filter that limits to the current week.
  • D.Check the 'Group by' field to ensure it is set to 'Assigned to' instead of 'Assignment group'.

Why C: Option C is correct because the report's condition filter (often called a 'prompt' or 'filter condition') directly controls which records are included. If a time-based condition like 'Opened > Current week' or 'Resolved > Current week' is applied, it would exclude incidents resolved before the current week, causing the low count. The administrator should first inspect the filter conditions to see if such a restriction exists.

Variation 2. A ServiceNow administrator needs to create a report that shows the number of incidents opened each month for the last 12 months. The report should display a bar chart with months on the x-axis and count on the y-axis. Which report type and grouping should the administrator use?

easy
  • A.Bar chart, group by Month on the Opened field
  • B.List report, sort by Opened
  • C.Pie chart, group by Month on the Opened field
  • D.Line chart, group by Day on the Opened field

Why A: Option A is correct because a bar chart is ideal for comparing discrete categories (months) over time, and grouping by Month on the Opened field aggregates incident counts per month. This meets the requirement of showing the number of incidents opened each month for the last 12 months with months on the x-axis and count on the y-axis.

Last reviewed: Jun 11, 2026

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

Sign in to join the discussion.

This SNOW-CSA practice question is part of Courseiva's free ServiceNow certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SNOW-CSA exam.