Certified Application Associate - SAP HANA Cloud Modeling (C_HCMOD_02) Free Practice Test

Question 1

What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

A. Include all data flow logic within one calculation view.

B. Model star schemas using a sequence of join nodes.

C. Avoid defining joins on calculated columns.

D. Aggregate at the lowest possible node.

Correct Answer: A,C

Question 2

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

C. Define constant values.

D. Assign a hierarchy node.

E. Map columns from lower nodes.

Correct Answer: A,C,E

Question 3

You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?

A. Data sources of unions

B. Joins

C. Filters

D. Calculated columns

Correct Answer: C

Question 4

What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.

A. The block must only have one start node.

B. Multiple blocks can only be defined within a single calculation view.

C. Only one block can be defined across a stack of calculation views.

D. The block must start with a node that defines a table as a data source.

Correct Answer: C,D

Question 5

Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?

A. They introduce potential security risks.

B. They can limit parallelization of query execution.

C. They call multiple processing engines.

D. They could modify the database.

Correct Answer: A

Question 6

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

A. To improve query performance when accessing large column tables

B. To improve data replication performance on large row tables

C. To improve response time when multiple users access the same table

D. To overcome the 2 billion record limit

Correct Answer: D

Question 7

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 8

You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

A. Deploy the project that contained the deleted design-time file.

B. Execute the refactor function for the calculation view.

C. Deploy the folder that contained the deleted design-time file.

D. Execute a DROP statement in an SQL Console connected to the HDI container.

Correct Answer: A

Question 9

In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

A. Scalar function

B. Anonymous block

C. Procedure

D. Table function

Correct Answer: D

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA Cloud Modeling (C_HCMOD_02) Free Practice Test