E HANAAW 17 SAP Certified Development Specialist ABAP for
SAP HANA 2 0 Practice Exam
**Question 1.** Which SAP HANA characteristic most directly enables the
“Code‑to‑Data” programming paradigm?
A) Row‑store tables
B) In‑memory columnar storage
C) Disk‑based OLAP cubes
D) Traditional client‑server architecture
Answer: B
Explanation: Columnar in‑memory storage allows massive parallel processing and
pushes computation to the database, which is the essence of Code‑to‑Data.
**Question 2.** In Open SQL for SAP HANA, which statement is used to combine
result sets of two SELECT queries while removing duplicates?
A) UNION ALL
B) INTERSECT
C) UNION
D) EXCEPT
Answer: C
Explanation: UNION returns distinct rows from both queries, whereas UNION ALL
keeps duplicates.
**Question 3.** Which of the following Open SQL features is NOT supported on
SAP HANA?
,E HANAAW 17 SAP Certified Development Specialist ABAP for
SAP HANA 2 0 Practice Exam
A) Table expressions with inline declarations
B) SELECT … FOR ALL ENTRIES
C) GROUP BY ROLLUP
D) UPDATE … FROM …
Answer: D
Explanation: UPDATE … FROM … is a native SQL construct not available in Open
SQL; HANA‑specific updates must use SET or native SQL.
**Question 4.** When migrating custom ABAP code to HANA, the ABAP Test
Cockpit (ATC) primarily helps to:
A) Generate AMDP classes automatically
B) Identify database‑specific syntax violations
C) Convert ABAP reports to Web Dynpro
D) Transport objects to the production system
Answer: B
Explanation: ATC runs checks that flag HANA‑incompatible statements such as
SELECT * without a key field.
**Question 5.** Which ABAP internal table operation introduced in recent
releases is most suitable for aggregating values in a functional style?
A) LOOP AT … ENDLOOP
B) READ TABLE … BINARY SEARCH
,E HANAAW 17 SAP Certified Development Specialist ABAP for
SAP HANA 2 0 Practice Exam
C) REDUCE … ENDREDUCE
D) MODIFY TABLE … INDEX …
Answer: C
Explanation: REDUCE allows inline aggregation without explicit loops, improving
readability and performance on HANA.
**Question 6.** In the context of SAP HANA, what does the term “push‑down”
refer to?
A) Sending ABAP source code to the client browser
B) Executing data‑intensive logic directly in the database layer
C) Compressing data before transport to the application server
D) Moving UI logic into SAP Fiori
Answer: B
Explanation: Push‑down means moving calculations to the database so that data
does not travel back and forth.
**Question 7.** Which annotation in a CDS view enables OData exposure
automatically?
A) @AbapCatalog.sqlViewName
B) @OData.publish:true
C) @UI.lineItem
D) @Analytics.query
, E HANAAW 17 SAP Certified Development Specialist ABAP for
SAP HANA 2 0 Practice Exam
Answer: B
Explanation: @OData.publish:true tells the framework to generate an OData
service for the CDS view.
**Question 8.** Which of the following is a valid way to call an AMDP method
from ABAP?
A) CALL METHOD <amdp_class>=>method_name( ).
B) EXEC SQL … ENDEXEC.
C) PERFORM <amdp_method>.
D) SELECT * FROM <amdp_class>.
Answer: A
Explanation: AMDP methods are static; they are called with the class name and
method name using CALL METHOD syntax.
**Question 9.** What is the primary purpose of an External View in the ABAP
Dictionary?
A) To store UI annotations for Fiori
B) To expose a HANA Calculation View as an ABAP table
C) To replace standard database tables in SAP ECC
D) To define a transportable SAPscript form
Answer: B
SAP HANA 2 0 Practice Exam
**Question 1.** Which SAP HANA characteristic most directly enables the
“Code‑to‑Data” programming paradigm?
A) Row‑store tables
B) In‑memory columnar storage
C) Disk‑based OLAP cubes
D) Traditional client‑server architecture
Answer: B
Explanation: Columnar in‑memory storage allows massive parallel processing and
pushes computation to the database, which is the essence of Code‑to‑Data.
**Question 2.** In Open SQL for SAP HANA, which statement is used to combine
result sets of two SELECT queries while removing duplicates?
A) UNION ALL
B) INTERSECT
C) UNION
D) EXCEPT
Answer: C
Explanation: UNION returns distinct rows from both queries, whereas UNION ALL
keeps duplicates.
**Question 3.** Which of the following Open SQL features is NOT supported on
SAP HANA?
,E HANAAW 17 SAP Certified Development Specialist ABAP for
SAP HANA 2 0 Practice Exam
A) Table expressions with inline declarations
B) SELECT … FOR ALL ENTRIES
C) GROUP BY ROLLUP
D) UPDATE … FROM …
Answer: D
Explanation: UPDATE … FROM … is a native SQL construct not available in Open
SQL; HANA‑specific updates must use SET or native SQL.
**Question 4.** When migrating custom ABAP code to HANA, the ABAP Test
Cockpit (ATC) primarily helps to:
A) Generate AMDP classes automatically
B) Identify database‑specific syntax violations
C) Convert ABAP reports to Web Dynpro
D) Transport objects to the production system
Answer: B
Explanation: ATC runs checks that flag HANA‑incompatible statements such as
SELECT * without a key field.
**Question 5.** Which ABAP internal table operation introduced in recent
releases is most suitable for aggregating values in a functional style?
A) LOOP AT … ENDLOOP
B) READ TABLE … BINARY SEARCH
,E HANAAW 17 SAP Certified Development Specialist ABAP for
SAP HANA 2 0 Practice Exam
C) REDUCE … ENDREDUCE
D) MODIFY TABLE … INDEX …
Answer: C
Explanation: REDUCE allows inline aggregation without explicit loops, improving
readability and performance on HANA.
**Question 6.** In the context of SAP HANA, what does the term “push‑down”
refer to?
A) Sending ABAP source code to the client browser
B) Executing data‑intensive logic directly in the database layer
C) Compressing data before transport to the application server
D) Moving UI logic into SAP Fiori
Answer: B
Explanation: Push‑down means moving calculations to the database so that data
does not travel back and forth.
**Question 7.** Which annotation in a CDS view enables OData exposure
automatically?
A) @AbapCatalog.sqlViewName
B) @OData.publish:true
C) @UI.lineItem
D) @Analytics.query
, E HANAAW 17 SAP Certified Development Specialist ABAP for
SAP HANA 2 0 Practice Exam
Answer: B
Explanation: @OData.publish:true tells the framework to generate an OData
service for the CDS view.
**Question 8.** Which of the following is a valid way to call an AMDP method
from ABAP?
A) CALL METHOD <amdp_class>=>method_name( ).
B) EXEC SQL … ENDEXEC.
C) PERFORM <amdp_method>.
D) SELECT * FROM <amdp_class>.
Answer: A
Explanation: AMDP methods are static; they are called with the class name and
method name using CALL METHOD syntax.
**Question 9.** What is the primary purpose of an External View in the ABAP
Dictionary?
A) To store UI annotations for Fiori
B) To expose a HANA Calculation View as an ABAP table
C) To replace standard database tables in SAP ECC
D) To define a transportable SAPscript form
Answer: B
