70-460 Question #15: Real Exam Question with Answer & Explanation

You are creating a new report in SQL Server Report Builder. You add a SQL Azure data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales. You must design a matrix as shown in the following diagram. The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows (the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year. You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns. You need to add the countries on the rows of the matrix. Which Row Group option should you select when you add the group?