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

You are querying a calculation view based on the union node, as shown in the graphic. When would the value of the Empty Union Behavior property take effect?
Note: There are 2 correct answers to this question.

• A.  When the query requests PRODUCT_GROUP
• B.  When the query requests PRODUCT_GROUP and PRODUCT_ID
• C.  When the query requests only the PRODUCT_ID
• D.  When Source A has no records

Why do you create a multi store table?

• A.  To evenly distribute the data across all available server nodes
• B.  To have the opt on to partition the table across different storage tiers
• C.  To improve read performance when accessed by simultaneous applications
• D.  To have a table that combines the characteristics of row and column stores

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.  A
• C.  C
• D.  D

In a calculation view, where can you insert SQL code?
Note: There are 3 correct answers to this question.

• A.  Filter expression
• B.  Hierarchy
• C.  Currency conversion
• D.  Calculated column expression
• E.  Input parameter

Why do you build a calculation view of type SQL Access only?

• A.  To enable SQL access to your hierarchies
• B.  To provide a data source that can only be consumed by a function or procedure
• C.  To provide a data source that is only consumed by other calculation views
• D.  To provide a high-performance model when only attributes are required