SAP C_HCMOD_05 Exam
SAP Certified Application Associate - SAP HANA Cloud Modeling (Page 2 )

Updated On: 1-Feb-2026

What can you do with shared hierarchies?
Note:There are 2 correct answers to this question.

  1. Access hierarchies created in external schemas
  2. Enable SQL SELECT statements to access hierarchies
  3. Provide reusable hierarchies for drilldown in a CUBE with star join
  4. Provide reusable hierarchies for drilldown in a CUBE without star join

Answer(s): B,D



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

  1. Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Deploy the conversion rule
  2. 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
  3. Assign semantic type/Choose client, source, and target currencies/Choose conversion date and rate type/Define an expression in a calculated column
  4. Assign semantic type Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type

Answer(s): D



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.

  1. Specify the join cardinality
  2. Limit the number of joined columns
  3. Use an inner join
  4. Define join direction in a full outer join

Answer(s): A,B



Why would you use the Transparent Filter property in a calculation view?

  1. To include columns that are NOT requested by a query
  2. To avoid columns being unnecessarily used in an aggregation
  3. To apply filters that are hidden from the end user
  4. To allow filter push-down in stacked calculation views

Answer(s): B



Why would you create calculation views of data category DIMENSION with type TIME?

  1. To provide additional time-related navigation possibilities
  2. To add a temporal condition to a join to find matching records from two tables based on a date
  3. To store historical versions of attributes
  4. To provide the time intervals required by time-dependent parent-child hierarchies

Answer(s): A



Viewing page 2 of 19
Viewing questions 6 - 10 out of 88 questions



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

Join the C_HCMOD_05 Discussion