SAP C_HCMOD_05 Exam Questions Instant Access

Question 1

Which components are part of SAP HANA Cloud?Note: There are 2 correct answers to this question.

ASAP Analytics Cloud

BData lake

CSAP HANA database

DSAP Enterprise Architecture Designer

Answer : B, C

Question 2

In a calculation view, what is the purpose of a variable?

ATo pass values between procedures and calculation views

BTo provide a dynamic value in a calculated column

CTo break up complex SQL into smaller steps

DTo filter an attribute at runtime based on a user input

Answer : D

Question 3

You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

AStaging area -> Working directory -> Local Git repository

BWorking directory -> Staging area -> Local Git repository

CWorking directory -> Local Git repository -> Staging area

DLocal Git repository -> Staging area -> Working directory

Answer : B

Question 4

Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

ASQL expression

BDynamic

CHierarchy function

DAttributes

EGraph

Answer : A, B, D

Question 5

You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

ADeploy the folder that contained the deleted design-time file.

BExecute a DROP statement in an SQL Console connected to the HDI container.

CDeploy the project that contained the deleted design-time file.

DExecute the refactor function for the calculation view.

Answer : C

Question 6

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

ATo benefit from additional SQL optimizations

BIncorrect aggregations may be generated

CColumn engine language is not supported.

DTo define limits for query unfolding

Answer : A

Question 7

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.hdiconfig

B.mtar

C.yaml

D.namespace

Answer : C

SAP Certified Application Associate - SAP HANA Cloud Modeling C_HCMOD_05 Exam Questions