Flat 10% & upto 40% off + 10% Cashback + Free additional Courses. Hurry up

Top SAP HANA Interview Questions And Answers

sap hana interview questions
Here are top 31 objective type sample SAP HANA Interview questions and their answers are given just below to them. These sample questions are framed by experts from Intellipaat who trains for SAP HANA training to give you an idea of type of questions which may be asked in interview. We have taken full care to give correct answers for all the questions. Do comment your thoughts Happy Job Hunting!

Sap hana Interview question

Top Answers to SAP HANA Interview Questions

1. Compare SAP HANA & Oracle
Criteria SAP HANA Oracle
Strengths Customization, customer service & functionality Ease of use, quick deployment and flexibility
Compatibility to work with other databases Very Good Average
Comparison on costs More cost for internal resources and training Much lesser on both fronts
2. What is SAP HANA?

SAP HANA is an in-memory computing engine (IMCE) used for real-time processing of huge volumes of data and building and deploying real-world applications. Adopting the row-based and column-based DB technology, SAP HANA is an advanced relational DB product serviced by SAP SE. With this high-performance analytic (HANA) system, the big data exists on the main memory and not on the hard disk. It replaces the onus of data maintenance separately on the legacy system and simplifies the tasks of administrators in this digital world.

Want to know more about “SAP HANA?”- Click here

3. What is the development language used by SAP HANA?


4. Name the operating system SAP HANA supports.

More than 70% of customers run their SAP workloads on Linux with the use of SUSE Linux Enterprise Server, which is the best OS choice for SAP HANA.

5. Explain Parallel Processing in SAP HANA?

Using the columnar data storage approach, the workload in SAP HANA is divided vertically. The columnar approach allows linear searching and aggregation of data rather than two-dimensional data structure. If more than one column is to be processed, each task is assigned to diverse processor. Operations on one column are then collimated by column divisions processed by different processors.

Go through this SAP HANA Tutorial to get a clear understanding of how SAP HANA works.

6. List advantages of using SAP HANA database.
  • With the HANA technology, you can create gen-next applications giving effective and efficient results in the digital economy.
  • By using singe data-in memory, SAP HANA supports smooth transaction process and fault-tolerant analytics
  • Easy and simple operations using an open-source, unified platform in the cloud
  • High-level Data Integration to access massive amounts of data
  • Advanced tools for in-depth analysis of present, past and the future.
7. List the merits and demerits of using row-based tables.


  • No data approach can be faster than row-based if you want to analyze, process and retrieve one record at one time.
  • Row-based tables are useful when there is specific demand of accessing complete record.
  • It is preferred when the table consists of less number of rows.
  • This data storage and processing approach is easier and effective without any aggregations and fast searching.


  • The data retrieval and processing operations involve the complete row, even though all the information is not useful.

Go through this in-depth SAP HANA training and master the powerful columnar database now!

8. List advantages of column-based tables.

Allows smoother parallel processing of data as the data in columns is stored vertically. Thus, to access data from multiple columns, every operation can be allocated to a separate processor core.

  • Only specific columns need to be approached for Select query and any column can be used for indexing.
  • Efficient operations since most columns hold unique values and thus, high compression rate.
9. What table type is preferred in SAP HANA Administration: column-based or row-based?

Since analytic applications require massive aggregations and agile data processing, column-based tables are preferred in SAP HANA as the data in column is stored consequently, one after the other enabling faster and easier readability and retrieval. Thus, columnar storage is preferred on most OLAP (SQL) queries. On the contrary, row-based tables force users to read and access all the information in a row, even though you require data from few and/or specific columns.

Download SAP HANA Interview Questions asked by top MNCs in 2018


10. What is the main SAP HANA database component?

Index Server consists of actual data engines for data processing including input SQL and MDX statements and performs authentic transactions.

11. Explain the concept of Persistence Layer.

The persistence layer in SAP HANA handles all logging operations and transactions for secured backup and data restoring. This layer manages data stored in both rows and columns and provides steady savepoints. Built on the concept of persistence layer of SAP’s relational database, it ensures successful data restores.
Besides managing log data on the disk, HANA’s persistence layer allows read and write data operations via all storage interfaces.

12. Define Modeling Studio in SAP Hana Administration.

Modeling Studio is an operational tool in SAP HANA based on Eclipse development and administration, which includes live project creation.

  • The SAP HANA Studio further builds development objects and deploys them, to access and modify data models like HTML and JavaScript files.
  • It also handles various data services to perform data input from SAP warehouse and other related databases.
  • Responsible for scheduling data replication tasks.
13. List the different compression techniques in HANA?
  • Run-length encoding
  • Cluster encoding
  • Dictionary encoding
14. Explain SLT

SLT expands to SAP Landscape Transformation referring to trigger –based replication. SLT replication permits data transfer from source to target, where the source can be SAP or non-SAP while the target system has to be SAP HANA with HANA database. Users can accomplish data replication from multiple sources. The three replication techniques supported by HANA are:

  • SLT
  • SAP Business Objects Data Services (BODS)
  • SAP HANA Direct Extractor Connection (DXC)
15. Name the replication jobs in SAP HANA.
  • Master Job (IUUC_MONITOR_)
  • Data Load Job (DTL_MT_DATA_LOAD__)
  • Master Controlling Job (IUCC_REPLIC_CNTR_)
  • Migration Object Definition Job (IUCC_DEF_MIG_OBJ_)
  • Access Plan Calculation Job (ACC_PLAN_CALC__)
16. What is Latency?

The time duration to perform data replication starting from the source to the target system is known as latency.

17. What are the various components of SAP HANA Administration?
  • SAP HANA Studio
  • SAP HANA Application Cloud
  • SAP HANA Cloud
  • Sap HANA DB

The Sap Hana Training Videos and Certification Course can open the doors to a stellar career for you.

18. How to perform backup and recovery operations?

During a regular operation, data is by default stored to the disk at savepoints in SAPHANA. As soon a there is any update and transaction, logs become active and get saved from the disk memory. In case of power failure, the database restarts like any other DB returning to the last savepoint log state. SAP HANA requires backup to protect against disk failure and reset DB to the previous state. The backups simultaneously as the users keep performing their tasks.

19. Define SLT Configuration

Configuration is the meaningful information to establish a connection between source, SLT system and SAP HANA architecture as stated in the SLT system. Programmers are allowed to illustrate a new Configuration in Configuration and Monitoring Dashboard.

20. What is Stall?

The waiting process for data to load from the main memory to the CPU cache is called Stall.

21. Define different types of information views.
  • There are primarily three types of information views in SAP HANA, which are all non-materialized.
  •  Attribute view
  •  Analytic view
  • Calculation View
22. What are Configuration and Monitoring dashboard?

They are SLT Replication Application Servers to provide configuration information for data replication. This replication status can also be monitored.

23. What is logging table?

Logging table records all replicated changes in the table, which can be further replicated to the target system.

24. How to define Transformation rules in HANA?

Using advanced replication settings, transformation rules are specified to transfer data from source tables during replication process. For instance, setting rules to covert fields, fill vacant fields and skip records. These rules are structured using advanced replication settings (transaction IUUC_REPL_CONT)

25. Explain the role of transaction manager and session?

SAP HANA transaction manager synchronizes database transactions keeping the record of closed and open transactions. When a transaction is committed or rolled back, the manager informs all the active stores and engines about the action so that they can perform required actions in time.

26. How is SQL statement processed in SAP HANA?

Each SQL statement in SAP HANA is carried out in the form of a transaction. Every time, a new session is allocated to a new transaction. An operator is a special character that is used in SQL statement with WHERE clause for performing operations. The various operators in SAP HANA are logical, arithmetic, comparison, and set.

27. Define Master-Controller job.

A Master-controller job is responsible to build database logging table in the source system. It further creates synonyms and new entries in SLT server admin when the table loads / replicates.

28. How users can avoid un-necessary storage of logging information?

Pause the replication process and terminate the schema-related jobs.

29. Is the table size in source system and Sap HANA system same?


30. When to change the number of Data Transfer Jobs?

The number of data transfer jobs change when the initial loading speed or latency replication time is not up to the mark. At the end of the initial load, the number of initial load jobs may be reduced.

31. What is the default IMCE Studio perspective?

Administrator Console

Take charge of your career by going through our professionally designed SAP HANA Certification Course now.

"15 Responses on Top SAP HANA Interview Questions And Answers"

  1. Rajeesh Maninchery says:

    Nice set of informations,thank you!

  2. akesh says:

    very useful information.

  3. varatharaj says:

    it is a very useful guide

  4. Swapnil says:

    Excellent information. Please upload more if you have any. I am interested in learning HANA in detail. Please let know how should I go ahead with it.

  5. Sundar Koduvayur says:

    Very useful information about HANA. Great Job

  6. Naveen Nalluri says:

    Truly Educational & Practical state . Thanks a lot…

  7. Shobha says:

    Very informative & thanks for Loading.
    Will be very thankful if you upload more!

  8. Narendar reddy says:

    Looks good

  9. vivek gupta says:

    very useful questions and answer.

  10. Rene Austin HOFFMAN says:

    Absolutely the best I’ve seen in 18 years as a SAP consultant! This lady merits our heads up. Wow!

  11. Suresh V says:

    Truly Valuable ……expecting more…!!

  12. Arjun says:

    Really good stuff. we can get really good knowledge on SAP HANA interview questions.

  13. Mudassar Ali says:

    Thanks for updating these valuable questions & answers!

  14. Mahipal Dave says:

    These are very useful question and answer ………Keep adding more question and answer. Thank you.

Leave a Message

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.

Sales Offer

  • To avail this offer, enroll before 22nd May 2018.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Cashback will be accumulated in Intellipaat e-wallet
  • Please use coupon codes mentioned below to avail the offer

Sign Up or Login to view the Free Top SAP HANA Interview Questions And Answers.