This app is an All-In-One package to provide everything to HANA Lovers.
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Which of the following are characteristics of an external view? Note: There are 3 correct answers to this question.
It can be used as a data type in ABAP programs.
It is an ABAP Dictionary object type.
It allows access to an SAP HANA information view with Open SQL.
It defines the underlying SAP HANA information view.
It can be used in Open SQL statements for database updates.
Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement. Which of the following changes to the SELECT statement can you use to retrieve the same data as before? Note: There are 2 correct answers to this question.
Include the client field in the WHERE condition.
Use the CLIENT SPECIFIED addition.
Include the client field in the join condition.
Include the client field in the field list.
In addition to closing the result set, what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Please choose the correct answer.
Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
Implement the interface IF_AMDP_MARKER_HDB.
Implement the ABAP AMDP_HDB Event Handler.
Set the visibility of the corresponding class method in the declaration section to PUBLIC.
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer.
Create a graph comparing the runtimes of ABAP code before and after optimization.
Combine information from static ABAP code scans with runtime data from the SQL Monitor.
Combine information from static ABAP code scans with runtime data from the SQL Trace tool.
Estimate the new total runtime of optimized code.
What are the benefits of using the SQL Monitor (transaction SQLM)? Note: There are 2 correct answers to this question.
It collects monitoring data asynchronously without additional database interaction.
It can be active in a production system with minimal performance overhead.
It displays the database execution plan for all SQL statements.
It schedules ABAP programs to monitor and log all database accesses.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver? Note: There are 2 correct answers to this question.
Form-based class builder
In which of the following situations could a row store table be more suitable than a column store table? Note: There are 2 correct answers to this question.
The table contains data that you want to aggregate.
The table contains only a small number of records.
The table contains mainly distinct values per column across rows.
The table contains text that you want to search.
Which of the following are performance recommendations when using SAP HANA? Note: There are 2 correct answers to this question.
Define indexes on the columns that are used in calculations.
Move data-intensive calculations from the database to an application server.
Avoid transferring large result sets between database and client applications.
Filter data in lower layers.
You have defined the following SQLScript procedure:
CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA
Which type of database procedures can be called in this SQLScript procedure?
Please choose the correct answer.