nerdexam
Microsoft

70-466 · Question #41

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and InvCount. The report includes a table that displays the invento

The correct answer is B. Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Category Groups.. A Sparkline in SSRS is the correct item for visualizing data trends inline within a table, with Category Groups defining the time axis.

Build reports

Question

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and InvCount. The report includes a table that displays the inventory count per year, as shown in the following diagram. You need to modify the table to include a graphical item displaying the inventory count trend to the right of the Inv Count column. What should you do?

Options

  • AAdd an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then select the MonthNumber field for Value.
  • BAdd a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Category Groups.
  • CAdd an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then assign the MonthNumber field to the Start property.
  • DAdd a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Series Groups.
  • EAdd a text box to a new column on the right of the Inv Count column. Then use a Go to report action to link to a separate report showing the monthly trend.

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    80% (20)
  • C
    4% (1)
  • D
    12% (3)

Why each option

A Sparkline in SSRS is the correct item for visualizing data trends inline within a table, with Category Groups defining the time axis.

AAdd an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then select the MonthNumber field for Value.

An Indicator renders a single directional symbol representing a state, not a multi-point trend chart, and MonthNumber is not a valid Value field for an Indicator.

BAdd a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Category Groups.Correct

A Sparkline is a compact embedded chart specifically designed to display trends over a series of values within a table row. Assigning InvCount to Values provides the metric to plot, and MonthNumber to Category Groups defines the x-axis intervals, producing a per-row monthly trend visualization. This correctly represents inventory count trends across months within each year row.

CAdd an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then assign the MonthNumber field to the Start property.

The Start property on an Indicator defines a range comparison threshold, not a time-series axis, so this configuration cannot produce a trend chart.

DAdd a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Series Groups.

MonthNumber assigned to Series Groups would create separate series (multiple lines) rather than defining the x-axis time categories, producing an incorrect chart structure.

EAdd a text box to a new column on the right of the Inv Count column. Then use a Go to report action to link to a separate report showing the monthly trend.

A text box with a Go to report action creates a navigation hyperlink to a secondary report rather than embedding a graphical trend item directly in the table.

Concept tested: SSRS Sparkline for inline trend visualization

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/sparklines-and-data-bars-report-builder-and-ssrs

Topics

#SSRS sparklines#SSRS indicators#trend visualization#report items

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice