SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 1:

  You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?

  A. Code completion options
  B. Code formatting options
  C. Statement template options
  D. Editor shortcut key options
  B. Code formatting options

• Question 2:

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

  Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)?

  There are 3 correct answers to this question.

  A. Returning
  B. Receiving
  C. Exporting
  D. Changing
  E. Importing
  C. Exporting
  D. Changing
  E. Importing

• Question 4:

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

  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. Access to ERP tables must be restricted
  C. Editing of SAP HANA data models should only be possible for "Users" of the model
  D. Database administration should be restricted to skilled
  B. Access to ERP tables must be restricted
  D. Database administration should be restricted to skilled

• Question 6:

  What are the features of New Open SQL? There are 2 correct answers to this question.

  A. Supports arithmetic and string expressions
  B. Supports Code adjustment model
  C. Supports specific units of database
  D. Supports conditional expressions
  A. Supports arithmetic and string expressions
  D. Supports conditional expressions

• Question 7:

  You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

  A. :it_books
  B. it_books
  C. {it.books}
  D. @it_books
  A. :it_books

• Question 8:

  What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

  A. Use Schema for the Connections
  B. Maintain, Monitor and test secondary database connection
  C. Maintain only HANA specific objects
  D. Used to access local or remote database system
  B. Maintain, Monitor and test secondary database connection
  D. Used to access local or remote database system

• Question 9:

  AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question.

  A. UNION specific syntax errors
  B. Database platform syntax errors
  C. Database independent syntax errors
  D. HANA specific syntax errors
  E. SQLScript errors
  C. Database independent syntax errors
  D. HANA specific syntax errors
  E. SQLScript errors

• Question 10:

  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"