E-HANAAW-16 by SAP Valid Free Exam Practice Test

Question 1

Why is a security concept in SAP HANA required? There are 2 correct answers to this question

A. Need to have selected users in SAP HANA for Information Management B. Editing of SAP HANA data models should only be possible for "Users" of the model C. Access to ERP tables must be restricted D. Database administration should be restricted to skilled

Correct Answer: C,D

Question 2

What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

A. Other DB B. Application server C. DB For ABAP D. Client database handling E. DB client-server

Correct Answer: A,B,C

Question 3

What are the two layers of ABAP system interacts with its database? There are 2 correct answers to this question.

A. The Database specific library B. The Database independent interface C. The Data Storage interface D. The Client database interface

Correct Answer: A,B

Question 4

HANA modeling views can be created under

A. Content B. Schema C. Catalog D. File System

Correct Answer: A

Question 5

What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? There are 3 correct answers to this question.

A. Administer B. Configure C. Selecting D. Organizing E. Monitor

Correct Answer: A,B,E

Question 6

What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question.

A. Locate database performance issues B. Detect redundant or identical select statements C. Applying Code inspector D. Display record of all database access E. Locate work base issues

Correct Answer: A,B,D

Question 7

You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings table? Why do you create a row store instead of a column store Please choose the correct answer.

A. To limit the need of indexes B. To limit the data footprint C. To limit the unpacking and reconstruction of rows D. To allow creation of a full-text index

Correct Answer: D

Question 8

Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

A. Data Evaluation Language(DEL) B. The Data Control Language (DCL) C. Data Manipulation Language (DML) D. The Data Definition Language (DDL) E. Data Transferring Language(DTL)

Correct Answer: B,C,D

Question 9

You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer.

A. Create a debug configuration for the ABAP application and run the program B. Choose the debug as option in the context menu of the ABAP program C. Set a breakpoint in the ABAP program and execute the program D. Choose the Run --> Debug options in the menu

Correct Answer: C

Question 10

The SAP HANA database is a hybrid in-memory database that combines Few technologies within.
What are these technologies?
There are 3 correct answers to this question

A. Column-based database technology B. Value-based database technology C. Object-based database technology D. Row-based database technology E. Time-based database technology

Correct Answer: B,C,D

Question 11

Which of the statement is true for SAP HANA?

A. SAP HANA also uses disc memory to keep backup. In case of power failure the database can be re-stored to the last consistent state. B. In SAP HANA all the data resides in RAM. Hence in case of power failure all the data will be lost.

Correct Answer: A

Question 12

Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

A. Service Adaptation Description Language (SADL) B. Process Agent Framework (PAF) C. ABAP Messaging Channels (AMC) D. ABAP Managed Database Procedures (AMDP)

Correct Answer: D

Question 13

You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation?

A. ABAP Development Tools for SAP NetWeaver B. SAP HANA Tools C. All plug-ins provided by SAP Development Tools for Eclipse D. None; everything is preconfigured

Correct Answer: D

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 - E-HANAAW-16 Exam Practice Test