Online Access Free E_HANAAW_12 Practice Test

What are the steps that supported several tools, which in total result in a Guided Performance Optimization?
There are 2 correct answers to this question.

• A.Tools analyzing performance at run-time, to determine if critical constructs
• B.A new tool called SQL Monitor to determine the priority if different programs access the database intensively
• C.A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.
• D.The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption

In which of the following situations could a row store table be more suitable than a column store table?
There are 2 correct answers to this question.

• A.The table contains text that you want to search.
• B.The table contains only a small number of records.
• C.The table contains mainly distinct values per column across rows.
• D.The table contains data that you want to aggregate.

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.Identify Elementary Search Help
• B.Process on all the input fields
• C.Check Pre-Requisites
• D.Automatic updates of all the input fields
• E.Switch on proposal search for input fields

What is the central goal of using SAP HANA?
Please choose the correct answer.

• A.To set Priorities for system
• B.Positive Impact on Business
• C.Monitor database for record keeping
• D.Accelerate Performance

Which of the following are performance recommendations when using SAP HANA?
There are 2 correct answers to this question.

• A.Avoid transferring large result sets between database and client applications.
• B.Define indexes on the columns that are used in calculations.
• C.Filter data in lower layers.
• D.Move data-intensive calculations from the database to an application server.