C_HCMOD_02 Exam Training Practice Tests (SAP Certified Application Associate

Question 1

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

A. To overcome the 2 billion record limit B. To improve response time when multiple users access the same table C. To improve query performance when accessing large column tables D. To improve data replication performance on large row tables

Correct Answer: A

Question 2

You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.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. Write and execute a custom SQL query in the SQL Console.

Correct Answer: C,D

Question 3

Which solutions form the SAP Business Technology Platform? Note: There are 2 correct answers to this question.

A. Analytics B. Application Development & Integration C. Experience Management D. Intelligent Suite

Correct Answer: A,B

Question 4

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

A. To check which database engines are invoked B. To set breakpoints and step through the execution C. To understand how tables are partitioned D. To identify data sources that are not accessed by a query

Correct Answer: D

Question 5

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 start with a node that defines a table as a data source. 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 only have one start node.

Correct Answer: A,C

Question 6

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 procedure that returns the data access condition as an SQL expression. C. An organization hierarchy that provides role-based access to data. D. A scalar function that returns a list of the allowed values for each attribute.

Correct Answer: B

Question 7

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

A. Query processing time improves B. Count-distinct results are incorrect C. SQL compilation time increases D. Results are read from static cache

Correct Answer: B,C

Question 8

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

A. Develop calculation views B. Develop SAP Fiori apps C. Create graph workspaces D. Configure data tiering

Correct Answer: A,C

Question 9

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

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

A. The Keep flag is activated for the Customer column. B. The Country column is requested. C. Join cardinality is set :1. D. Integrity constraint is set to RIGHT.

Correct Answer: C,D

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