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

• A.Provide reusable hierarchies for drilldown in a CUBE with star join
• B.Access hierarchies created in external schemas
• C.Enable SQL SELECT statements to access hierarchies
• D.Provide reusable hierarchies for drilldown in a CUBE without star join

Comment: *

Name: *

Email: *

Verification: *

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

• A.To generate a calculated column
• B.To generate a restricted column
• C.To define a filter
• D.To convert currencies
• E.To generate hierarchies

Comment: *

Name: *

Email: *

Verification: *

A calculation view consumes the data sources shown in the graphic.

You want to identify which companies sold products in January AND February. What is the optimal way to do this?

• A.Use an intersect node.
• B.Use an aggregation node.
• C.Use a minus node
• D.Use a union node.

Comment: *

Name: *

Email: *

Verification: *

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

• A.Query processing time improves
• B.SQL compilation time increases
• C.Count-distinct results are incorrect
• D.Results are read from static cache

Comment: *

Name: *

Email: *

Verification: *

In a database module, what is the purpose of the .hdiconfig file?

• A.To specify an external schema in which calculation views will get their data
• B.To specify the namespace rules applicable to the name of database objects
• C.To specify which HDI plug-ins are available
• D.To specify in which space the container should be deployed

Comment: *

Name: *

Email: *

Verification: *