SAP C_HCMOD_02 Exam Practice Test Instant Access

Question 1

Using the table in the diagram, you need to create a CUBE calculation view.

What is the simplest approach to create the output shown in the screenshot?

AImplement a union node and map each country as a separate column.

BCreate a restricted column for each country.

CCreate a filter expression that uses an OR operator.

DCreate 3 calculated columns.

Answer : B

Question 2

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

AAvoid aggregating data early in the data flow.

BPartition large tables.

CLimit the number of stacked calculation views.

DImplement union pruning.

Answer : B, C

Question 3

What are some of the typical tasks performed by the SAP HANA Cloud modeler role? Note: There are 2 correct answers to this question.

ACreate graph workspaces

BConfigure data tiering

CDevelop calculation views

DDevelop SAP Fiori apps

Answer : A, C

Question 4

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it.What do you observe in the SAP HANA database container?

AThe deployment is successful but the data preview returns an error message.

BThe deployment fails and the table is not dropped.

CThe deployment fails and the table is dropped.

DThe deployment is successful and the data preview returns expected data.

Answer : B

Question 5

Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

ATo improve response time when multiple users access the same table

BTo improve query performance when accessing large column tables

CTo improve data replication performance on large row tables

DTo overcome the 2 billion record limit

Answer : D

Question 6

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

ARead performance decreases.

BNew records are not read.

CMemory is not optimized.

DAggregates are not adjusted.

Answer : A, B

Question 7

You set the Null Handling property for an attribute but do not set a default value.What is displayed when null values are found in a column of data type NVARCHAR?

A<empty string>

B'?'

C'0'

D'Null'

Answer : A

SAP C_HCMOD_02 SAP Certified Application Associate - SAP HANA Cloud Modeling Exam Practice Test