Online Access Free C_HANAIMP_16 Exam Questions

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

• A.They introduce potential security risk.
• B.They call multiple processing engines
• C.They can harm SQL optimization.
• D.NOT all reporting tools can consume the results.

Which of the following results are generated when you query this temporal hierarchy using a time-validity period interval of March to May?

• A.B
• B.C
• C.D
• D.A

When would you develop an SQL procedure instead of a function?

• A.You need to implement Data Definition Language (DDL) statements.
• B.You want to create a dynamic analytic privilege.
• C.The code should modify data in the table.
• D.You need to use conditional logic.
• E.Optimal performance is apriority.

Why might you use the Keep Flag property in an aggregation node?

• A.To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
• B.To retain the correct aggregation behavior in stacked views.
• C.To include columns that are NOT requested by a query but are essential for the correct result
• D.To cache the results of the aggregation node for drill-down

Which of the following allows data replication?

• A.SAP HANA smart data quality
• B.SAP HANA smart data access
• C.SAP HANA streaming analytics
• D.SAP HANA smart data integration