Question 1

A hierarchy in a dimension is usually visualized in an OLAP client like Excel as

A)

3D view

B)	Relation view

C)

Tree view

D)

Link view

Question 2

Which of the following statement about Excel pivot table is incorrect?

A)	Pivot table is used to display cube query results.

B)	A slicer can be used for multiple pivot tables.

C)	One pivot table can span across multiple Excel sheets.

D)	More than one pivot tables can be placed on one Excel sheet.

Question 3

Excel pivot table can use the following data sources except:

	SSAS
	SSIS
	Excel spreadsheet
	SQL Server Database Engine