You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of the following conditions must be met? Note: There are 2 correct answers to this question.

• A.The hierarchy must be a parent-child hierarchy.
• B.The hierarchy must be exposed by a calculation view of type CUBE with star join.
• C.The hierarchy must be a shared hierarchy.
• D.The hierarchy must be a local hierarchy.

Comment: *

Name: *

Email: *

Verification: *

Why would you use the Transparent Filter property in a calculation view?

• A.To allow filter push-down in stacked calculation views
• B.To avoid columns being unnecessarily used in an aggregation
• C.To apply filters that are hidden from the end user
• D.To include columns that are NOT requested by a query

Comment: *

Name: *

Email: *

Verification: *

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2 correct answers to this question.

• A.The Country column is requested.
• B.Integrity constraint is set to RIGHT.
• C.The Keep flag is activated for the Customer column.
• D.Join cardinality is set :1.

Comment: *

Name: *

Email: *

Verification: *

You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?

• A.Joins
• B.Data sources of unions
• C.Filters
• D.Calculated columns

Comment: *

Name: *

Email: *

Verification: *

You create a user-provided service to access tables in external schemas. In which file type do you assign the user-provided service to your database module?

• A..namespace
• B..yaml
• C..mtar
• D..hdiconfig

Comment: *

Name: *

Email: *

Verification: *