SAP Certified Application Associate - SAP HANA Cloud Modeling (C-HCMOD-01) Free Practice Test

Question 1

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. Stored procedures

C. Table partitions

D. Indexes

Correct Answer: A,D

Question 2

You want to ensure that your calculation view does not give unexpected results based on the selected columns in the query. What is the recommended approach for verifying the results?

A. Set the HIDE property for columns NOT required.

B. Select and deselect columns from the output mapping.

C. Select Data Preview for the calculation view.

D. Execute a custom SQL query in the SQL Console.

Correct Answer: C,D

Question 3

Why would you create SQL in calculation views?

A. To enable write capabilities

B. To implement custom logic

C. To provide an alternative to graphical modeling

D. To fine-tune performance

Correct Answer: B

Question 4

What are the key steps to implement currency conversion in a calculation view?

A. Assign semantic type/Choose client, source, and target currencies/Choose conversion date and rate type/Define an expression in a calculated column

B. Assign semantic type/Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type

C. Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type/Assign the conversion rule to your calculation view

D. Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type/Deploy the conversion rule

Correct Answer: B

Question 5

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

A. To lock the calculation view from further modifications

B. To warn developers that the calculation view is no longer supported

C. To ensure it is not exposed to reporting tools for consumption

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

Correct Answer: B,C

Question 6

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

A. To filter an attribute at runtime based on a user input

B. To break up complex SQL into smaller steps

C. To pass values between procedures and calculation views

D. To provide a dynamic value in a calculated column

Correct Answer: B

Question 7

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

A. Fiscal

B. Factory

C. Julian

D. Gregorian

Correct Answer: A,D

Question 8

Why would you use the Transparent Filter property in a calculation view?

A. To avoid columns being unnecessarily used in an aggregation

B. To allow filter push-down in stacked calculation views

C. To apply filters that are hidden from the end user

D. To include columns that are NOT requested by a query

Correct Answer: B

Question 9

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. Reference the output of a procedure.

B. Define constant values.

C. Assign a hierarchy node.

D. Create and map an input parameter.

E. Map columns from lower nodes.

Correct Answer: B,D,E

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA Cloud Modeling (C-HCMOD-01) Free Practice Test