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

Question 1

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

A. Break up large statements by using variables.

B. Use dynamic SQL.

C. Choose declarative language instead of imperative language.

D. Control the flow logic using IF-THEN-ELSE conditions.

Correct Answer: A,C

Question 2

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 3

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 4

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

A. To generate a calculated column

B. To define a filter

C. To generate hierarchies

D. To convert currencies

E. To generate a restricted column

Correct Answer: A,B,E

Question 5

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 6

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

Question 7

You create a user-provided service to access tables in external schemas.In which file type do you assign the user-provided service to your database module?

A. .yaml

B. .namespace

C. .hdiconfig

D. .mtar

Correct Answer: A

Question 8

You combine two tables in a join node using multiple columns in each table.Why do you enable the dynamic join option? Note: There are 2 correct answers to this question.

A. To allow data analysis at different levels of granularity with the same calculation view

B. To ensure that the join execution only uses the join columns requested in the query

C. To ensure that the aggregation always happens after the join execution

D. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query

Correct Answer: A,B

Question 9

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

Welcome to TestSimulate

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