SAP Hana Interview Questions and Answers

1
Top 25 SAP HANA Most Popular Interview Questions

• Hub4Tech

2
Question 1 What is SAP HANA?

• Answer
• SAP HANA stands for High Performance Analytical
  Appliance- in-memory computing engine. HANA is
  linked to ERP systems Frontend modeling studio
  can be used for replication server management and
  load control.

3
Question 2 What is the role of the persistence
layer in SAP HANA?

• Answer
• SAP HANA has an in-memory computing engine and
  access the data straightaway without any backup.
  To avoid the risk of losing data in case of
  hardware failure or power cutoff, persistence
  layer comes as a savior and stores all the data
  in the hard drive which is not volatile.

4
Question 3What are the different editions
available in HANA appliance software?

• Answer
• Platform 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 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.

5
Question 5 What is modeling studio?

• AnswerModeling studio in HANA performs multiple
  task like
• Declares which tables are stored in HANA, first
  part is to get the meta-data and then schedule
  data replication jobs.
• Manage Data Services to enter the data from SAP
  Business Warehouse and other systems.
• Manage ERP instances connection, the current
  release does not support connecting to several
  ERP instances.
• Use data services for the modeling.
• Do modeling in HANA itself.
• essential licenses for SAP BO data services.

6
Question 5 What is columnar and Row-Based Data
Storage?

• Answer
• 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 specifying 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.

7
Question 6what are the different compression
techniques?

• Answer
• There are three different compression techniques
• Run-length encoding
• Cluster encoding
• Dictionary encoding

8
Question 7 What are the advantages of Column
based tables?Answer

• Answer
• 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).

9
Question 8Mention what is the advantage of SLT
replication?

• Answer
• SAP SLT works on trigger based approach such
  approach has no measurable performance impact in
  the source system.
• It offers filtering capability and
  transformation.
• It enables real-time data replication,
  replicating only related data into HANA from
  non-SAP and SAP source systems.
• It is fully integrated with HANA studios.
• Replication from several source systems to one
  HANA system is allowed, also from one source
  system to multiple HANA systems is allowed.

10
On demand Training and Talent Assessment Platform

• SAP ABAP Online Free Interview Question
  https//goo.gl/hbPCWP
• SAP ABAP Online Free Tutorials https//goo.gl/gz21
  J4
• SAP ABAP Online Free Quiz https//goo.gl/KmuwyX