What is the C_HCMOD_05 SAP Certified Application Associate – SAP HANA Cloud Modeling Exam?

1. What can you do with shared hierarchies? Note: There are 2 correct answers to this question.

2. Why would you create SQL in calculation views?

3. Which type of join supports a temporal condition in a calculation view?

4. Refer to the Exhibit.

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

5. What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.

6. What do you use in the definition of a dynamic SQL analytic privilege?

7. Which tool generates and executes the SQL for a specific node of your calculation view?

8. You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

9. You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes.

What is the correct approach?

10. What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

11. In your calculation view, you want to consume a custom data source defined using SQLScript.

In which type of object do you write your code?

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

13. In a calculation view, your table function node executes a table function that requires input parameters.

How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

14. In a database module, what is the purpose of the .hdiconfig file?

15. You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram.

When you preview calculation view A, the account number is not masked.

What could be the reason?

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

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

18. You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.

Which of the following could be a valid reason?

19. Why would you choose an HDI-shared service plan instead of a schema service plan? Note: There are 3 correct answers to this question.

20. 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?

21. 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?

22. At which levels of a project structure can you execute a deploy operation? Note: There are 2 correct answers to this question.

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

24. What is generated when you deploy a CUBE calculation view design-time file? Note: There are 2 correct answers to this question.

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

26. You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL.

Which of the following conditions must be met? Note: There are 2 correct answers to this question.

27. Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?

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

29. What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.

30. What is a restricted measure?