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 shared hierarchy.
• B.The hierarchy must be a local hierarchy.
• C.The hierarchy must be a parent-child hierarchy.
• D.The hierarchy must be exposed by a calculation view of type CUBE with star join.

Comment: *

Name: *

Email: *

Verification: *

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it.What do you observe in the SAP HANA database container?

• A.The deployment fails and the table is not dropped.
• B.The deployment is successful and the data preview returns expected data.
• C.The deployment fails and the table is dropped.
• D.The deployment is successful but the data preview returns an error message.

Comment: *

Name: *

Email: *

Verification: *

Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note: There are 2 correct answers to this question.

• A.Use an inner join
• B.Define join direction in a full outer join
• C.Limit the number of joined columns
• D.Specify the join cardinality

Comment: *

Name: *

Email: *

Verification: *

You have generated a calculation view properties file.What does it contain?

• A.All settings defined in a calculation view
• B.Documentation to support the calculation view
• C.Descriptions of all objects defined in a calculation view
• D.Dependencies between calculation views

Comment: *

Name: *

Email: *

Verification: *

At which levels of a project structure can you execute a deploy operation?Note: There are 2 correct answers to this question.

• A.Individual source file
• B.Sub-folder of a database module
• C.Entire workspace
• D.Individual container

Comment: *

Name: *

Email: *

Verification: *