SAP E_HANAAW_17 Exam Dumps

SAP E_HANAAW_17 Sample Question Answers

Question # 1

In order to get language-specific data, which join is used in SAP HANA?

A. Referential Join
B. Language join
C. Text Join
D. It is not possible to fetch language-specific data in HANA

Show Answer

Question # 2

User STUDENT_A creates and activates a design-time Object. In which schema is the runtime object generated?

A. SYS_BI
B. SYSTEM
C. _SYS_BIC
D. STUDENT_A

Show Answer

Question # 3

SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANAhas to meet. What are these goals? There are 2 correct answers to this question.

A. Analytical DBMS features
B. Support for system tables
C. High Performance and Scalability
D. Hybrid data and management system

Show Answer

Question # 4

Which statement is true for SAP HANA? 

A. SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners 
B. SAP provides both hardware and software for SAP HANA.  

Show Answer

Question # 5

What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question. 

A. Calculate aggregations using ABAP code on the application server to limit database load 
B. Eliminate nested SELECT statements to reduce the overall number of database accesses 
C. Use a column list in the SELECT clause to ensure that you only read a column if it is really required 
D. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required

Show Answer

Question # 6

What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question.

A. It collects monitoring data asynchronously without additional database interaction.
B. It schedules ABAP programs to monitor and log all database accesses.
C. It displays the database execution plan for all SQL statements.
D. It can be active in a production system with minimal performance overhead.

Show Answer

Question # 7

Which of the following is not an element of Analytical view? Please choose the correct answer. 

A. Currency conversion is not applicable
B. Join fact tables
C. Read Data from the joined database tables
D. Used to Joined table

Show Answer

Question # 8

What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 right answers)

A. Changes to Delta Container
B. You need to refresh the content of the container manually
C. Automatic release of units
D. Take snapshot manually before releasing of the container

Show Answer

Question # 9

In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer.

A. Include all fields used in the ON condition in projection list
B. Specify an alias for the target entity
C. Define the cardinality for the target entity
D. Specify the other views in which the association can be used

Show Answer

Question # 10

What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)

A. It provides access to all ABAP repository objects in an ABAP system.
B. It represents the connection to an ABAP system
C. It represents the connection to the SAP HANA server
D. It is used to transport ABAP repository objects 

Show Answer

Question # 11

Which of the following can be part of an analytic view? (3 answers)

A. Query transformation
B. Logical joins
C. Attributes
D. Data foundation
E. Unions

Show Answer

Question # 12

In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program to find performance optimization potential.Where can you find the result of the static code checks?

A. In the Problems view
B. In the Project Explorer view
C. In the Performance Analysis view
D. In the Outline view of the ABAP Performance perspective

Show Answer

Question # 13

You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.

A. Replace UP TO n ROWS additions
B. Specify the schema for every table
C. Replace ORDER BY additions
D. Replace CORRESPONDING FIELDS additions
E. Add explicit client handling 

Show Answer

Question # 14

Which of the following is true? (2 correct answers)

A. A read only procedure cannot call read-write procedure.
B. A Read-write procedure cannot call another read-write procedure.
C. A read-write procedure can call both read-write and read only procedures.

Show Answer

Question # 15

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

A. All arithmetic expressions can be used for all type of variables
B. All ABAP variables must be escaped with a proceeding @ sign.
C. All Keywords are case sensitive.
D. All fields in the GROUP BY clause must be separated by commas.

Show Answer

Question # 16

In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value. What information has to be provided in the GROUP BY list?

A. The CASE statement as provided in the SELECT list without its alia
B. The alias of the CASE construct used in the SELECT list
C. None; the GROUP BY list is added automatically
D. The name of the gross amount column that is used in the CASE statement

Show Answer

Question # 17

According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?

A. Perform regular performance scans on your ABAP custom coding as part of the development process
B. Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process. 
C. Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.
D. Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion. 

Show Answer