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

Which of the following must you avoid to ensure your calculation view uses only the calculation engine? (Choose three)

• A.  Reading from tables using SELECT statements
• B.  Reading from tables in the column store
• C.  Joins using SQL
• D.  DO WHILE loops
• E.  Combining SQL and CE Functions

You create a business layer in the SAP BusinessObjects Information Design Tool (IDT).
Which of the following could you add to the data foundation? (Choose two)

• A.  Column Tables
• B.  Information Models
• C.  Synonyms
• D.  Packages

Which best practices should you apply when you use SQL script in SAP HANA? (Choose three)

• A.  Use cursors.
• B.  Use the WHERE clause for updates.
• C.  Use UNION ALL instead of UNION.
• D.  Use dynamic SQL with variables.
• E.  Use CE functions.

For what purpose do you use SQL Script in SAP HAN? (Choose two)

• A.  To transfer a large amount of data between engines
• B.  To create database procedures
• C.  To achieve very high performance on SELECT statements
• D.  To shift complex calculations and logic to the client side
• E.  To combine two analytic views

Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface? (Choose two)

• A.  Analytic Privilege
• B.  Aggregation
• C.  Join
• D.  Data Foundation