SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 51:

  What do you understand by the SAP HANA Software Optimization? Please choose the correct answer.

  A. Speed up the processing within the database
  B. Bring logic to where the data is calculated first then only move to results
  C. Provide combinations of objects and partitioning
  D. Huge potential for hybrid database
  B. Bring logic to where the data is calculated first then only move to results

• Question 52:

  What is the language SAP HANA is developed in?

  A. Assembly
  B. O
  C. C++
  D. Java
  C. C++

• Question 53:

  Which SQL syntax is used to create a read only procedure?

  A. READS SQL DATA
  B. READS PROCEDURE
  C. NO-SIDE-EFFECT
  D. READ-ONLY
  A. READS SQL DATA

• Question 54:

  You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers to this question.

  A. Use the UP TO n ROWS addition
  B. Use the tilde symbol (-) to separate qualifier from column name
  C. Use a Comma-separated column list
  D. Specify the database schema if it is not the user's default schema
  E. Explicitly handle the client field
  C. Use a Comma-separated column list
  D. Specify the database schema if it is not the user's default schema
  E. Explicitly handle the client field

• Question 55:

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

  What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

  A. Use native SQL to access SAP HANA built-in functions.
  B. Perform expensive calculations on the database.
  C. Aggregate data on the database, and transfer the results to the ABAP layer.
  D. Perform expensive calculations on the ABAP application server.
  E. Transfer all data from the database to the ABAP layer, and then aggregate the results.
  A. Use native SQL to access SAP HANA built-in functions.
  B. Perform expensive calculations on the database.
  C. Aggregate data on the database, and transfer the results to the ABAP layer.

• Question 57:

  Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.

  A. Data base performance monitor (transaction DB50)
  B. Code inspector (transaction SCI)
  C. SQL Trace (transaction ST05)
  D. SQL monitor (transaction SQLM)
  E. ABAP test cockpit (transaction ATC)
  B. Code inspector (transaction SCI)
  D. SQL monitor (transaction SQLM)
  E. ABAP test cockpit (transaction ATC)

• Question 58:

  What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

  A. All arithmetic expressions can be used for all type of variables
  B. All ABAP variables must be escaped with a proceeding @ sign.
  C. All Keywords are case sensitive.
  D. All fields in the GROUP BY clause must be separated by commas.
  B. All ABAP variables must be escaped with a proceeding @ sign.
  D. All fields in the GROUP BY clause must be separated by commas.

• Question 59:

  What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 answers)

  A. Changes to Delta Container
  B. You need to refresh the content of the container manually
  C. Automatic release of units
  D. Take snapshot manually before releasing of the container
  B. You need to refresh the content of the container manually
  D. Take snapshot manually before releasing of the container

• Question 60:

  What are the ABAP development guidelines? There are 2 correct answers to this question.

  A. Consuming Only ABAP contents for SAP HANA
  B. Improved tools for performance analysis
  C. Improved hybrid components for SAP HANA
  D. Extensions to ABAP Language
  B. Improved tools for performance analysis
  D. Extensions to ABAP Language