Online Access Free C_HCMOD_02 Exam Questions

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 fails and the table is dropped.
• B.The deployment is successful but the data preview returns an error message.
• C.The deployment fails and the table is not dropped.
• D.The deployment is successful and the data preview returns expected data.

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.

• A.Stored procedures
• B.Table partitions
• C.Pre-calculated aggregates
• D.Indexes

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

• A.Provide reusable hierarchies for drilldown in a CUBE with star join
• B.Access hierarchies created in external schemas
• C.Enable SQL SELECT statements to access hierarchies
• D.Provide reusable hierarchies for drilldown in a CUBE without star join

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?

• A.Scalar function
• B.Procedure
• C.Table function
• D.Anonymous block

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

• A.Provide reusable hierarchies for drilldown in a CUBE with star join
• B.Access hierarchies created in external schemas
• C.Enable SQL SELECT statements to access hierarchies
• D.Provide reusable hierarchies for drilldown in a CUBE without star join