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
You have to improve the performance of a recurring process that loads data into a productive SAP HANA system. What should you do? Please choose the correct answer.
Drop secondary indexes before loadingo Recreate the indexes after the load is finished
Drop dependent SAP HANA information modelso Re-activate the models after the load is finished
Disable redo loggingo Force the use of bulk insert method call
Disable AUTO MERGE for the target tableso Implement an application-triggered SMART MERGE
When you switch on encryption during the installation of a new SAP HANA database, which part of the database is encrypted? Please choose the correct answer.
Redo log files
Your SAP HANA system has 512GB of physical memory. You want to limit the memory that can be used by SAP HANA to 80% of the physical memory. To which of the following values do you have to set the global_allocation_limit parameter in the global.ini? Please choose the correct answer.
You want to use the Change and Transport System (CTS+) to move content from the SAP HANA development system to the SAP HANA production system. Which of the following steps do you execute in the SAP HANA studio? Please choose the correct answer.
Attach objects to a transport request
Configure the SAP HANA application type
Configure the CTS Deploy Web service
Import the ABAP transport request with SAP HANA content
A company uses SAP Landscape Transformation (SLT) to transfer data from a source system to SAP HANA. How does SAP recommend that you check for any data transfer problems within SLT on a regular basis? Please choose the correct answer.
Perform a job status check in SLT manually.
Run the health check functionality in SLT.
Run health check scripts on the SLT server at the operating system level.
Perform a data provisioning status check in SAP HANA manually.
An SAP HANA user wants to incorporate the Diminishing Balance Depreciation function in an SAP HANA data model. How can you implement this request efficiently and without incurring additional hardware or license costs? Please choose the correct answer.
Implement analytical and predictive functions in SAP HANA extended application services for use in the SAP HANA information models.
Install the R desktop version to the users’ computers to enable SAP HANA information models to be accessed via ODBC.
Install the Application Function Library (AFL) into the existing SAP HANA server and implement analytical and predictive models based on the SAP standard algorithms.
Set up an R serve installation and connect it with SAP HANA to enable R scripts to be executed as part of the SAP HANA information models.
You are designing a table partitioning strategy in a scale-out scenario. Detailed information about the data access pattern is not available. Which partitioning options would you choose? Note: There are 2 correct answers to this question.
Which of the following SQL statements is equivalent to the CE function:
out = CE_OLAP_VIEW("OLAP_view", ["DIM1", SUM("KF")]);
Please choose the correct answer.
out = select distinct dim1, SUM(kf) FROM „OLAP_view“;
out = select dim1, SUM(kf) FROM „OLAP_view“ GROUP BY dim1;
out = select dim1, SUM(kf) FROM „OLAP_view“;
out = select dim1, kf FROM „OLAP_view“;
You are doing currency conversions using input parameters in an information model. You ran the report that uses the model and selected the target currency from the pop-up list of currencies. You notice that the financial figures in the report are not correct but no error is shown. What could be the reason for this? Please choose the correct answer.
The “Measure Type“ of the currency column is not set to “Amount with Currency“.
The TCUR* currency conversion tables are in the wrong schema.
The “Enable for Conversion“ option is not selected.
The “Set Upon Conversion Failure“ option is set to “Ignore“.