SAP Certified Development Specialist - ABAP for SAP HANA (Edition 2016) - E-HANAAW-12 Exam Practice Test

A. Keep the result set large B. Reduce the Database Load C. Minimize the Number of Database Accesses D. Minimize the Amount of Data Transferred

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

A. The supported file types for upload are: .cssv, .xlls, and .xlsxxx B. When loading new data in the table, it gets appended to the existing data C. The new table always has a 2:2 mapping between the file and table columns D. The application suggests the column name and data type for the new tables, and it is possible to edit them

A. Use the ABAP Development Tools for SAP NetWeaver. B. Use SQL capabilities for Netweaver C. Use additional annotations - marked with the @ sign D. Use DDL statement DEFINE VIEW and SQL-like syntax to define the view E. Use data services tools for updates

A. Only retrieve the database data which is to be displayed on screen B. The ALV Optimization for SAP HANA to display data on the screen C. Data described declaratively instead of passing big internal tables D. To ensure that the user chooses the data on the selection screen is displayed

A. The table contains text that you want to search. B. The table contains mainly distinct values per column across rows. C. The table contains data that you want to aggregate. D. The table contains only a small number of records.

A. Avoid single network B. Avoid idling CPU cores C. Avoid CPU cache misses D. Avoid optimizing data

A. Some codes impacted positively and should be priorities B. Classical performances recommendations for open SQL remain valid C. Some codes transferred to other systems D. Some codes immediately run faster E. Some shifts in priorities, examples, nested selects(higher) indices(lower)

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

A. Transfer all data from the database to the ABAP layer, and then aggregate the results. B. Perform expensive calculations on the ABAP application server. C. Aggregate data on the database, and transfer the results to the ABAP layer. D. Perform expensive calculations on the database.