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
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
ReplyDeleteHi 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.
ReplyDeleteHi 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.
ReplyDeleteHi 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.
ReplyDeletenice blog and thanks for sharing the information. Hyderabadsys provides best SAP BO Online Training
ReplyDeleteReally good stuff. we can get really good knowledge on SAP HANA interview questions.
ReplyDeleteSAP training in Chennai
SAP FICO training in Chennai
thanks for giving the valuable information about the sap bo , excellent blog
ReplyDeletesap bo online training
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.
ReplyDeleteSEO Training in Chennai
Java Training in Chennai
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
ReplyDeleteCCTV 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
I love the blog. Great post. It is very true, people must learn how to learn before they can learn. lol i know it sounds funny but its very true. . .
ReplyDeleteangularjs interview questions and answers
angularjs-Training in pune
angularjs Training in bangalore
angularjs Training in bangalore
angularjs Training in chennai
Awesome..You have clearly explained …Its very useful for me to know about new things..Keep on blogging..
ReplyDeleteJava training in Chennai | Java training institute in Chennai | Java course in Chennai
Java training in Bangalore | Java training institute in Bangalore | Java course in Bangalore
Java online training | Java Certification Online course-Gangboard
Java training in Pune
Nice tips. Very innovative... Your post shows all your effort and great experience towards your work Your Information is Great if mastered very well.
ReplyDeletepython course in pune
python course in chennai
python Training in Bangalore
Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us
ReplyDeleteData Science Training in Indira nagar
Data Science Training in btm layout
Python Training in Kalyan nagar
Data Science training in Indira nagar
Data Science Training in Marathahalli | Data Science training in Bangalore
Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
ReplyDeleterpa training in chennai |best rpa training in chennai|
rpa training in bangalore | best rpa training in bangalore
Awesome post, you got the best interview questions and answers.
ReplyDeletePython course in Chennai
Python Training in Chennai
ccna Training in Chennai
ccna course in Chennai
Data Analytics Courses in Chennai
Data Science course in Chennai
Python Training in Anna Nagar
Python Training in Adyar
This was an awesome post. Would definitely appreciate the efforts of admin to share with content with us.
ReplyDeleteIELTS Coaching in Chennai Anna Nagar
IELTS Coaching Centre in Anna Nagar
IELTS Coaching in Anna Nagar
IELTS Coaching in Adyar
IELTS Coaching in Chennai Adyar
IELTS Coaching in Porur
Spoken English Class in Chennai
Spoken English in Chennai
target home theatre
ReplyDeletetarget synonym
target ball
target in html
targeted therapy
Infycle Technologies, the best software training institute in Chennai offers the leading Python course in Chennai for tech professionals, freshers, and students at the best offers. In addition to the Python course, other in-demand courses such as Data Science, Cyber Security, Selenium, Oracle, Java, Power BI, Digital Marketing also will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.
ReplyDeleteSuch a good post .thanks for sharing
ReplyDeleteSalesforce Training in T Nagar
Salesforce Training in Chennai
Very nice post thanks for sharing
ReplyDeleteSai Satcharitra Pdf