Free SAP C_HANAIMP_14 Exam Dumps Questions & Answers

What can be used to return multiple result sets?
There are 2 correct answers to this question.
Response:

• A.  Table function
• B.  Procedure
• C.  Scalar function
• D.  View

What do you create to find the number of unique items sold per shop?
Please choose the correct answer.
Response:

• A.  A calculation view with a restricted column in an aggregation node
• B.  A calculation view with a counter in an aggregation node
• C.  A calculation view with a counter in a projection node
• D.  An analytic view with a calculated column in an star join node

You want to build a hierarchy on a time-based data structure. What type of hierarchy do you use?
Please choose the correct answer.
Response:

• A.  Unbalanced hierarchy
• B.  Parent-child hierarchy
• C.  Ragged hierarchy
• D.  Level hierarchy

You created a calculated column in an analytic view for a table containing the number of units ordered, the price per unit, and the number of units in stock.
You get the wrong results in your results. What could be the problem?
Please choose the correct answer.

• A.  You chose the SQL expression syntax
• B.  You did NOT enable calculate before aggregation
• C.  You mistyped the calculated column expression
• D.  You did NOT enable the currency conversion

You created a procedure without defining the security option. Which user's authorizations are checked when the procedure is executed in production?
Please choose the correct answer.
Response:

• A.  The system administrator that transported the procedure
• B.  The _SYS_REPO user
• C.  The developer that created the procedure
• D.  The user calling the function