Free SAP C_HCMOD_05 Exam Dumps Questions & Answers

In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations:Deploy the DIMENSION calculation view as a single object.Deploy the entire SAP HANA database module.What is the outcome of the deploy operations?

• A.  The first deployment is successful.The second deployment is successful.
• B.  The first deployment fails.The second deployment fails.
• C.  The first deployment fails.The second deployment is successful.
• D.  The first deployment is successful.The second deployment fails.

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

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.  .mtar
• C.  .yaml
• D.  .hdiconfig

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes.What is the correct approach?

• A.  Combine the transaction tables using a star join node in a calculation view of type CUBE with star join.Use the same star join node to connect the DIMENSIONS to the fact table.
• B.  Combine the transaction tables using an aggregation node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.
• C.  Combine the transaction tables using a join node in a calculation view of type CUBE with star join.Use a star join node to join the DIMENSIONS to the fact table.
• D.  Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table.

In SAP HANA Cloud, which tasks are handled by the cloud provider?Note: There are 3 correct answers to this question.Sizing, provisioning, and monitoring the database

• A.  Installing, configuring, and upgrading the operating system
• B.  Managing users, roles, and permissions in the database
• C.  Tuning the database to run optimally on the underlying operating system, and hardware
• D.  Backing up the operating system and the database software