SAP Certified Application Associate - SAP HANA Cloud Modeling

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

A. To define a filter B. To convert currencies C. To generate a calculated column D. To generate a restricted column E. To generate hierarchies

Correct Answer: A,C,D

QUESTION NO: 2
What are some of the typical roles in an SAP HANA Cloud implementation?Note: There are 2 correct answers to this question.

A. Modeler B. Kubernetes expert C. ABAP developer D. Data architect

Correct Answer: A,D

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

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

Correct Answer: A,D

QUESTION NO: 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. The imported calculation view and its data source have different namespaces. 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. 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. D. The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

Correct Answer: A,B

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

A. To warn developers that the calculation view is no longer supported B. To lock the calculation view from further modifications 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: A,C

QUESTION NO: 6
When is the first column store compression executed?

A. Question B. When a delta merge is triggered C. When the table is created D. When a backup is started E. When partitions are regenerated

Correct Answer: B

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

A. Use dynamic SQL. B. Break up large statements by using variables. C. Control the flow logic using IF-THEN-ELSE conditions. D. Choose declarative language instead of imperative language.

Correct Answer: B,D

QUESTION NO: 8
What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.

A. It is restricted to one DIMENSION in a star join node. B. It CANNOT be mixed in the same star join node with other join types. C. It must appear in the last DIMENSION in the star join node. D. Only one column can be included in the join condition.

Correct Answer: A,C

QUESTION NO: 9
Which type of join supports a temporal condition in a calculation view?

A. Text join B. Inner join C. Referential join D. Left outer join

Correct Answer: B

SAP Certified Application Associate - SAP HANA Cloud Modeling - C-HCMOD-02 Exam Questions