Free SAP C-HCMOD-05 Exam Dumps Questions & Answers

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

Referring to the diagram,

which privileges would a user require to view United States data when querying the CUBE calculation view?

• A.SELECT privileges and Analytic Privileges (Country = United States) on both views
• B.A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
• C.A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
• D.A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

What are the key steps to implement currency conversion in a calculation view?

• A.Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Deploy the conversion rule
• B.Assign semantic type Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type
• C.Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type/Assign the conversion rule to your calculation view
• D.Assign semantic type/Choose client, source, and target currencies/Choose conversion date and rate type/Define an expression in a calculated column

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 but the data preview returns an error message.
• C.The deployment fails and the table is dropped.
• D.The deployment is successful and the data preview returns expected data.

Which tool generates and executes the SQL for a specific node of your calculation view?

• A.Explain plan
• B.Debug Query mode
• C.SQL analyzer
• D.Database explorer