SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
Hadoop App
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
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
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Hadoop App
Stay Connected
Search Topics
Topic Index
SAP HANA Interview Questions
Hadoop Interview Questions
Fiori Interview Questions
S/4HANA Interview Questions
SAP Cloud Platform

Interview Questions on SAP HANA Architecture

Qs. What is SAP HANA?
SAP HANA is an in-memory database.
      • It is a combination of hardware and software made to process massive real time data using In-Memory computing.
      • It combines row-based, column-based database technology.
      • Data now resides in main-memory (RAM) and no longer on a hard disk.
      • It’s best suited for performing real-time analytics, and developing and deploying real-time applications.

An in-memory database means all the data is stored in the memory (RAM). This is no time wasted in loading the data from hard-disk to RAM or while processing keeping some data in RAM and temporary some data on disk. Everything is in-memory all the time, which gives the CPUs quick access to data for processing.

SAP HANA is equipped with multiengine query processing environment which supports relational as well as graphical and text data within same system. It provides features that support significant processing speed, handle huge data sizes and text mining capabilities.

To know more, check the article SAP HANA Introduction for Beginners
Qs. So is SAP making/selling the software or the hardware?
SAP has partnered with leading hardware vendors (HP, Fujitsu, IBM, Dell etc) to sell SAP certified hardware for HANA.
SAP is selling licenses and related services for the SAP HANA product which includes the SAP HANA database, SAP HANA Studio and other software to load data in the database.
To know more, check the article SAP HANA Hardware

Qs. What is the language SAP HANA is developed in?
The SAP HANA database is developed in C++.

Qs. What is the operating system supported by HANA?
Currently SUSE Linux Enterprise Server x86-64 (SLES) 11 SP1 is the Operating System supported by SAP HANA.

Qs. Can I just increase the memory of my traditional Oracle database to 2TB and get similar performance?
You might have performance gains due to more memory available for your current Oracle/Microsoft/Teradata database but HANA is not just a database with bigger RAM.
It is a combination of a lot of hardware and software technologies. The way data is stored and processed by the In-Memory Computing Engine (IMCE) is the true differentiator. Having that data available in RAM is just the icing on the cake.

Qs. What are the row-based and column based approach?
Row based tables:
      • It is the traditional Relational Database approach
      • It store a table in a sequence of rows
Column based tables:
      • It store a table in a sequence of columns i.e. the entries of a column is stored in contiguous memory locations.
      • SAP HANA is particularly optimized for column-order storage.
SAP HANA supports both row-based and column-based approach.

Following figure explains the difference between the two storage mechanism.

To know more, check the article Column Data Storage Vs Row Data Storage in HANA

Support us by sharing this article.

Explore More
Close X
Close X

35 thoughts on “SAP HANA Interview Questions – Architecture

  1. Aleena says:


    Getting lot of information form you. Keep it up.

    All the best.


  2. Devraj says:

    Thanks for this info

  3. balu says:

    Hi it’s really nice website & before i don’t see this type of clarifications

    Thanks keeps on updates

  4. Ram says:

    Good one. Lot of learnings.

  5. Sukumar says:

    Nice information ..

  6. Rahul says:

    Thanks for the information. Please continue to add more.

  7. ANKUR says:


  8. sun says:

    Wow its really awesome and nice information for us please keep going on

  9. Gopal says:

    Good one. Thanks for the info.

  10. Aravind says:

    Excellent blog can u post some more questions for hana administration.

  11. Suresh says:

    Good One, Thanks for sharing.

  12. Lakshmi says:

    Thanks much,this is very informative

  13. sanmathi says:


    Thank u for your efforts to make us learn HANA.

  14. Vikram N says:

    nice information…keep updating

  15. syedjameer says:

    i got offer from SAP but have to work with Knowledge Management whether their is any chance to shift my career in SAP-HANA development side

    • Admin says:

      Hi Syed,
      I did not get the point? Have you got job offer from SAP? What is your prior experience?


  16. srikanth says:

    Excellent work …. its means a lot in todays world getting rite information in rite website …. Thanks alot for making awarness in speific areas

  17. new user says:

    this is the best website i have come across so far to learn hana.
    great job guys ! thank you so much.
    i am gettign interested in workign on HANA after this and i am looking forward to implementing HANA in my next project 🙂

  18. Narendra Prachande says:

    Very useful information on HANA….

  19. Ravi Teja says:

    The information is very illustrative and easy to understand.

    Thank you for your incredible information.

  20. Umesh says:

    very good questions and answers

  21. Shankar says:

    This site is the ideal place for who need to start learning SAP HANA,contents are organized effectively.Please publish more real time case studies for deep analysis and understanding,thanks

  22. kiranveeruru says:

    Thank u guys,the way u explained subject very nice and useful,pls continue ur add-on,verymuch helpful.
    Thank u.

  23. pramod says:

    Great job on the website. It is quite comprehensive.

    Just wanted to provide small correction in SAP HANA SLT Replication page.
    You have mentioned Transaction for Advanced Replication Settings as “IUUC_REPL_CONT” multiple times.
    I believe, the correct transaction code is “IUUC_REPL_CONTENT”.
    Please correct me if I am wrong.

  24. srinivas says:

    Nice… thanks a lot

  25. Prashanth Konderu says:

    Awesome website, i never and ever seen this type of clarifications.
    thank you ,
    Keep It Up……….

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 :, All rights reserved.  Privacy Policy