Labour Day Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

Note! C_HCMOD_03 has been withdrawn. The new exam code is C_HCMOD_05

C_HCMOD_03 Practice Exam Questions with Answers SAP Certified Application Associate - SAP HANA Cloud Modeling Certification

Question # 6

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

A.

To pass values between procedures and calculation views

B.

To provide a dynamic value in a calculated column

C.

To break up complex SQL into smaller steps

D.

To filter an attribute at runtime based on a user input

Full Access
Question # 7

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.

C_HCMOD_03 question answer

What could be the problem?Note: There are 2 correct answers to this question.

A.

The Country column is requested.

B.

Join cardinality is set :1.

C.

The Keep flag is activated for the Customer column.

D.

Integrity constraint is set to RIGHT.

Full Access
Question # 8

You have generated a calculation view properties file.What does it contain?

A.

Descriptions of all objects defined in a calculation view

B.

All settings defined in a calculation view

C.

Dependencies between calculation views

D.

Documentation to support the calculation view

Full Access
Question # 9

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud?Note: There are 2 correct answers to this question.

A.

Pre-calculated aggregates

B.

Indexes

C.

Stored procedures

D.

Table partitions

Full Access
Question # 10

Why would you enable Debug Query mode in a calculation view?

A.

To identify data sources that are not accessed by a query

B.

To check which database engines are invoked

C.

To set breakpoints and step through the execution

D.

To understand how tables are partitioned

Full Access
Question # 11

Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

A.

Fiscal

B.

Julian

C.

Gregorian

D.

Factory

Full Access
Question # 12

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.

B.

"?"

C.

"0"

D.

"Null"

Full Access