Free SAP C-HCMOD-02 Exam Dumps Questions & Answers

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

• A.  Column engine language is not supported.
• B.  Incorrect aggregations may be generated
• C.  To benefit from additional SQL optimizations
• D.  To define limits for query unfolding

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 an aggregation node.
• C.  Use an intersect node.
• D.  Use a union node.

You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?

• A.  Joins
• B.  Filters
• C.  Calculated columns
• D.  Data sources of unions

Why would you use the Transparent Filter property in a calculation view?

• A.  To avoid columns being unnecessarily used in an aggregation
• B.  To apply filters that are hidden from the end user
• C.  To allow filter push-down in stacked calculation views
• D.  To include columns that are NOT requested by a query

Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?

• A.  They introduce potential security risks.
• B.  They could modify the database.
• C.  They call multiple processing engines.
• D.  They can limit parallelization of query execution.