Free SAP C_HCMOD_02 Exam Dumps Questions & Answers

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.

What could be the problem?Note: There are 2 correct answers to this question.

• A.The Country column is requested.
• B.Integrity constraint is set to RIGHT.
• C.The Keep flag is activated for the Customer column.
• D.Join cardinality is set :1.

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

• A.Text join
• B.Left outer join
• C.Referential join
• D.Inner join

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.

• A.The hierarchy must be exposed by a calculation view of type CUBE with star join.
• B.The hierarchy must be a local hierarchy.
• C.The hierarchy must be a parent-child hierarchy.
• D.The hierarchy must be a shared hierarchy.

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.Indexes
• B.Stored procedures
• C.Table partitions
• D.Pre-calculated aggregates

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.

• A.To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query
• B.To ensure that the aggregation always happens after the join execution
• C.To allow data analysis at different levels of granularity with the same calculation view
• D.To ensure that the join execution only uses the join columns requested in the query