Question 1

What is the default view node for a cube?

Options :

A : PROJECTION

B : SEMANTICS

C : AGGREGATION

D : UNION

Answer: C

Question 2

What is the default view node for a cube?

Options :

A : PROJECTION

B : SEMANTICS

C : AGGREGATION

D : UNION

Answer: C

Question 3

What can you do with shared hierarchies? Note:There are 2 correct answers to this question.

Options :

A : Access hierarchies created in external schemas

B : Enable SQL SELECT statements to access hierarchies

C : Provide reusable hierarchies for drilldown in a CUBE with star join

D : Provide reusable hierarchies for drilldown in a CUBE without star join

Answer: B,D

Question 4

Why would you create SQL in calculation views?

Options :

A : To implement custom logic

B : To provide an alternative to graphical modeling

C : To fine-tune performance

D : To enable write capabilities

Answer: A

Question 5

In a calculation view, what is the purpose of a variable?

Options :

A : To pass values between procedures and calculation views

B : To provide a dynamic value in a calculated column

C : To break up complex SQL into smaller steps

D : To filter an attribute at runtime based on a user input

Answer: D