70-467 Question #56: Real Exam Question with Answer & Explanation

The correct answer is B: Excel 2010, using a PivotTable. A Regional Sales report requires a tool that supports cross-tabular or pivoted data aggregation by region. Excel PivotTable and Report Builder Matrix both provide native row-column grouping with subtotals that fulfill this requirement completely.

Question

You need to select an appropriate tool for creating the Regional Sales report. Which tools or tools should you use? (Each Answer presents a complete solution. Choose all that apply.)

Options

APower View, using a table configured for vertical multiples
BExcel 2010, using a PivotTable
CReport Builder, using a Matrix
DPower View, using a table configured for horizontal multiples

Explanation

A Regional Sales report requires a tool that supports cross-tabular or pivoted data aggregation by region. Excel PivotTable and Report Builder Matrix both provide native row-column grouping with subtotals that fulfill this requirement completely.

Common mistakes.

A. Power View vertical multiples produce a series of small repeated charts stacked vertically for each category, which is a small-multiples visualization style rather than a consolidated tabular regional report.
D. Power View horizontal multiples produce side-by-side small chart panels for each category value, not a traditional tabular or matrix report layout suitable for a Regional Sales report.

Concept tested. Selecting BI tools for tabular regional sales reporting

Reference. https://learn.microsoft.com/en-us/sql/reporting-services/report-design/matrix-report-builder-and-ssrs

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice