SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 131:

  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
  C. Text Join

• Question 132:

  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
  D. Use of the ADBC interface

• Question 133:

  Which of the following is not an element of Analytical view? Please choose the correct answer.

  A. Currency conversion is not applicable
  B. Join fact tables
  C. Read Data from the joined database tables
  D. Used to Joined table
  A. Currency conversion is not applicable

• Question 134:

  You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.

  How can you address the calculation view?

  Note; There are 2 correct answers to this questions.

  A. "ha400.primdb/CA_BOOKINGS_COUNT"
  B. _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT"
  C. "ha400.primdb::CA_BOOKINGS_COUNT"
  D. _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT"
  C. "ha400.primdb::CA_BOOKINGS_COUNT"
  D. _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT"

• Question 135:

  In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

  A. Code completion option
  B. Statement Template options
  C. Editor shortcut options
  D. Code formatting option
  D. Code formatting option

• Question 136:

  Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.

  A. CDS View
  B. Database procedure
  C. External view
  D. Database Table
  E. Internal table
  A. CDS View
  C. External view
  D. Database Table

• Question 137:

  You have created a CDS view as follows: define view zha400 as select from spfli association (*) to sflight as_flights On spfli.carrid =_flights.carrid and spfli.connid=_flights.connid { ... } Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?

  A. carrid and _flights.planetype
  B. _ flights.carrid and planetype
  C. carrid and planetype
  D. flights.carrid and _flight.s .planetype
  A. carrid and _flights.planetype

• Question 138:

  You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.

  Which additional steps are necessary to retrieve the result set into an internal table? 2 answers

  A. Close the CL_SQL_STATEMENT object to release the resources.
  B. Use an Open SQL query that uses the JOIN between the result set and the internal table as a data source.
  C. Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.
  D. Fetch the result using the next_package method of class CL_SQL_RESULT_SET.
  E. Fetch the result using the fetch method of class CL_SQL_EXECUTE.
  C. Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.
  D. Fetch the result using the next_package method of class CL_SQL_RESULT_SET.

• Question 139:

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

• Question 140:

  What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?

  A. The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie
  B. The CDS views used in the FROM clause
  C. The entire CDS view
  D. The elements in the projection list of the CDS view
  C. The entire CDS view