Interview Questions.

Question 1. Mention What Is Sap Hana?

Answer :

SAP HANA stands for High Performance Analytical Appliance- in-reminiscence computing engine. HANA is connected to ERP structures; Frontend modeling studio may be used for replication server management and load manage.

Question 2. Mention The Two Types Of Relational Data Stored In Hana?

Answer :

The  kinds of relational data saved in HANA consists of

Row Store
Column Store
SAP BI Interview Questions
Question 3. Mention What Is The Role Of The Persistence Layer In Sap Hana?

Answer :

SAP HANA has an in-memory computing engine and get right of entry to the statistics straightaway without any backup. To avoid the danger of losing statistics in case of hardware failure or strength cutoff, staying power layer comes as a savior and stores all of the data in the hard pressure which isn't volatile.

Question 4. Mention What Is Modeling Studio?

Answer :

Modeling studio in HANA performs a couple of task like

Declares which tables are stored in HANA, first part is to get the meta-information and then time table records replication jobs
Manage Data Services to enter the records from SAP Business Warehouse and different structures
Manage ERP instances connection, the contemporary launch does not help connecting to numerous ERP times
Use data offerings for the modeling
Do modeling in HANA itself
crucial licenses for SAP BO facts services
SAP BI Tutorial
Question five. Mention What Are The Different Compression Techniques?

Answer :

There are 3 extraordinary compression strategies
Run-length encoding
Cluster encoding
Dictionary encoding

SAP HR Interview Questions
Question 6. Mention What Is Latency?

Answer :

Latency is mentioned the duration of time to duplicate data from the source gadget to the target system.

Question 7. Explain What Is Transformation Rules?

Answer :

Transformation rule is the guideline exact inside the advanced replication setting transaction for the source table such that information is transformed during the replication technique.

SAP HR Tutorial SAP BO Interview Questions
Question 8. Mention What Is The Advantage Of Slt Replication?

Answer :

SAP SLT works on trigger based totally method; such approach has no measurable overall performance impact within the source system
It offers filtering capability and transformation
It allows actual-time statistics replication, replicating most effective related records into HANA from non-SAP and SAP supply structures
It is absolutely integrated with HANA studios
Replication from numerous source structures to at least one HANA gadget is permitted, additionally from one supply machine to multiple HANA structures is authorized.
Question nine. Explain How You Can Avoid Un-essential Information From Being Stored?

Answer :

To keep away from un-necessary records from being stored, you need to pause the replication via preventing the schema-related jobs

SAP BASIS Interview Questions
Question 10. Mention What Is The Role Of Master Controller Job In Sap Hana?

Answer :

The task is arranged on call for and is responsible for

Creating database triggers and logging table into the source device
Creating Synonyms
Writing new entries in admin tables in SLT server whilst a desk is replicated/loaded
SAP BO Tutorial
Question eleven. Explain What Happens If The Replication Is Suspended For A Longer Period Of Time Or System Outage Of Slt Or Hana System?

Answer :

If the replication is suspended for an extended time period, the size of the logging tables will increase.

SAP ABAP Interview Questions
Question 12. Mention What Is The Role Of The Transaction Manager And Session?

Answer :

The transaction manager co-ordinates database transactions and continues a file of running and closed transactions. When transaction is rolled again or dedicated, the transaction supervisor notifies the involved storage engines about the event as a way to run necessary actions.

SAP BI Interview Questions
Question thirteen. Explain How You Can Avoid Un-necessary Logging Information From Being Stored?

Answer :

You can avoid un-vital logging information from being saved with the aid of pausing the replication through preventing the schema-related jobs.

SAP BASIS Tutorial
Question 14. Explain How Sql Statement Is Processed?

Answer :

In the HANA database, each SQL declaration is applied within the reference of the transaction. New consultation is allotted to a brand new transaction.

Question 15. Name Various Components Of Sap Hana?

Answer :

SAP HANA DB
SAP HANA Studio
SAP HANA Appliance
SAP HANA Application Cloud

SAP BW Interview Questions
Question 16. How To Perform Backup And Recovery Operations?

Answer :

During a normal operation, statistics is via default saved to the disk at savepoints in SAPHANA. As quickly a there is any update and transaction, logs turn out to be lively and get saved from the disk memory. In case of electricity failure, the database restarts like any other DB returning to the closing savepoint log kingdom. SAP HANA requires backup to defend towards disk failure and reset DB to the preceding nation. The backups concurrently because the customers preserve appearing their responsibilities.

SAP ABAP Tutorial
Question 17. Define Slt Configuration?

Answer :

Configuration is the significant data to establish a connection between source, SLT device and SAP HANA architecture as said inside the SLT system. Programmers are allowed to illustrate a new Configuration in Configuration and Monitoring Dashboard.

Hadoop Interview Questions
Question 18. What Is Stall?

Answer :

The ready system for records to load from the primary memory to the CPU cache is called Stall.

SAP HR Interview Questions
Question 19. Define Different Types Of Information Views.?

Answer :

There are generally three kinds of data views in SAP HANA, which can be all non-materialized.

• Attribute view
• Analytic view
• Calculation View

SAP BW Tutorial
Question 20. What Are Configuration And Monitoring Dashboard?

Answer :

They are SLT Replication Application Servers to provide configuration information for records replication. This replication repute can also be monitored.

SAP SRM Interview Questions
Question 21. What Is Logging Table?

Answer :

Logging desk facts all replicated adjustments within the desk, which can be similarly replicated to the goal machine.

Question 22. How To Define Transformation Rules In Hana?

Answer :

Using advanced replication settings, transformation policies are detailed to transfer facts from source tables throughout replication manner. For instance, setting rules to covert fields, fill vacant fields and pass information. These rules are dependent the use of advanced replication settings (transaction IUUC_REPL_CONT)

Hadoop Tutorial
Question 23. Explain The Role Of Transaction Manager And Session?

Answer :

SAP HANA transaction supervisor synchronizes database transactions maintaining the record of closed and open transactions. When a transaction is dedicated or rolled returned, the manager informs all of the energetic shops and engines about the movement so they can perform required actions in time.

SAP BPC Interview Questions
Question 24. How Is Sql Statement Processed In Sap Hana?

Answer :

Each SQL declaration in SAP HANA is finished inside the form of a transaction. Every time, a new consultation is allotted to a new transaction.

SAP BO Interview Questions
Question 25. Define Master-controller Job.?

Answer :

A Master-controller process is accountable to build database logging table inside the supply device. It similarly creates synonyms and new entries in SLT server admin when the desk hundreds / replicates.

SAP SRM Tutorial
Question 26. How Users Can Avoid Un-necessary Storage Of Logging Information?

Answer :

Pause the replication method and terminate the schema-associated jobs.

SAP Testing Interview Questions
Question 27. Is The Table Size In Source System And Sap Hana System Same?

Answer :

No

SAP BASIS Interview Questions
Question 28. When To Change The Number Of Data Transfer Jobs?

Answer :

The wide variety of information transfer jobs exchange when the preliminary loading speed or latency replication time isn't always up to speed. At the give up of the preliminary load, the wide variety of preliminary load jobs may be decreased.

SAP BPC Tutorial
Question 29. List The Merits And Demerits Of Using Row-based Tables.?

Answer :

Merits:

• No information approach may be faster than row-primarily based in case you need to research, method and retrieve one file at one time.
• Row-based totally tables are beneficial whilst there's particular demand of gaining access to complete record.
• It is preferred when the desk consists of less range of rows.
• This statistics garage and processing technique is simpler and powerful without any aggregations and fast looking.Demerits:
• The information retrieval and processing operations involve the entire row, despite the fact that all of the facts isn't always useful.

Question 30. List Advantages Of Column-primarily based Tables.?

Answer :

• Allows smoother parallel processing of facts as the facts in columns is saved vertically. Thus, to get right of entry to facts from a couple of columns, each operation can be allotted to a separate processor middle.
• Only unique columns need to be approached for Select query and any column may be used for indexing.
• Efficient operations considering maximum columns keep precise values and consequently, excessive compression charge.

Question 31. What Table Type Is Preferred In Sap Hana Administration: Column-primarily based Or Row-primarily based?

Answer :

Since analytic packages require huge aggregations and agile records processing, column-based totally tables are favored in SAP HANA as the facts in column is stored consequently, one after the alternative allowing faster and simpler clarity and retrieval. Thus, columnar storage is preferred on most OLAP (SQL) queries. On the contrary, row-based tables pressure users to read and get admission to all of the records in a row, despite the fact that you require records from few and/or unique columns.

SAP Testing Tutorial
Question 32. What Is The Main Sap Hana Database Component?

Answer :

Index Server consists of real records engines for records processing along with enter SQL and MDX statements and plays real transactions.

Question 33. Explain The Concept Of Persistence Layer.?

Answer :

The persistence layer in SAP HANA handles all logging operations and transactions for secured backup and statistics restoring. This layer manages records saved in both rows and columns and offers regular savepoints. Built on the concept of patience layer of SAP’s relational database, it ensures a success records restores.

Besides managing log information on the disk, HANA’s persistence layer lets in study and write records operations thru all garage interfaces.

SAP ABAP Interview Questions
Question 34. Define Modeling Studio In Sap Hana Administration.?

Answer :

Modeling Studio is an operational device in SAP HANA based on Eclipse improvement and management, which incorporates stay task advent.

• The SAP HANA Studio further builds improvement items and deploys them, to get admission to and adjust data fashions like HTML and JavaScript files.
• It additionally handles numerous facts offerings to carry out statistics enter from SAP warehouse and other associated databases.
• Responsible for scheduling data replication responsibilities.

Question 35. List The Different Compression Techniques In Hana?

Answer :

• Run-period encoding
• Cluster encoding
• Dictionary encoding

Question 36. Explain Slt

Answer :

SLT expands to SAP Landscape Transformation relating to cause –primarily based replication. SLT replication permits records switch from supply to goal, in which the supply can be SAP or non-SAP whilst the goal gadget has to be SAP HANA with HANA database. Users can accomplish data replication from multiple assets. The 3 replication strategies supported by way of HANA are:

• SLT
• SAP Business Objects Data Services (BODS)
• SAP HANA Direct Extractor Connection (DXC)

SAP BW Interview Questions
Question 37. What Is Latency?

Answer :

The time length to carry out records replication beginning from the source to the goal gadget is referred to as latency.

Question 38. What Are The Various Components Of Sap Hana Administration?

Answer :

• SAP HANA Studio
• SAP HANA Application Cloud
• SAP HANA Cloud
• Sap HANA DB The Sap Hana Training Videos and Certification Course can open the doorways to a stellar career for you.

Question 39. List Advantages Of Using Sap Hana Database.?

Answer :

• With the HANA technology, you may create gen-next programs giving powerful and green results within the digital economic system.
• By the use of unmarried statistics-in reminiscence, SAP HANA helps clean transaction process and fault-tolerant analytics
• Easy and easy operations the use of an open-supply, unified platform within the cloud
• High-degree Data Integration to get right of entry to huge quantities of facts
• Advanced gear for in-depth analysis of gift, past and the destiny.Interested in studying SAP HANA? Well, we have the comprehensive Sap Hana Course to present you a head start on your career.

Question forty. Explain Parallel Processing In Sap Hana?

Answer :

Using the columnar information garage technique, the workload in SAP HANA is divided vertically. The columnar technique permits linear searching and aggregation of information instead of -dimensional facts structure. If more than one column is to be processed, each assignment is assigned to various processor. Operations on one column are then collimated with the aid of column divisions processed via unique processors.

Hadoop Interview Questions