Top SAP HANA Administration Interview Questions and Answers

Last updated on Feb 18 2022
Rajnikanth S

Table of Contents

Top SAP HANA Administration Interview Questions and Answers

What Is Sap Hana Studio?

  1. The SAP HANA studio is an Eclipse-based development and administration tool for working with HANA.
  2. It enables technical users to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc.
  3. It is a client tool, which can be used to access local or remote HANA system.

What Are the Supported Platforms for Hana Studio?

The SAP HANA studio runs on the Eclipse platform 3.6.

We can use the SAP HANA studio on the following platforms:

Microsoft Windows x32 and x64 versions of: Windows XP, Windows Vista, Windows 7

SUSE Linux Enterprise Server SLES 11: x86 64-bit version

Note: For Mac OS, HANA studio is available but there is no HANA client for that.

What Is Schema in Sap Hana?

There are 3 types of schemas:

  1. User Defined Schema
  2. System Defined Schema
  3. SLT Derived Schema

User Defined Schema : These are created by user (DBA or System Administrator

SLT Derived Schema : When SLT is configured, it creates schema in HANA system. All the tables replicated into HANA system are contained in this schema

System Defined Schema : These schemas are delivered with the SAP HANA database and contain    HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO,_SYS_STATISTICS etc.

A database schema is a way to logically group objects such as tables, views, stored procedures etc.

What Are the Different License Keys Types in Hana System? What Is Their Validity?

  1. Temporary License key
  2. Permanent License Key

Temporary License key:

  • Temporary License keys are automatically installed when you install the HANA database.
  • These keys are valid only for 90 days and you should request permanent license keys from SAP market place before expiry of this 90 days period after installation.

Permanent License Key:

  • Permanent License keys are valid till the predefine expiration date.
  • License keys specify amount of memory licensed to target HANA installation.

What is the Difference Between Catalog and Content Tab?

Catalog: This contains RDBMS objects like schemas, tables, views, procedures, etc.

you can open SQL editor and design database objects.

Content tab: This is used to maintain design time repository. You can create new packages and design Information views in HANA system. Various views can be created under content tab to meet business requirement and to perform analytical reports on the top of the Modelling views.

What Are the Types of Calculation View?

SAP HANA Graphical Calculation View (Created by SAP HANA Studio Graphical editor).

SAP HANA Script-based calculations Views (Created by SQL Scripts by SAP HANA Studio).

What Are the Different Types of Nodes in Calculation View?

Different types of nodes, they are:

Join: This node is used to join two source objects and pass the result to the next node. The join types can be inner, left outer, right outer and text join.Note: We can only add two source objects to a join node.

Union: This is used to perform union all operation between multiple sources. The source can be n number of objects.

Projection: This is used to select columns, filter the data and create additional columns before we use it in next nodes like a union, aggregation and rank.

Aggregation: This is used to perform aggregation on specific columns based on the selected attributes.

Rank: This is the exact replacement for RANK function in SQL. We can define the partition and order by clause based on the requirement.

Which Engine is Used to Create Analytic View?

OLAP Engine :

  • This engine will be called in the backend whenever we run any queries on Analytic Views in SAP HANA.
  • If there are no additional calculations performed like calculated columns, restricted measures and counters, then everything will be processed in OLAP Engine.
  • OLAP Engine acts as join engine for those Attribute Views used in Analytic Views, without any calculated columns
  • All the join engine work will be converted into ‘BwPopJoin’ which is part of OLAP Engine.
  • If there are any calculations present, to be performed then Calculation engine will be used along with OLAP Engine.

What Sort of Advantages Do Businesses Have with Effective Database Management?

  1. By data managing the users are free to derive results that can be considered for the long run
  2. A lot of difficulties related to data can be avoided easily
  3. The data can be managed in sections and can be accessed easily
  4. Well managed data is useful in designing reports, preparing documents and assisting various departments in other tasks.

What Are the Various Tasks in the Sap Hana Which Are Performed By The Modeling Studio?

The very first task it perform is selecting the type of tables which are to be stored in the HANA. The selection of Meta data is also the responsibility of the modelling studio. All the data services for entering the data from warehouse or other location are handled by it. It simply manages the ERP instances connections. The entire data services can be used for modelling only through the modelling studio. Any sort of other modelling in the SAP HANA itself is handled by the studio. Moreover, the tasks associated with the encoding are also managed and controlled by the modelling studio.

What Do You Know About the Master Controller Job in The Hana?

It is a controller that can be deployed for various reasons and purposes. It simply makes sure of creating logging tables and triggers the same in the system.  The synonyms can also be created with the help of master controller. Also, the new entries in the administration tables can be made with the help of this approach. The whole table can also be loaded with this approach.

Can You Tell Something About the Role of Transaction Manager And Session In Sap Hana?

All the database transactions can be co-ordinated simply with the transaction manager and the users are free to keep a close eye on the closed as well as on the running transactions. The transactions are notified to the users when they are rolled backed or when they are committed. This makes sure of the smooth running of the storage engines.

What is the Best Way to Manage, Operate, And Monitor Sap Hana Systems?

Sap Hana is a young database with interesting features of SAP HANA. First of all Sap Hana is an in-memory database. It is accessible for administration via various channels. Directly from the Server, It is not the most convenient method but you can use hdbsql to manage databases. With the web-based interface Hana cockpit, you can browse and manage sap hana environments. The Client Hana Studio is the complete tool to administer Sap Hana but it has to be physically installed and therefore is dependent on the client hardware.

What are the Data Provisioning Technologies available to replicate data to HANA?

Ans: SLT
BODS
SXC

What are the different editions available in HANA appliance Software?

Ans: Platform Edition
Enterprise Edition

What are the critical services HANA DB Server Consists?

Ans:Index Server
Name Server
Statistics Server
Preprocessor Server
XS Engine

What’s new with SPS09 – Admin Features?

Ans: SAP HANA Cockpit – Web-based tool for administration and monitoring of a single SAP HANA Database.

SAP DB Control Center – Web-based tool for administration and monitoring of your landscape of SAP Database.

New/Enhanced Monitoring Views

SAP HANA Multitenant Database Containers

Improved Resource Monitoring

What Is Sap Hana 1.5, 1.2 Or 1.0 Sp03?

They are all the same thing, and 1.0 SP03 is touted to be the final name which should go into Ramp Up (beta) in Q4 2011. This allows any SAP Net Weaver BW 7.3 Data Warehouse to be migrated into a HANA appliance. HANA 1.0 SP03 specifically also accelerates BW calculations and planning, which means even more performance gains can be attained.

What is a Restricted User in Sap Hana System?

Restricted users are those users who access HANA system with some applications and they don’t have SQL privileges on HANA system. When these users are created they don’t have any access initially.

Explain What is Schema Mapping in Sap Hana?

Schema mapping is done when the physical schema in the target system is not the same as the physical schema in the source system. As mentioned earlier, suppose we are moving components from Development System (DEV) to Production System (PROD).

The tables in DEV reside in DEV_SCHEMA and the same tables reside in PROD system in PROD_SCHEMA schema. If an attribute view is transported from DEV to PROD, it will not work because the schema name is referenced in the definition of attribute view. In order for the promoted objects to work in PROD, schema mapping needs to be set up in the target system.

What are System Requirements for Sap Hana?

Java JRE 1.6 or 1.7 must be installed to run the SAP HANA studio. The Java runtime must be specified in the PATH variable. Make sure to choose the correct Java variant for installation of SAP HANA studio:

32-bit installation, choose a 32-bit Java variant.

For a 64-bit installation, choose a 64-bit Java variant.

What Is a Delivery Unit in Sap Hana?

Delivery unit (DU) is a container used by the Life Cycle Manager (LCM) to transport repository objects between the SAP HANA systems.

The name of Delivery Unit must contain only capital letters (A-Z), digits (0-9) and underscores (_).

Why To Configure Import Server in Sap Hana?

In order to load data from external sources to SAP HANA we need to establish a connection with the server. To connect, we need to provide details of Business Objects Data Services repository and ODBC drivers. Once the connection is established, we can import the tables definition and then load data into table definition.

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 Modelling is supported only on Column based tables.

What Are the Different Perspectives Available in Hana?

Modeler : used for creating various types of views and analytical privileges.

SAP HANA Development: Used for programming applications for creating development objects to access or update data models such as Server-side Java script or HTML files.

Administration : Used to monitor the system and change settings.

Debug: Used to debug code such as SQLScript (.procedure files) or Server-side Java script (.xsjs files).

What Are the Supported Object Types in Modeler Perspective?

Attribute views, Analytical views, Calculation views, Analytical privileges, Procedures, Decision tables, Process Visibility Scenario.

Explain Parallel Processing in Sap Hana?

  1. Using the columnar data storage approach, the workload in SAP HANA is divided vertically.
  2. The columnar approach allows linear searching and aggregation of data rather than two-dimensional data structure.
  3. If more than one column is to be processed, each task is assigned to diverse processor.
  4. Operations on one column are then collimated by column divisions processed by different processors.

What Are the Advantages of Attribute View?

  • Attribute View act as Master data context, which provides Text or Description for Key/Non-key field.
  • Attribute View can be reuse in Analytic View and Calculation View.
  • Attributes View is used to select a subset of columns and rows from a database table.
  • Attributes (fields) can be calculated from multiple table fields.
  • There is no measure and aggregation option.

Which Engine Is Used to Create Attribute View?

  • Join engine is used to create attribute view
  • This engine is used when we execute any Attribute View in HANA or run native SQL on more than one table with join condition.
  • If there are any calculations involved either in Attribute View or in native SQL then Join Engine will use Calculation Engine for calculations or fetch the result.

What is the Characteristic of Sap Hana Calculation View?

  • Support Complex Calculation.
  • Support OLTP and OLAP models.
  • Support Client handling, language, currency conversion.
  • Support Union, Projection, Aggregation, Rank, etc.

What Is Calculation View with Star Join?

Calculation View with Star Join :

  • It does not allow base column tables, Attribute Views or Analytic views to add at data foundation.
  • All Dimension tables must be changed to Dimension Calculation views to use in Star Join.
  • All Fact tables can be added and can use default nodes in Calculation View.

Can We Call an Analytic View or Calculation View Inside Another Calculation View in Sap Hana?

Yes. We can call all the views (attribute, analytic and calculation view) inside a calculation view.

Note: Calculation views are composite views and can be used to combine other views.

It can consume other Analytical, Attribute, other Calculation Views & tables.

It can perform complex calculations not possible with other views.

Which Engine is used to Create Calculation View?

SQL Engine which is also known as SQL Parser/interface is used for all sorts of SQL statements generated by frontend application via different different clients and also for native sql run at database level.

From SAP HANA SP7, we have an option for Calculation Views in ‘Properties’ section, where we have an option to choose calculation view to run in ‘SQL Engine’. Advantage of this option is that, instead of moving data between multiple engines HANA executes the entire script in SQL Engine to get the final result.

What are the Properties of Analytic View?

Following are the properties of SAP HANA Analytic View:

  • Analytic Views are used to perform complex calculations and Aggregate functions like Sum, Count, Min, Max, Etc.
  • Analytic Views are designed to run Start schema queries.
  • Each Analytic View has one Fact table surrounded by multiple dimension tables. Fact table contains primary key for each Dim table and measures.
  • Analytic Views are similar to Info Objects and Info sets of SAP BW.

Tell Something You Know About Normalization and De-normalization?

Normalization is nothing but the process that is adopted for the purpose or removing the redundant data from the database. This is generally done by splitting the table into different sections. This actually makes sure of integrity. On the other side, the de-normalization is the process of considering the redundant data so that all the queries which are complex can be enhanced in terms of overall performance.

Organizations Have to Spend a Very Large Amount of Money Every Year on Database Management, Are You Agree with This?

Yes, this is totally right. However, it largely depends on the way a user’s is handling this approach. Basically, data management is a complex approach and there are a lot of tasks which are actually very critical. Managing the database without an effective tool is a big challenge. If an organization can consider a powerful tool like SAP HANA, a lot of tasks can be made simply and a ton of favorable outcomes can be derived simply.

Why There Is Actually a Need for The Businesses to Invest in A Rdbms Tool in The Present Time?

Managing the data is very important. In the present time, data plays an excellent role in the success of almost every business. Data helps in decision making, collaborations, start new ventures, tackling competition, improving quality and so on. There are a large number of other reasons as well that are mandatory for the business to get it done in a right manner. Thus management of data is important.

Can You Tell Some Important Benefits That Users Can Have from The Slt Replication in Sap Hana?

It is basically an approach that has been categorized as triggered one i.e. users need not to worry about the overall impact of performance on the source system. The users can simply make sure of filtering, as well as transformation of the data even if the size is bulky. In addition to this, real-time data replication can also be assured by the users.  It is possible for the users to simply make sure of multiple source systems to only one system based on HANA. The reverse action is also possible.

What Problems Can Unnecessary Information Can Cause in The Sap Hana and How You Can Avoid the Same from Being Stored In The Application?

Many times, the users have to deal with the information that is not relevant with any task. Generally, it can cause slow data processing speeds and can affect accuracy and reliability upto a high extent. The users are free to temporary stop the replication and this can avoid the problem of storing any unwanted information or data in the system. To disable replication temporarily, the users just have to stop the schema related jobs in the system.

How to Secure a Sap Hana User Connection?

A Sap Hana database user is protected in the first place with a password. However, a password is very often required at the command line in order to connect and execute a batch or an SQL script. The username and password are then visible to anyone. In order to avoid that situation, it is possible to create a special key in relation to a particular user. Username and password are then invisible via the use of that key.

What Exactly Is the Significance of Persistence Layer In Sap Hana?

It is actually an important later in SAP HANA which plays a very important role. Actually, HANA has a computing engine built inside and the users have to utilize the data directly without taking any backup. The same can create an issue during powerful failure and thus it is necessary to keep a backup of the same. This layer comes as a saviour and it make sure no loss of data during such a situation.

What Are the Benefits That Sql Can Bring For You?

If the queries in the SQL are simple, the users are free to retrieve a very large sum of data very easily from the system. Another good thing about SQL is it is very easy to learn and implement. There is a vast support available for SQL and all the queries can be addressed reliably. Using SQL, the database can be managed very easily and in fact without considering a large amount of coding.

How do you perform BW-on-HANA Migration?

Ans: DMO- Database Migration. This is a new feature available in SUM(Software Update Manager Tool).

How many VMs are supported on a single HANA Production System?

Ans: Multiple SAP HANA Virtual Machines on a Single server are only supported today in non-production environments.

How do you install SAP HANA?

Ans: HDBLCM Tool – To install individual or multiple Hana Server Component.

What are the different perspectives available in HANA Studio?

  • Administrator
  • Modeler
  • Development
  • Debug

How do you update SAP HANA Studio/Client & HANA Revisions?

Ans: Use HDBLCM Tool
1. Stop all processes
2. Make a System Backup if necessary
3. Perform an update
4. Update the depending Components
5. Perform the post update steps
6. Restart all processes

What is the maximum database size for virtual SAP HANA Appliance?

Ans: 1 TB RAM
Cold Data can reside on disk for virtualized SAP HANA databases greater than 1 TB.

What are the tools to export Data from HANA to external System?

Ans: SLT – Database Migration Option
BODS – BO Data Services to export the data from HANA to external systems.

Will the table size in SAP HANA database and in the source system be the same?

Ans: No, Hana database supports compression.

HANA in HA or Distribution Environment Terminology?

Ans: Name Server will have master and slave nodes.
Index Server will have workers and standby nodes.

So, this brings us to the end of the SAP HANA Administration Interview Questions blog.This Tecklearn ‘Top SAP HANA Administration Interview Questions and Answers’ helps you with commonly asked questions if you are looking out for a job in SAP HANA Administration or SAP Domain. If you wish to learn SAP HANA Administration and build a career in SAP domain, then check out our interactive, SAP HANA Administration Training, that comes with 24*7 support to guide you throughout your learning period.

https://www.tecklearn.com/course/sap-hana-administraion/

SAP HANA Administration Training

About the Course

SAP HANA Administration training will help you learn SAP HANA administration tools, security and user management, system management and availability, data provisioning and integration with non-SAP systems and more. You will deploy SAP HANA Studio, automate through OS scripts, command line admin tools through hands-on projects and case studies. This course is designed to clear the HA200 SAP HANA Operations and Administration Certification conducted by SAP and helps you get the best jobs in top MNCs.

Why Should you take SAP HANA Administration Training?

  • The average salary for SAP HANA Database Administrator ranges from approximately $65,843 yearly for Administrator to $143,051 yearly for Enterprise Architect. – Indeed.com
  • SAP HANA is one of the top tools for working with real-time data due to the transformational nature of this tool. The role of an SAP HANA Administration and Operations personnel is critical of the success of SAP HANA deployment in any industrial set-up.
  • Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Overview of SAP HANA

  • Overview of SAP HANA
  • Features and Benefits of SAP HANA
  • SAP HANA Components
  • Concept of SAP HANA guides
  • Scenarios in SAP HANA Administration

Architecture of SAP HANA

  • What is SAP HANA persistence
  • Concept of Sizing in SAP HANA
  • Process of achieving scale out in SAP HANA
  • How SAP HANA achieves in-memory computation
  • Concept of columnar database
  • How SAP HANA is so fast with comparison to other tools

SAP HANA installation

Overview of SAP HANA tools

  • SAPA HANA Studio for Administration activities in SAP HANA
  • Accessing local and remote HANA systems using Client Tool
  • Monitor, Control, Configure and Administer the SAP HANA database using DBA Cockpit
  • Using HANA Studio Information modelling and data provisioning in HANA database
  • SAP HANA Transport

SAP HANA Operations

  • Privileges in HANA
  • Configure Password Policy and create user in SAP HANA
  • Auditing in SAP HANA

SAP HANA Smart Data Access

Data Provisioning in SAP HANA

  • Leveraging SAP HANA technology and integration architecture for enriching, cleansing and transforming data from disparate sources
  • Data replication with the SAP Landscape Transformation (SLT)
  • Implementing SLT Configuration with SUSPEND LOAD

SAP HANA Operations

  • Create Repository and Job Server
  • SAP GRC Architecture

Administration Operations in HANA Studio

  • Updating HANA database using lifecycle management
  • Security in SAP HANA
  • Sessions and Transactions in SAP HANA
  • Configure System Replication using HANA Cockpit

Migration to SAP HANA using DMO

Performance Monitoring and Analysis in SAP HANA

Got a question for us? Please mention it in the comments section and we will get back to you.

0 responses on "Top SAP HANA Administration Interview Questions and Answers"

Leave a Message

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