Exam 70-466 topic 1 question 133 discussion

Actual exam question from Microsoft's 70-466

Question #: 133
Topic #: 1

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and RegCount. The report includes a table that displays the number of recorded registration occurrences per year, as shown in the following table.

You need to modify the table to include a graphical item displaying the monthly registration trend to the right of the Reg Count column.
What should you do?

A. Add an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then assign the MonthNumber field to the Start property.
B. Add an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then select the MonthNumber field for Value.
C. Add a Sparkline item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for Series Groups.
D. Add a text box to a new column on the right of the Reg Count column. Then use a Go to report action to link to a separate report showing the monthly trend.
E. Add a Sparkline item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for

Show Suggested Answer

Suggested Answer: B 🗳️
In Reporting Services paginated reports,indicators are small gauges that convey the state of a single data value at a glance.
Incorrect Answers:
E: Sparklines and data bars are small, simple charts that convey a lot of information in a little space, often inline with text.
References:
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/indicators-report-builder-and-ssrs

by [deleted] at April 4, 2025, 12:27 p.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!