SAP SAP Certifications E_HANAAW_18 Questions & Answers

• Question 151:

  What language one should know to work in SAP HAN A?

  A. Java

  B. ABAP

  C. C#

  D. SQL

  Correct Answer: D

• Question 152:

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

  A. In the Project Explorer view, right-click the program and choose Run As -- ABAP Application from the context menu.

  B. Use the Open Development Object dialog (CTRL+SHIFT+A) and enter /Execute in the search field.

  C. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.

  D. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.

  E. Call transaction SRUN_ADT and enter the name of the ABAP program.

  Correct Answer: AC

• Question 153:

  Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

  A. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

  B. Use array variants of INSERT UPDATE MODIFY and DELETE

  C. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES

  D. Perform all calculations and aggregations in the ABAP layer

  Correct Answer: BC

• Question 154:

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

  A. Client database handling

  B. Application server

  C. DB client-server

  D. Other DB

  E. DB For ABAP

  Correct Answer: BDE

• Question 155:

  What is the full form of HANA?

  A. High-Performance Analytic Accelerator

  B. High-Performance Analytic Application

  C. High Accelerator Numeric Analytics

  D. High-Performance Analytic Appliance

  Correct Answer: D

• Question 156:

  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 157:

  Analytic Privilege can be applied to (3 Answers)

  A. Calculation views

  B. Attribute views

  C. Analytic views

  D. Table

  E. SQL View

  Correct Answer: ABC

• Question 158:

  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. Calculation views

  B. ABAP managed database procedures

  C. Stored procedure

  D. Core data services views

  Correct Answer: BD

• Question 159:

  Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question.

  A. De-pooling and de-clustering

  B. Changes of data class

  C. Definition of full-text indexes

  D. Definition of an enhancement category

  E. Storage type for tables

  Correct Answer: ACE

• Question 160:

  What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

  A. A new and advanced Open SQL

  B. Core Data services

  C. Buffer system services

  D. Advanced and specific models

  Correct Answer: AB