Microsoft
70-466 · Question #41
70-466 Question #41: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #41. The question stem and answer options stay visible for context.
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.
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SSRS sparklines#SSRS indicators#trend visualization#report items