nerdexam
Microsoft

70-460 · Question #73

You are creating a new report in SQL Server Report Builder. You add a Windows Azure SQL Database data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales…

The correct answer is A. Adjacent Below. See the full explanation below for the reasoning.

Question

You are creating a new report in SQL Server Report Builder. You add a Windows Azure SQL Database 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 table. 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 Country field on the rows and a grouping of the Year field on the columns. You need to add the categories on the rows of the matrix. Which Row Group option should you select when you add the group?

Exhibit

70-460 question #73 exhibit

Options

  • AAdjacent Below
  • BChild Group
  • CParent Group
  • DAdjacent Above

How the community answered

(48 responses)
  • A
    77% (37)
  • B
    13% (6)
  • C
    4% (2)
  • D
    6% (3)

Community Discussion

No community discussion yet for this question.

Full 70-460 Practice