Free SAP E-HANAAW-17 Exam Dumps Questions & Answers

What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question

• A.  Shared file systems for only one server
• B.  Active clusters for all servers
• C.  Services-Name and index server on all nodes
• D.  High availability configuration

You apply static code checks on your ABAP coding to find performance optimization potential and receive a message about a "Problematic SELECT * statement" issue. How can you improve the performance of your ABAP code?

• A.  Use the Open SQL SELECT RELEVANT statement.
• B.  Use the ABAP pragma ##OPTIMIZE_QUERY.
• C.  Use Native SQL to perform the SELECT * statement.
• D.  Use a field list containing only the relevant fields.

What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

• A.  Transfer all data from the database to the ABAP layer, and then aggregate the results.
• B.  Use native SQL to access SAP HANA built-in functions.
• C.  Perform expensive calculations on the ABAP application server.
• D.  Aggregate data on the database, and transfer the results to the ABAP layer.
• E.  Perform expensive calculations on the database.

HANA modeling views can be created under

• A.  File System
• B.  Schema
• C.  Catalog
• D.  Content

Which SQL syntax is used to create a read only procedure?

• A.  READS SQL DATA
• B.  READS PROCEDURE
• C.  NO-SIDE-EFFECT
• D.  READ-ONLY