Online Access Free C-HCMOD-02 Exam Questions

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?

• A.7 months
• B.3 months
• C.1 year
• D.2 weeks

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 indicate that it should not be used as a data source to other calculation views
• C.To lock the calculation view from further modifications
• D.To ensure it is not exposed to reporting tools for consumption

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

• A.Explain plan
• B.Database explorer
• C.Debug Query mode
• D.SQL analyzer

Why might you use the Keep Flag property in an aggregation node?

• A.To include columns that are NOT requested by a query but are essential for the correct result
• B.To exclude columns that are NOT requested by a query to avoid incorrect results
• C.To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
• D.To retain the correct aggregation behavior in stacked views

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

• A.Implement union pruning.
• B.Limit the number of stacked calculation views.
• C.Partition large tables.
• D.Avoid aggregating data early in the data flow.