Free SAP C_HCMOD_05 Exam Questions (page: 15)

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?

  1. 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.
  2. 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.
  3. 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.
  4. 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.

Answer(s): C



What are some best practices when developing calculation views?
Note: There are 2 correct answers to this question.

  1. Model star schemas using a sequence of join nodes.
  2. Aggregate at the lowest possible node.
  3. Include all data flow logic within one calculation view.
  4. Avoid defining joins on calculated columns.

Answer(s): B,D



In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

  1. Scalar function
  2. Table function
  3. Anonymous block
  4. Procedure

Answer(s): B



What are some of the typical roles in an SAP HANA Cloud implementation?
Note: There are 2 correct answers to this question.

  1. Data architect
  2. Modeler
  3. Kubernetes expert
  4. ABAP developer

Answer(s): A,B



Viewing page 15 of 23



Post your Comments and Discuss SAP C_HCMOD_05 exam prep with other Community members:

C_HCMOD_05 Exam Discussions & Posts