Free SAP C-HANAIMP-18 Exam Dumps Questions & Answers

Which of the following supports data replication?

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

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 Assign the conversion rule to your calculation view
• B.  Assign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column
• C.  Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Build the conversion rule
• D.  Assign semantic type Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type

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 exclude columns that are NOT requested by a query to avoid incorrect results
• C.  To retain the correct aggregation behavior in stacked views
• D.  To include columns that are NOT requested by a query but are essential for the correct result

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

• A.  A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
• B.  SELECT privileges and Analytic Privileges (Country = United States) on both views
• C.  A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
• D.  A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

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