SAP Certified Application Associate - SAP HANA Cloud Modeling

Question 1

Which of the following approaches might improve the performance of joins in a CUBE calculation view?
Note: There are 2 correct answers to this question.

A. Using an inner join

B. Limiting the number of joined columns

C. Specifying the join cardinality

D. Determining join direction in a full outer join

Correct Answer: B,C

Question 2

In a calculation view, what is the purpose of a variable?

A. To pass values between procedures and calculation views

B. To break up complex SQL into smaller steps

C. To provide a dynamic value in a calculated column

D. To filter an attribute at runtime based on a user input

Correct Answer: B

Question 3

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 force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query

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

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

Correct Answer: A,D

Question 4

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. Execute the refactor function for the calculation view.

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

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

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

Correct Answer: D

Question 5

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name. How do you ensure that each customer name appears only once in the results?

A. In the union node, map both source customer name columns to one target column.

B. Define a restricted column in a union node.

C. Add an intersect node above the union node.

D. Include an aggregation node above the union node.

Correct Answer: D

Question 6

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. .hdiconfig

B. .mtar

C. .yaml

D. .namespace

Correct Answer: C

Question 7

Which calendar types can be selected when creating time-based DIMENSIONS? Note: There are 2 correct answers to this question.

A. Factory

B. Gregorian

C. Fiscal

D. Julian

Correct Answer: B,C

Question 8

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

A. Count-distinct results are incorrect

B. SQL compilation time increases

C. Query processing time improves

D. Results are read from static cache

Correct Answer: A,B

Question 9

Which components are part of SAP HANA Cloud? Note: There are 3 correct answers to this question.

A. SAP Enterprise Architecture Designer

B. SAP Analytics Cloud

C. Data lake

D. SAP HANA database

E. SAP Adaptive Server Enterprise

Correct Answer: C,D,E

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

Latest Update

Useful Links

Contact Us