Wednesday, October 16, 2013

SAP HANA Interview Questions And Answers

 SAP HANA Interview Questions And Answers
1.What is the reason for going In-memory? One reason is the number of CPU cycles per second is increasing and the cost of processors is decreasing. For managing the data in memory, there is five-minute rule which is based on the suggestion that it costs more to wait for the data to be fetched from disk than it costs to keep data in memory so it depends on how often you fetch the data. For example there is a table and no matter how large it is and this table is touched by a query at least once every 55 minutes, it is less expensive (in hardware costs) to keep it in memory than to read it from memory and if it is frequently accessed it is less expensive to store it in memory.
2.What is a Five-minute rule? It is a rule of thumb for deciding whether a data item should be kept in memory, or stored on disk and read back into memory when required. The rule is “randomly accessed disk pages of cache are re-used every 5 minutes”.
3.What is multi-core CPU? Multiple CPU‟s on one chip or in one package is called multi-core CPU. . Traditional databases for online transaction processing (OLTP) do not use current hardware efficiently.
4.What is Stall? Waiting for data to be loaded from main memory into the CPU cache is called as Stalls.
5.What is SAP In-Memory Appliance (SAP HANA)? HANA is an in-memory technique to store data that is particularly suited for handling very large amounts of tabular, or relational, data with extra ordinary performance. Common databases store tabular data row-wise. Reorganizing the data in memory column-wise brings a tremendous speed increase when accessing a subset of the data in each table row.
6.What are the components or products of HANA? SAP HANA contains the following components and administration tools: • SAP® In-Memory Computing Engine (IMCE) Server 1.0 • SAP® IMCE Clients 1.0 – The IMCE clients are the interfaces by which the IMCE can communicate with other components. The following subcomponents are included: IMCE ODBO 1.0 IMCE ODBC 1.0 IMCE JDBC 1.0 IMCE SQLDBC 1.0 • SAP® IMCE Studio1.0 (includes SAP HANA Modeler) • Sybase Replication Server 15 + Sybase Enterprise Connect Data Access (ECDA) • Sybase Replication Agent • SAP® HANA Load Controller 1.0 (includes R3Load, RepServer De-cluster Add-On) • SAP® Host Agent 7.20
7.What are the different editions available in HANA appliance software? Platform , and Enterprise edition. Platform edition is intended for customers who want to use ETL-based replication and already have
a license for SAP BO Data Services. Enterprise edition is intended for customers who want to use either trigger-based replication or ETL-based replication and do not already have all of the necessary licenses for SAP BO Data Services. Extended edition is intended for customers who want to use the full potential of all available replication scenarios including log-based replication.
8.What is columnar and Row-Based Data Storage?
Fig: Row and Column-based storage A database table contains data in the form of rows and columns. However Computer memory is organized as a linear structure. To store a table in linear memory, there are two options. A row-based storage stores a table as a sequence of records, each of which contains the fields of one row. In a columnar storage the entries of a column are stored in contiguous memory locations.
The SAP HANA database allows to specify whether a table is to be stored column-wise or row-wise. It is also possible to alter an existing table from columnar to row-based and vice versa. Search operations in tabular data can be accelerated by organizing data in columns instead in rows.
9.What are the advantages of Column based tables? Calculations are typically executed on single or a few columns only. The table is searched based on values of a few columns. The table has a large number of columns. The table has a large number of rows and columnar operations are required (aggregate, scan, etc.). High compression rates can be achieved because the majority of the columns contain only few distinct values (compared to number of rows).
10.What are the advantages of Row-based tables? The application needs to only process a single record at one time (many selects and/or updates of single records). The application typically needs to access a complete record (or row). The columns contain mainly distinct values so that the compression rate would be low. Neither aggregations nor fast searching are required. The table has a small number of rows (e. g. configuration tables).
11.In which case the data to be stored in columnar storage? To enable fast on-the-fly aggregations, ad-hoc reporting, and to benefit from compression mechanisms it is recommended that transaction data to be stored in a column-based table.
12.Is it possible to join tables of row-based with column-based tables? Yes
13.Are column-based tables always the better choice than row-based tables? No. There are also situations in which row based tables are advantageous.
14.What are the advantages of Columnar tables? Higher Data Compression Rates Higher Performance for Column Operations Elimination of Additional Indexes Parallelization Elimination of Materialized Aggregates
15.What are the different Compression Techniques you know? Run-length encoding Cluster encoding Dictionary encoding


  1. great work really thank you for the info about sap .a free live demo on all sap Exp trainers
    SAP Business Objects Trainer

  2. Hi My name is uma .I'm so happy after finding this information nice post . who are want to learn SAP Business Objects Online Training

  3. Thanks for Information SAP BO (Business Objects) Module is one of the Largest Module in SAP offers a broad portfolio of tools and inbuilt applications designed to help you to easily optimize business performance by connecting individuals, data and businesses across the business networks. It additionally offers consulting and education services to assist the customers deploy its business intelligence tasks.SAP BO Online Training

  4. Hi Sir, you provided great info it is interesting and useful for the starters, i feel it is right place to get info, we also provide sap fico online training, thanks for the info.

  5. Hi Sir, the info you provided is very interesting and useful, i feel it right place to get info, we also provide sap mm online training, thanks for the info and keep posting more.

  6. Hi Sir, you provided nice info on SAP HANA interview questions, we provide sap remote access for all SAP modules 24/7, thanks for the info.

  7. nice blog and thanks for sharing the information. Hyderabadsys provides best SAP BO Online Training

  8. Thanks a lot for sharing your unique informative post which is attaining more information. Keep on blogging like this unique informative post with us.

    Salesforce Training in Chennai

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

    SAP training in Chennai

    SAP FICO training in Chennai

  10. It was very nice blog to learn about Selenium.Thanks for sharing new things.selenium training in chennai

  11. thanks for giving the valuable information about the sap bo , excellent blog
    sap bo online training

  12. Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

    iOS Training in Chennai

  13. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
    Digital Marketing Company in India
    Seo Company in India

  14. Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.

    SEO Training in Chennai
    Java Training in Chennai

  15. Shree Ram Techno Solutions Provides CCTV Camera, Security Camera, Wireless Security, Attendance System, Access Control System, DVR, NVR, Spy Camera, Fire Alarm, Security Alarm, PCI, IP Network Camera, Dome Camera, IR Camera, CCTV, Camera Price, HIKVISION, SCATI, Time Machine

    CCTV CAmera in jaipur at Rajasthan
    Home security system in jaipur
    Wireless Home Security System in jaipur
    Realtime attendance machine in jaipur
    cctv camera dealer in jaipur
    Hikvision DVR in jaipur at Rajasthan
    security system solutions in jaipur

  16. I wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.

    Android App Development Company

  17. I am expecting more interesting topics from you. And this was nice content and definitely it will be useful for many people.
    iOS App Development Company
    iOS App Development Company

  18. You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...
    Fitness SMS
    Fitness Text
    Salon SMS
    Salon Text
    Investor Relation SMS
    Investor Relation Text
    Mobile Marketing Services
    mobile marketing companies
    Sms API

  19. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    web design Company
    web development Company
    web design Company in chennai
    web development Company in chennai
    web design Company in India
    web development Company in India


  20. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

    Personal Installment Loans
    Title Car loan
    Cash Advance Loan

  21. Excellent read, Positive site, where did u come up with the information on this posting? I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work

    PSD to Wordpress
    wordpress website development