Online Access Free C-HANAIMP-18 Exam Questions

Which are the components of SAP HANA Cloud?Note: There are 3 correct answers to this question.

• A.Native Storage Extension
• B.SAP Analytics Cloud
• C.SAP HANA in-memory database
• D.SAP Data Warehouse Cloud
• E.SAP HANA Cloud data lake

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 ensure that the aggregation always happens after the join execution
• B.To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query
• 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

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

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

What are the key steps to implement currency conversion in a calculation view?

• A.Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Build the conversion rule
• B.Assign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column
• C.Assign semantic type Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type
• D.Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Assign the conversion rule to your calculation view

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

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