How to Become an SAP HANA Cloud Application Consultant by Passing C_HCMOD_03 Exam?

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

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

3. Why would you create calculation views of data category DIMENSION with type TIME?

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

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

6. You set the Null Handling property for an attribute but do not set a default value.

What is displayed when null values are found in a column of data type NVARCHAR?

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

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

9. Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud? Note: There are 2 correct answers to this question.

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

11. Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

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

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

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

15. What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.

16. Which of the following techniques can you use to improve the performance of calculation views? Note: There are 2 correct answers to this question.

17. Why would you use the Transparent Filter property in a calculation view?

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

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

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

21. A new version of SAP HANA Cloud, SAP HANA database is available from today.

If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?

22. Why would you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question.

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

24. In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations: Deploy the DIMENSION calculation view as a single object. Deploy the entire SAP HANA database module.

What is the outcome of the deploy operations?

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

26. Why do you use the Hidden Columns checkbox in the semantics node of your calculation view? Note: There are 2 correct answers to this question.

27. You have defined a pruning configuration table in a calculation view.

What are you attempting to prune from the query execution?

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

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

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