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
 Apps
X
HANA App
>>>
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
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SAP HANA Interview Questions
+
-
Hadoop Interview Questions
+
-
SAPUI5/Fiori Interview Questions

Interview Questions on SAP HANA Architecture: Part-2

Qs. What are the advantages and disadvantages of row-based tables?
Row based tables have advantages in the following circumstances:
      • 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).
      • Neither aggregations nor fast searching are required.
      • The table has a small number of rows (e. g. configuration tables, system tables).
Row based tables have dis-advantages in the following circumstances:
      • In case of analytic applications where aggregation are used and fast search and processing is required. In row based tables all data in a row has to be read even though the requirement may be to access data from a few columns.

Qs. What are the advantages of column-based tables?
Advantages:
    • Faster Data Access:
Only affected columns have to be read during the selection process of a query. Any of the columns can serve as an index.
    • Better Compression:
Columnar data storage allows highly efficient compression because the majority of the columns contain only few distinct values (compared to number of rows).
    • Better parallel Processing
In a column store, data is already vertically partitioned. This means that operations on different columns can easily be processed in parallel. If multiple columns need to be searched or aggregated, each of these operations can be assigned to a different processor core

Support us by sharing this article.



Explore More
Close X
Close X

2 thoughts on “SAP HANA Interview Questions – Architecture

  1. mita says:

    thanks for providing such wonderful material and interview questions
    i am eager to learn your hana administration part-2.so please post that as soon as possible

  2. ganesh biradar says:

    Thank you for this question and answer.

Leave a Reply

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

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy