• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

SAP HANA Interview Questions – Part 1

These interview questions are continuation from the Tutorial Page. Please visit https://tekslate.com/tutorials/sap-hana-tutorials-interview-questions/.

What is the role of the transaction manager and session?

The transaction manager co-ordinates database transactions and keeps a record of running and closed transactions.  When transaction is rolled back or committed, the transaction manager notifies the involved storage engines about the event so they can run necessary actions.

Explain how you can avoid un-necessary logging information from being stored?

You can avoid un-necessary logging information from being stored by pausing the replication by stopping the schema-related jobs.

Define 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”.

Define Stall?

Waiting for data to be loaded from main memory into   the CPU cache is called as Stall.

Describe SAP HANA Database Architecture in brief?

The SAP HANA database is developed in C++ and runs on SUSE Linux Enterpise Server. SAP HANA database consists of multiple servers and the most important component is the Index Server. SAP HANA database consists of Index Server, Name Server, Statistics Server, Pre-processor Server and XS Engine. 

SAP-HANA-Architecture

At TekSlate, we offer resources that help you in learning various IT courses. We avail both written material and demo 
video tutorials. To gain in-depth knowledge and be on par with  practical experience, then explore SAP HANA Training.


Index Server

Index server is the main SAP HANA database component

It contains the actual data stores and the engines for processing the data.

The index server processes incoming SQL or MDX statements in the context of authenticated sessions and transactions.

Persistence Layer

The database persistence layer is responsible for durability and atomicity of transactions. It ensures that the database can be restored to the most recent committed state after a restart and that transactions are either completely executed or completely undone.

Preprocessor Server

The index server uses the preprocessor server for analyzing text data and extracting the information on which the text search capabilities are based.

Name Server

The name server owns the information about the topology of SAP HANA system. In a distributed system, the name server knows where the components are running and which data is located on which server.

Statistic Server

The statistics server collects information about status, performance and resource consumption from the other servers in the system.. The statistics server also provides a history of measurement data for further analysis.

Session and Transaction Manager

The Transaction manager coordinates database transactions, and keeps track of running and closed transactions. When a transaction is committed or rolled back, the transaction manager informs the involved storage engines about this event so they can execute necessary actions.

XS Engine

XS Engine is an optional component. Using XS Engine clients can connect to SAP HANA database to fetch data via HTTP.

For an Indepth knowledge on SAP HANA, click on below

Summary
Review Date
Reviewed Item
SAP HANA Interview Questions
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on SAP HANA Interview Questions - Part 1"

    Leave a Message

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

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.