Top SAP HANA Interview Questions (2024)

1. What is SAP HANA?

2. What is difference between SAP ECC and SAP HANA?

3. What are the different types of SAP HANA database tables?

4. What are the benefits of using SAP HANA?

5. What is SAP HANA Information composer?

6. Which are the main system components of SAP HANA?

7. What is SAP HANA SQL Expression?

8. What are different types of SAP HANA SQL expressions?

9. What is SAP HANA SQL Data Profiling?

10. What is persistent layer in SAP HANA?

11. How many types of replication are there in SAP HANA?

12. What is Delta Shipping in SAP HANA?

13. How to check SAP HANA replication logs?

14. What is SAP HANA sizing?

15. What is AMDP in SAP HANA?

16. What is the use of CDS views in SAP HANA?

17. What is the difference between CDS and AMDP in SAP HANA?

18. Why do we use calculation view in SAP HANA?

19. What is transparent filter in SAP HANA?

Q: What is SAP HANA?
Ans:

A multi-model database called SAP HANA (High-performance ANalytic Appliance) keeps data in memory rather than on a disk. Because of this, data processing is quicker than with disk-based data systems, enabling advanced real-time analytics.

Q: What is difference between SAP ECC and SAP HANA?
Ans:

The key distinction between SAP ERP Central Component (SAP ECC) and SAP HANA is that ECC is the basic ERP product inside the SAP Business Suite, while HANA is an in-memory database support cloud or on-prem deployment, also can manage transactions and analytics on a single system.

Q: What are the different types of SAP HANA database tables?
Ans:

The core of the SAP in-memory technology is the SAP HANA Database.In SAP HANA, there are two types of database tables.

1. Row Store
2. Column Store

Q: What are the benefits of using SAP HANA?
Ans:

The following are some of the benefits of using SAP HANA.

1. Real-Time data processing, reporting, and replication capabilities are supported by SAP HANA.
2. SAP HANA supports cloud environments for application deployment.
3. SAP HANA is easy to use for tasks like ETL and indexing.
4. In-memory database make data processing faster.

Q: What is SAP HANA Information composer?
Ans:

Users can analyze data sets using SAP HANA Information Composer, a self-service modelling environment. It helps to create Modeling views for analysis and import data from workbook formats (.xls,.csv) into the HANA database.

Q: Which are the main system components of SAP HANA?
Ans:

The host, system, and instance are the three primary parts of a SAP HANA system.

1. An operating system known as a host is used to run the SAP HANA database.
2. On a host, the smallest operational component is a SAP HANA instance (HDB). It is the collection of SAP HANA system components that have been put up on a single host.
3. One or more instances with the same number make up a system. If a system has multiple instances, they should be distributed out across different hosts, creating a multiple-host system. Each system has its own distinct SAP system ID (SID).

Q: What is SAP HANA SQL Expression?
Ans:

A clause is evaluated using SQL Expression to return values in SAP HANA.

Q: What are different types of SAP HANA SQL expressions?
Ans:

In SAP HANA, a variety of SQL expressions are supported.

1. Case Expressions: Without writing a procedure, the user can use IF- THEN- ELSE logic in this expression.
2. SQL built-in functions may be utilized as expressions in function expressions.
3. Aggregate Expressions: In this expression, a single value is derived from the values of several rows for a column using aggregate functions.
4. Subqueries in Expressions: A select statement uses a subquery as an expression. It returns a single or a zero when used in an expression. It is possible to further limit the data that can be retrieved by using the results of a subquery as conditions in the main query.

Q: What is SAP HANA SQL Data Profiling?
Ans:

Understanding and analyzing data from various data sources is done using the SQL Data Profiling task. Before they are imported into Data, it is used to remove inaccurate and incomplete data and minimize data quality issues.

Q: What is persistent layer in SAP HANA?
Ans:

For handling all operational and transactional data in SAP HANA, the Persistence layer is utilized to create safe backups and restore data in the event of corruption or database crashes. It offers the ability to utilize Save points, which can be used to restore data.

Q: How many types of replication are there in SAP HANA?
Ans:

In general, there are four different kinds of system replication modes in SAP HANA:

The standard replication mode is synchronous in-memory (syncmem). After successfully receiving the log, the primary node waits for the secondary node to provide a confirmation message. The primary node/system does not commit any transactions before that time.

The primary node waits and suspends its transactions until the secondary node sends an acknowledgment in the synchronous mode (sync) of system replication. The acknowledgement signifies that the data log has been accepted and that the log volumes are still present on the disk.

With SPS08, a new mode called Synchronous Full Sync Mode (full sync) was added in addition to the standard sync mode. Because it stops transactions on the primary node until replication has finished successfully on the secondary node, the full sync mode ensures total data protection, i.e., no data loss.

In the asynchronous mode (async), the primary and secondary nodes operate asynchronously. In this manner, until the secondary node gives an acknowledgment or confirmation, the primary node keeps running its transactions.

Q: What is Delta Shipping in SAP HANA?
Ans:

We can run a second non-production system on the remote site if necessary because operation mode delta_datashipping has a smaller memory footprint on the secondary node since column store tables should not have to be loaded during replication.

Q: How to check SAP HANA replication logs?
Ans:

If the replication is SLT, users can go to transaction /IUUC SYNC MON in your SLT system and look through the Application Logs (use filters), or can try the general transaction ST22, which might also provide you with some information.

Q: What is SAP HANA sizing?
Ans:

The primary purpose of a SAP HANA Sizing is to calculate the hardware requirements for the SAP HANA system, which includes significant components like RAM, CPU, and the hard disc. In terms of sizing, memory comes first, followed by CPU.

Q: What is AMDP in SAP HANA?
Ans:

The optimal way of creating SAP HANA DB procedures on the ABAP platform is through ABAP Managed Database Procedures (AMDP). The ABAP class editor provides as the editing environment for AMDPs because ABAP Managed Database Procedures are implemented as methods of a global ABAP class.

Q: What is the use of CDS views in SAP HANA?
Ans:

An infrastructure called SAP CDS (SAP Core Data Services) allows data models to be created and used on database servers as opposed to application servers. Developers can design semantically rich data models using ABAP CDS Views and then expose them through application services to UI clients.

Q: What is the difference between CDS and AMDP in SAP HANA?
Ans:

Users can develop CDS views to read and process data at the DB layer. In contrast, AMDP can be built to process and modify data at the database layer. AMDP is used to work with stored procedures, which are then sent to the HANA DB layer to be executed.

Q: Why do we use calculation view in SAP HANA?
Ans:

Analytical, attribute, and other calculation views are consumed by calculation views. They are intended to carry out complicated calculations that are difficult with other Views. Calculation views can be made using either the SQL Editor or the Graphical Editor.

Q: What is transparent filter in SAP HANA?
Ans:

With SPS09, the transparent filter flag was introduced. Its goal is to prevent attributes from being included in aggregations when they are simply required for filtering.