• Register
100 points

Want to solve programming problems and get paid for it? If that sounds interesting to you then contact us.

1. Mention what is SAP HANA?

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.

2. Mention the two types of Relational Data stored in HANA?

The two types of relational data stored in HANA includes

  • Row Store

  • Column Store

3. Mention what is the role of the persistence layer in SAP HANA?

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. Mention what is modeling studio?

Modeling 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

5.Explain the column and Row store in HANA?

HANA supports both type of data store in database. Row store is used when you need to use Select statement and no aggregations are performed.

Column store is used to perform aggregations and HANA Modeling is supported only on Column based tables.

6.Which companies are providing SAP HANA hardware appliances?

There are total 11 vendors for SAP HANA hardware appliances. Most common are −

  • Dell

  • IBM

  • HP

  • Cisco

  • Lenovo


7. Mention what is the role of master controller job in SAP HANA?

The job is arranged on demand and is responsible for

  • Creating database triggers and logging table into the source system

  • Creating Synonyms

  • Writing new entries in admin tables in SLT server when a table is replicated/loaded

8. Mention what is latency?

Latency is referred to the length of time to replicate data from the source system to the target system.

What are the different components in SAP HANA Architecture? What is the use of Index server?

  • Index Server

  • Name Server

  • Statistical Server

  • Preprocessor Server

  • XS Engine

  • SAP Host Agent

  • LM structure

  • SAP Solution Manager Diagnostic Agent

Index server contains engine to process data in HANA database. These data engines are responsible to handle all SQL/MDX statement in HANA system. Index server also contains Session and Transaction Manager which is responsible to manage all running and completed transactions.

9.What are the different types of permanent license keys in HANA system?

There are two types of permanent License keys for HANA system −

Unenforced − If unenforced license key is installed and consumption of HANA system exceeds the license amount of memory, operation of SAP HANA is not affected in this case.

Enforced − If Enforced license key is installed and consumption of HANA system exceeds the license amount of memory, HANA system gets locked. If this situation occurs, HANA system has to be restarted or a new license key should be requested and installed.

10.What is the difference between Open Data Preview and Open Definition?

Open Data Preview −This is used to see the data stored in an object- table or a modeling view. When you open data preview, you get three options −

  • Raw Data

  • Distinct Values

  • Analysis

Open Definition −This is used to see the structure of the table − column name, column data type, keys, etc.

100 points