SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 91:

  What you must do when you define and implement an ABAP Managed Database Procedure AMDP? There are 3 correct answers to this question.

  A. Define all the method parameters to pass by value
  B. List all the ABAP dictionary tables used in the procedure body in the USING clause
  C. Use Scalar types for all the AMDP method parameters
  D. Specify the database system and language
  E. Mark the AMDP method as read-only
  A. Define all the method parameters to pass by value
  B. List all the ABAP dictionary tables used in the procedure body in the USING clause
  D. Specify the database system and language

• Question 92:

  Which conditional expressions can be used in Core Data Services (CDS) views? 2 answers

  A. CASE statements in the projection list
  B. IF statements in the projection list
  C. WHILE statements in the WHERE clause
  D. COALESCE functions in the projection list
  E. CASE statements in the HAVING clause
  A. CASE statements in the projection list
  D. COALESCE functions in the projection list

• Question 93:

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

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

• Question 94:

  Which of the following JOIN types are supported in Open SQL? 3 answers

  A. CROSS JOIN
  B. INNER JOIN
  C. REFERENTIAL JOIN
  D. LEFT OUTER JOIN
  E. RIGHT OUTER JOIN
  B. INNER JOIN
  D. LEFT OUTER JOIN
  E. RIGHT OUTER JOIN

• Question 95:

  Which recent software innovations are applied in SAP HANA? 3 answers

  A. Columnar data storage
  B. Automated de-installation at system shutdown
  C. Improved data compression algorithms
  D. Insert Only approach
  E. Random Undefined Multi-Memory Swapping (RUMMS)
  A. Columnar data storage
  C. Improved data compression algorithms
  D. Insert Only approach

• Question 96:

  You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statement check. What does this check report? Please choose the correct answer.

  A. SELECT * statements where fewer than a specified percentage of all fields are effectively used
  B. SELECT * statements on tables with more than a specified number of fields
  C. SELECT * statements on tables with more than 100,000 records
  D. SELECT * statements on tables with the Column Store storage type
  A. SELECT * statements where fewer than a specified percentage of all fields are effectively used

• Question 97:

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

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

• Question 98:

  The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.

  A. Avoid idiling CPU cores
  B. Avoid CPU cache misses
  C. Avoid optimizing data
  D. Avoid single network
  A. Avoid idiling CPU cores
  B. Avoid CPU cache misses

• Question 99:

  When are referential joins executed in analytical views? Choose the correct answer

  A. When all the tables are optimized
  B. When fields are selected
  C. When fields are optimized
  D. When fields from both the tables are requested
  D. When fields from both the tables are requested

• Question 100:

  Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?

  A. "Map to Data source"
  B. "Consume CDS view"
  C. "Relate to Business Entity"
  D. "Read from DDL source"
  A. "Map to Data source"