1.Change the following MDX query to pivot the Date dimension to rows.

SELECT ([Product].[Category].[Category], [Date].[Calendar].[Calendar Year]) ON COLUMNS, [Customer].[Country].[Country] ON ROWS FROM [Adventure Works] WHERE [Measures].[Internet Sales Amount]

2. Which of the following statements is correct about MDX?

A.An MDX query must specify the ROWS axis ("ON ROWS") in the SELECT clause

B.An MDX query must specify both ROWS axis (on rows) and COLUMNS axis (on columns) in the SELECT clause

C.An MDX query must specify the COLUMNS axis ("ON COLUMNS") in the SELECT clause

D.An MDX query cannot have a ROWS axis (on rows) without a COLUMNS axis (on columns) in the SELECT clause

3.Which of the following application cannot be used as an OLAP client?

A. SSAS

B.SSMS

C. SSRS

D. Excel