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

What SQL construct do you use to return multiple result sets from a single SQL statement?
There are 2 correct answers to this question.
Response:

• A.  SELECT subquery
• B.  UNION
• C.  JOIN
• D.  GROUPING SETS

For what SQL keyword is the aggregation node the equivalent?
Please choose the correct answer.
Response:

• A.  DISTINCT
• B.  GROUP BY
• C.  UNIQUE
• D.  ORDER BY

Which modeling views are fading out and are not available in the SAP HANA web-based development workbench?
There are 2 correct answers to this question.
Response:

• A.  Graphical calculation views
• B.  Scripted calculation views
• C.  Analytic views
• D.  Attribute views

What information can you find in the Visualize Plan tool?
There are 2 correct answers to this question.
Response:

• A.  The execution engines used
• B.  The time taken for each step
• C.  The number of records returned in each step
• D.  The SQL Plan Cache

Which tables do you need for currency conversion?
Please choose the correct answer.
Response:

• A.  TCUR*
• B.  BICS*
• C.  SHINE*
• D.  DD07*