Learn SAP HANA Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Top 15 SAP HANA Interview Questions & Answers

Harsh Sharma
24/02/2018 0 0

1) Mention what is SAP HANA?

Ans. 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?

Ans. 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?

Ans. 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?

Ans. 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?

Ans. There are three different compression techniques

  • Run-length encoding
  • Cluster encoding
  • Dictionary encoding

6) Mention what is latency?

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

7) Explain what is transformation rules?

Ans. Transformation rule is the rule specified in the advanced replication setting transaction for the source table such that data is transformed during the replication process.

8) Mention what is the advantage of SLT replication?

Ans. The advantage of SLT replication are:

  • SAP SLT works on trigger based approach; such approach has no measurable performance impact in the source system.
  • It offers filtering capability and transformation.
  • It enables real-time data replication, replicating only related data into HANA from non-SAP and SAP source systems.
  • It is fully integrated with HANA studios.
  • Replication from several source systems to one HANA system is allowed, also from one source system to multiple HANA systems is allowed.

9) Explain how you can avoid un-necessary information from being stored?

Ans. To avoid un-necessary information from being stored, you have to pause the replication by stopping the schema-related jobs

10) Mention what is the role of master controller job in SAP HANA?

Ans. The job is arranged on demand and is responsible for

  • Creating database triggers and logging table into the source system
  • Creating Synonyms
  • Writing new entries in admin tables in SLT server when a table is replicated/loaded

11) Explain what happens if the replication is suspended for a longer period of time or system outage of SLT or HANA system?

Ans. If the replication is suspended for a longer period of time, the size of the logging tables increases.


12) Mention what is the role of the transaction manager and session?

Ans. The transaction manager co-ordinates database transactions and keeps a record of running and closed transactions. When transaction is rolled back or committed, the transaction manager notifies the involved storage engines about the event so they can run necessary actions.

13) Explain how you can avoid un-necessary logging information from being stored?

Ans. You can avoid un-necessary logging information from being stored by pausing the replication by stopping the schema-related jobs.

14) Explain how SQL statement is processed?

Ans. In the HANA database, each SQL statement is implemented in the reference of the transaction. New session is allotted to a new transaction.

15) Name various components of SAP HANA?

Ans. The various components of SAP HANA are:

  • SAP HANA Studio
  • SAP HANA Appliance
  • SAP HANA Application Cloud.
0 Dislike
Follow 2

Please Enter a comment


Other Lessons for You

SAP Analytics Cloud(SAC), or SAP Cloud Analytics
Hi All For all those who are currently working on SAP-BW,SAP-HANA,SAP-BO,SAP-Lumira,Design Studio,S/4HANA,BW/4HANA suggested to update SAP Analytics Cloud(SAC) a cloud version of BI from SAP Which is...

Sap Hana: How To Start Hana Studio & Start Hana System To Understand The Components And Views?
D-Click on SAP HANA Studio from the desktop. Use the login your user name and password which you got from the system adminstrator. Once login in to HANA system. Click on Add System if need to add...

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial
SAP HANA Database is Main-Memory centric data management platform. SAP HANA Database runs on SUSE Linux Enterprises Server and builds on C++ Language. SAP HANA Database can be distributed to multiple...

SAP HANA SQL Stored Procedure Tutorial
A procedure is a unit/module that perform a specific task. This procedure can be combined to form larger programs. This basically forms the 'Modular Design'. A procedure can be invoked by another procedure...

Differences Between SAP HANA & SAP S/4HANA
Some levels of confusion between SAP HANA and SAP S/4HANA still exist with the majority of the people these days. In this article, I would like to provide clarity for those who are wrestling with the differences...

Looking for SAP HANA Training Classes?

The best tutors for SAP HANA Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn SAP HANA Training with the Best Tutors

The best Tutors for SAP HANA Training Classes are on UrbanPro

Book a Free Demo

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more