SAP Certified Development Specialist - ABAP for SAP HANA 2.0 - E_HANAAW_16 Exam Questions

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

A. Identify Elementary Search Help B. Automatic updates of all the input fields C. Process on all the input fields D. Switch on proposal search for input fields E. Check Pre-Requisites

A. To reduce main memory consumption and to improve insert performance B. It is beneficial to move data-intensive calculations into the database C. It is beneficial for maximizing your search into database D. to keep all the loads away from the DB

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

A. Create a proxy object for the defined view. B. Create a data definition in your ABAP package C. Specify the name of the SQL view in ABAP Dictionary D. Define the type mapping between ABAP and SAP HANA E. Use the DDL statement DEFINE VIEW and SQL like Syntax

A. The data-intensive calculations can be performed on SAP Netweaver Application Server ABAP when code-to-data mode is switched on B. The transfer of coding to the database reduces the memory consumption of associated ABAP Dictionary tables in the application layer C. Then in-memory architecture of SAP HANA prevents the transfer of large datasets between the database layer and the application layer D. The in-memory capabilities of SAP HANA allow calculations to be performed on the database layer, which helps to avoid unnecesary movement of data

A. Without currency/unit consideration B. All unit/ currency restricted to 10,000,00 records C. No unit/ currency split if aggregating amounts/ currency values D. Restricted to 5000 records / unit E. Restricted to 10,000 records

A. Model-ll services B. Conditional services C. Core Data Services (CDS) D. It services

A. SQLScript is faster than traditional SQL B. SQLScript code can easily be translated into modeling view C. SQLScript can be better modularized than traditional SQL

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

A. NEXT_PACKAGE B. EXECUTE_QUERY C. SET_PARAM_TABLE D. SET_PARAM