Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. SAP
  5. C_HCMOD_05

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

Updated On: 23-Apr-2026
Page 2 of 19
PDF with 88 Questions

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



Why would you create SQL in calculation views?

  1. To implement custom logic
  2. To provide an alternative to graphical modeling
  3. To fine-tune performance
  4. To enable write capabilities

Answer(s): A



Which type of join supports a temporal condition in a calculation view?

  1. Referential join
  2. Inner join
  3. Text join
  4. Left outer join

Answer(s): B



Refer to the Exhibit.
Referring to the diagram,



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

  1. A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
  2. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
  3. A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
  4. SELECT privileges and Analytic Privileges (Country = United States) on both views

Answer(s): A



What options do you have to handle orphan nodes in your hierarchy?
Note: There are 2 correct answers to this question.

  1. Define an expression to determine a parent.
  2. Generate additional root nodes.
  3. Assign them to a level below the root.
  4. Assign them to a node at the root level.

Answer(s): B,C



Viewing page 2 of 19
Viewing questions 6 - 10 out of 88 questions
Share your experience with other


AI Tutor AI Tutor 👋 I’m here to help!