SAP SAP Certifications E_HANAAW_17 Questions & Answers

• Question 111:

  Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?

  There are 3 correct answers to this question.

  A. Full-text index

  B. Database procedure proxy

  C. ABAP program containing new Open SQL

  D. Core Data service (CDS) view

  E. External view

  Correct Answer: BDE

• Question 112:

  Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?

  A. The filter condition for the association

  B. The cardinality of the association

  C. The alias for the association

  D. The target entity of the association

  Correct Answer: D

• Question 113:

  You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

  A. CAST( 'USO' AS abap.cuky) AS currency_key

  B. SUM( revenue ) AS total_revenue

  C. Crtdby AS created_by

  D. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS Order_type

  E. ASSOCIATION TO sflight AS_flights

  Correct Answer: ABD

• Question 114:

  What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.

  A. Process on all the input fields

  B. Automatic updates of all the input fields

  C. Check Pre-Requisites

  D. Identify Elementary Search Help

  E. Switch on proposal search for input fields

  Correct Answer: CDE

• Question 115:

  In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program to find performance optimization potential.

  Where can you find the result of the static code checks?

  A. In the Problems view

  B. In the Project Explorer view

  C. In the Performance Analysis view

  D. In the Outline view of the ABAP Performance perspective

  Correct Answer: A

• Question 116:

  You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? (Choose Two)

  A. It has syntax check as compile time.

  B. It supports exception handling

  C. It supports locking and commit handling

  D. It supports where-used list.

  Correct Answer: BC

• Question 117:

  In order to get language-specific data, which join is used in SAP HANA?

  A. Referential Join

  B. Language join

  C. Text Join

  D. It is not possible to fetch language-specific data in HANA

  Correct Answer: C

• Question 118:

  What is Core Data Services (CDS)?

  A. A collection of services that provide information about the data volumes of the SAP HANA core tables

  B. A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system

  C. A collection of core features and services that provide data from the ABAP application server layer to the user interface

  D. A collection of domain-specific languages and services for definition and consumption of semantically rich data models

  Correct Answer: D

• Question 119:

  You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.

  A. View CA_CUSTOMER has deployment mode A.

  B. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK

  C. SYSTEM P81 has SAP HANA has primary database

  D. PACKAGE ZHA400J30 HAS deployment Mode A

  Correct Answer: BC

• Question 120:

  Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?

  A. Standard Web Dynpro checks

  B. Search for DB operations across modularization units

  C. SELECT statements that bypass the table buffer

  D. Use of the ADBC interface

  Correct Answer: D