Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. SAP
  5. E_HANAAW_16

SAP E_HANAAW_16 Exam
SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (Page 11 )

Updated On: 12-Jan-2026
Page 8 of 40
PDF with 195 Questions

Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.

  1. Data base performance monitor (transaction DB50)
  2. Code inspector (transaction SCI)
  3. SQL Trace (transaction ST05)
  4. SQL monitor (transaction SQLM)
  5. ABAP test cockpit (transaction ATC)

Answer(s): B,D,E



In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? There are 2 correct answers to this question.

  1. Create an input parameter for the ADDRESS field
  2. Exclude the ADDRESS field from the union
  3. Create a restricted column for the ADDRESS field
  4. Map the ADDRESS field to a constant value

Answer(s): B,D



How will you hide the attributes that are not required for client consumption? Choose the correct answer

  1. By setting the hidden property flag of the attribute in the View
  2. By setting the hidden property flag of the attribute provider
  3. By setting the hidden property flag of the attribute column
  4. By setting the hidden property flag of the attribute in the Semantics screen

Answer(s): D



You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call? Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

  1. SET_PARAM_TABLE
  2. SET_PARAM
  3. EXECUTE_QUERY
  4. NEXT_PACKAGE

Answer(s): D



When would you use a column store table instead of a row store table? There are 2 correct answers to this question.

  1. When you require aggregation and analysis of values
  2. When the table has a small number of records
  3. When there are mainly distinct values in the table
  4. When you want to enable a full-text-search of the table

Answer(s): A,D



Viewing page 11 of 40
Viewing questions 51 - 55 out of 195 questions



Post your Comments and Discuss SAP E_HANAAW_16 exam prep with other Community members:

Join the E_HANAAW_16 Discussion