Online Access Free C-HCMOD-02 Practice Test

What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

• A.Expected memory consumption
• B.Information about join cardinality
• C.Usage statistics of the calculation view
• D.Joins that are defined on calculated columns

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it.What do you observe in the SAP HANA database container?

• A.The deployment is successful and the data preview returns expected data.
• B.The deployment fails and the table is dropped.
• C.The deployment fails and the table is not dropped.
• D.The deployment is successful but the data preview returns an error message.

You have generated a calculation view properties file.What does it contain?

• A.All settings defined in a calculation view
• B.Dependencies between calculation views
• C.Descriptions of all objects defined in a calculation view
• D.Documentation to support the calculation view

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?

• A.Use a minus node
• B.Use a union node.
• C.Use an intersect node.
• D.Use an aggregation node.

Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.

• A.To identify the root data sources of a function
• B.To preview data at the node level of a calculation view
• C.To display the execution time of a calculation view
• D.To warn of potential performance issues related to calculated columns