Black Friday / Cyber Monday Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: myex65

Home > SAP > SAP Certified Application Associate > C_HCMOD_02

C_HCMOD_02 SAP Certified Application Associate - SAP HANA Cloud Modeling Question and Answers

Question # 4

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

A.

Query processing time improves

B.

Results are read from static cache

C.

SQL compilation time increases

D.

Count-distinct results are incorrect

Full Access
Question # 5

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL.Which of the following conditions must be met?Note: There are 2 correct answers to this question.

A.

The hierarchy must be exposed by a calculation view of type CUBE with star join.

B.

The hierarchy must be a shared hierarchy.

C.

The hierarchy must be a local hierarchy.

D.

The hierarchy must be a parent-child hierarchy.

Full Access
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

A calculation view consumes the data sources shown in the graphic.

You want to identify which companies sold products in January AND February. What is the optimal way to do this?

A.

Use a union node.

B.

Use an intersect node.

C.

Use an aggregation node.

D.

Use a minus node

Full Access
Question # 8

What do you use in the definition of a dynamic SQL analytic privilege?

A.

A table function that returns a list of allowed values.

B.

A scalar function that returns a list of the allowed values for each attribute.

C.

A procedure that returns the data access condition as an SQL expression.

D.

An organization hierarchy that provides role-based access to data.

Full Access
Question # 9

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?

A.

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

B.

The deployment fails and the table is not dropped.

C.

The deployment fails and the table is dropped.

D.

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

Full Access
Question # 10

Why might you use the Keep Flag property in an aggregation node?

A.

To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

B.

To exclude columns that are NOT requested by a query to avoid incorrect results

C.

To include columns that are NOT requested by a query but are essential for the correct result

D.

To retain the correct aggregation behavior in stacked views

Full Access
Question # 11

In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

A.

To ensure it is not exposed to reporting tools for consumption

B.

To indicate that it should not be used as a data source to other calculation views

C.

To warn developers that the calculation view is no longer supported

D.

To lock the calculation view from further modifications

Full Access
Question # 12

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