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

Question 1

What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

A. Expected memory consumption

B. Information about join cardinality

C. Usage statistics of the calculation view

D. Joins that are defined on calculated columns

Correct Answer: B,D

Question 2

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 an aggregation node.

B. Use a union node.

C. Use a minus node

D. Use an intersect node.

Correct Answer: D

Question 3

You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

A. The cache data retention period has expired.

B. You did not define any columns in the cache setting.

C. The query requests only a subset of the cached results.

D. You did not define a filter in the cache setting.

Correct Answer: B

Question 4

You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to deploy the calculation view, the deployment fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

A. An .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view.

B. The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

C. The imported calculation view and its data source have different namespaces.

D. The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

Correct Answer: B,C

Question 5

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 fails and the table is not dropped.

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

C. The deployment fails and the table is dropped.

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

Correct Answer: A

Question 6

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. Create graph workspaces

B. Develop SAP Fiori apps

C. Configure data tiering

D. Develop calculation views

Correct Answer: A,D

Question 7

You created a procedure to be consumed in an analytic privilege of the type DYNAMIC, but it isn't working as expected.What could be the reason?Note: There are 2 correct answers to this question.

A. The procedure is write-enabled

B. The output parameter is defined as NVARCHAR

C. You defined more than one output parameter

D. No input parameter is specified

Correct Answer: C,D

Question 8

What is a restricted measure?

A. A measure that can only be displayed by those with necessary privileges.

B. A measure that cannot be referenced by a calculated column.

C. A measure that can be consumed by a CUBE and not a DIMENSION.

D. A measure that is filtered by one or more attribute values.

Correct Answer: D

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. Join cardinality is set :1.

B. Integrity constraint is set to RIGHT.

C. The Country column is requested.

D. The Keep flag is activated for the Customer column.

Correct Answer: A,B

Welcome to TestSimulate

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