Top 5 SAP HANA Interview Questions & Answers

1) Mention what is SAP HANA?

SAP HANA stands for High Performance Analytical Appliance- in-memory computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication server management and load control.

2) Mention the two types of Relational Data stored in HANA?

The two types of relational data stored in HANA includes

• Row Store
• Column Store

3) Mention what is the role of the persistence layer in SAP HANA?

SAP HANA has an in-memory computing engine and access the data straightaway without any backup. To avoid the risk of losing data in case of hardware failure or power cutoff, persistence layer comes as a savior and stores all the data in the hard drive which is not volatile.

4) Mention what is modeling studio?

Modeling studio in HANA performs multiple task like

• Declares which tables are stored in HANA, first part is to get the meta-data and then schedule data replication jobs
• Manage Data Services to enter the data from SAP Business Warehouse and other systems
• Manage ERP instances connection, the current release does not support connecting to several ERP instances
• Use data services for the modeling
• Do modeling in HANA itself
• essential licenses for SAP BO data services

5) Mention what are the different compression techniques?

There are three different compression techniques

• Run-length encoding
• Cluster encoding
• Dictionary encoding

6) Mention what is latency?

Latency is referred to the length of time to replicate data from the source system to the target system.