SAP Certified Application Associate - SAP HANA Cloud Modeling

QUESTION NO: 1
Why would you create SQL in calculation views?

A. To provide an alternative to graphical modeling B. To fine-tune performance C. To enable write capabilities D. To implement custom logic

Correct Answer: D

QUESTION NO: 2
Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.

A. To display the execution time of a calculation view B. To preview data at the node level of a calculation view C. To warn of potential performance issues related to calculated columns D. To identify the root data sources of a function

Correct Answer: A,B

QUESTION NO: 3
Why would you choose an HDI-shared service plan instead of a schema service plan?Note: There are 3 correct answers to this question.

A. You want to use SAP Business Application Studio. B. You want to use containers to isolate objects. C. You want to develop calculation views. D. You want to use synonyms to access external data. E. You want to create database objects using source files.

Correct Answer: A,B,E

QUESTION NO: 4
What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.

A. Memory is not optimized. B. New records are not read. C. Read performance decreases. D. Aggregates are not adjusted.

Correct Answer: B,C

QUESTION NO: 5
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?

A. Incorrect aggregations may be generated B. Column engine language is not supported. C. To benefit from additional SQL optimizations D. To define limits for query unfolding

Correct Answer: C

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

A. Modeler B. Kubernetes expert C. ABAP developer D. Data architect

Correct Answer: A,D

QUESTION NO: 7
In a calculation view, your table function node executes a table function that requires input parameters.
How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

A. Create and map an input parameter B. Assign a hierarchy node. C. Define constant values. D. Reference the output of a procedure. E. Map columns from lower nodes.

Correct Answer: A,C,E

QUESTION NO: 8
You created a procedure to be consumed in an analytic privilege of the type DYNAMIC, but it isn't working as expected.What could be the reason?Note: There are 2 correct answers to this question.

A. The output parameter is defined as NVARCHAR B. No input parameter is specified C. The procedure is write-enabled D. You defined more than one output parameter

Correct Answer: B,D

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

A. Data lake B. SAP Analytics Cloud C. SAP HANA database D. SAP Enterprise Architecture Designer

Correct Answer: A,C

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