E_HANAAW_16 by SAP Valid Free Exam Practice Test

Question 1

Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question

A. Sort data by characteristics B. Suggests style sets for crosstabs C. Analyze data with the design pane D. Convert crosstab cells to formula

Correct Answer: C,D

Question 2

Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question

A. Core data services views B. Calculation views C. ABAP managed database procedures D. Stored procedure

Correct Answer: A,C

Question 3

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.

A. Data base performance monitor (transaction DB50) B. Code inspector (transaction SCI) C. SQL monitor (transaction SQLM) D. SQL Trace (transaction ST05) E. ABAP test cockpit (transaction ATC)

Correct Answer: B,C,E

Question 4

Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers to this question.

A. Database table compression B. Partitioning C. Parallel processing D. Column data storage

Correct Answer: B,C

Question 5

How can you exchange SQL Monitor data between two systems?

A. Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target system. B. Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system. C. Configure a secondary database connection to the target system and query the data in the SQL Monitor. D. Create and release a transport request containing the SQL Monitor log files.

Correct Answer: B

Question 6

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

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

Correct Answer: C,D

Question 7

You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes. In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer.

A. Open the ABAP transport request Select take snapshot and Save
Activate the SAP HANA transport container B. Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container C. Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container D. Open the SAP HANA transport containerSelect take snapshot and Save
Activate the SAP HANA Transport Container

Correct Answer: D

Question 8

What is an attribute view and what are its practices? There are 3 correct answers to this question.

A. May contains flow charts B. May contain filters C. May use in calculation views D. Used in diagrammatic Projections E. Used to join tables

Correct Answer: B,C,E

Question 9

You developed an ABAP program using ABAP Development Tools for SAP NetWeaver. How can you execute it? 2 ans

A. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8. B. Use the Open Development Object dialog (CTRL+SHIFT+A) and enter <Program_Name>/Execute in the search field. C. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl. D. Call transaction SRUN_ADT and enter the name of the ABAP program. E. In the Project Explorer view, right-click the program and choose Run As - ABAP Application from the context menu.

Correct Answer: A,E

Question 10

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. Hybrid data and management system C. Support for system tables D. High Performance and Scalability

Correct Answer: B,D

Question 11

Which of the following is a limitation when you create an external view? Please choose the correct answer.

A. You must use the ABAP Development tools (ADT) TO CREATE the external view B. You must know the underlying tables and join conditions of the SAP HANA view. C. You must include the name of the SAP HANA view in the name of the external view. D. You can only use native SQL to consume the external view

Correct Answer: A

Question 12

How to create a core data services view? (3 ans)

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

Correct Answer: B,C,E

Question 13

You define a core data services (CDS) view to merge the results of queries using the UNION keyword. What must the column list of this queries contain?
There are 2 correct answers to this question.

A. Columns of compatible types B. Columns of identical types C. The same number of columns D. All key fields

Correct Answer: A,C

Question 14

Which system schema contains the information about Time data and Schema Mapping?

A. _SYS_BIC B. _SYS_XS C. _SYS_BI D. _SYS_REPO

Correct Answer: C

Question 15

What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

A. Used to access local or remote database system B. Maintain only HANA specific objects C. Maintain, Monitor and test secondary database connection D. Use Schema for the Connections

Correct Answer: A,C

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 - E_HANAAW_16 Exam Practice Test