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

37 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……….

  26. Preethi Sharma says:

    Hi There,

    That’s really cool…. I followed these instructions and it was like boom… it worked well..

    I started with my Hana Express and I tried to implement this tutorial. But I got a problem, where I have no idea ho to solve it:
    SAP HANA XS Advanced, Creating an HTML5 Module

    If I run this in WebIDE everything works fine, but I try to access this website from outside ( means I opened my home internet router from outside and I call the URL from the “internet” not from my home network. Than I got an error, that the URI is not allowed “The redirect_uri has an invalid domain.” Can anyone help me to solve this problem? If I remove the authorization from my UI5 project, everything works fine. I guess SAP HANA training USA , it depends on the tasks in step 4, but I am note sure, what I have to change in order to make it working.

    By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).

    Please keep providing such valuable information.


  27. ANOOHYA says:


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