Free SAP C_HCMOD_05 Exam Dumps Questions & Answers

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.  Integrity constraint is set to RIGHT.
• B.  The Keep flag is activated for the Customer column.
• C.  Join cardinality is set :1.
• D.  The Country column is requested.

Why would you choose an HDI-shared service plan instead of a schema service plan?Note: There are 3 correct answers to this question.

• A.  You want to use SAP Business Application Studio.
• B.  You want to develop calculation views.
• C.  You want to use synonyms to access external data.
• D.  You want to create database objects using source files.
• E.  You want to use containers to isolate objects.

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

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 a minus node
• B.  Use an intersect node.
• C.  Use an aggregation node.
• D.  Use a union node.

Referring to the diagram,

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

• A.  A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
• B.  SELECT privileges and Analytic Privileges (Country = United States) on both views
• 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