Interview Questions.

Q1. Mention What Is Latency?

Latency is noted the duration of time to replicate records from the source gadget to the target machine.

Q2. Define Master-controller Job.?

A Master-controller task is responsible to build database logging table within the supply system. It in addition creates synonyms and new entries in SLT server admin while the desk hundreds / replicates.

Q3. How Is Sql Statement Processed In Sap Hana?

Each SQL statement in SAP HANA is accomplished in the form of a transaction. Every time, a brand new consultation is allocated to a brand new transaction.

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

Since analytic programs require huge aggregations and agile information processing, column-based tables are preferred in SAP HANA because the records in column is saved therefore, one after the other permitting faster and easier readability and retrieval. Thus, columnar garage is favored on most OLAP (SQL) queries. On the opposite, row-primarily based tables force customers to study and access all the facts in a row, despite the fact that you require data from few and/or specific columns.

Q5. List Advantages Of Using Sap Hana Database.?

• With the HANA generation, you can create gen-next programs giving powerful and efficient consequences within the digital economic system.

• By the usage of unmarried statistics-in memory, SAP HANA supports easy transaction technique and fault-tolerant analytics

• Easy and simple operations using an open-supply, unified platform within the cloud

• High-level Data Integration to get admission to big amounts of facts

• Advanced tools for in-depth evaluation of gift, beyond and the destiny.Interested in studying SAP HANA? Well, we've the complete Sap Hana Course to offer you a head start to your profession.

Q6. What Is Logging Table?

Logging table information all replicated modifications in the table, which can be similarly replicated to the target gadget.

Q7. Define Modeling Studio In Sap Hana Administration.?

Modeling Studio is an operational device in SAP HANA primarily based on Eclipse improvement and administration, which includes stay task introduction.

• The SAP HANA Studio similarly builds improvement items and deploys them, to get entry to and alter statistics models like HTML and JavaScript files.

• It also handles various statistics services to perform statistics input from SAP warehouse and different associated databases.

• Responsible for scheduling information replication tasks.

Q8. Mention What Is The Role Of The Transaction Manager And Session?

The transaction manager co-ordinates database transactions and continues a file of going for walks and closed transactions. When transaction is rolled again or devoted, the transaction supervisor notifies the concerned garage engines about the event so that it will run vital moves.

Q9. Mention What Is The Role Of Master Controller Job In Sap Hana?

The process is arranged on call for and is accountable for

Creating database triggers and logging desk into the supply device

Creating Synonyms

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

Q10. Mention What Are The Different Compression Techniques?

There are three different compression techniques

Run-length encoding

Cluster encoding

Dictionary encoding

Q11. Explain How Sql Statement Is Processed?

In the HANA database, every SQL declaration is applied within the reference of the transaction. New session is allocated to a new transaction.

Q12. When To Change The Number Of Data Transfer Jobs?

The quantity of records switch jobs alternate while the initial loading speed or latency replication time is not up to the mark. At the give up of the preliminary load, the range of preliminary load jobs may be reduced.

Q13. List The Merits And Demerits Of Using Row-primarily based Tables.?

Merits:

• No records approach may be quicker than row-based totally if you want to analyze, process and retrieve one record at one time.

• Row-based tables are useful whilst there may be unique call for of getting access to entire file.

• It is desired while the table consists of much less range of rows.

• This information storage and processing method is simpler and effective with none aggregations and rapid looking.Demerits:

• The records retrieval and processing operations contain the entire row, despite the fact that all the information isn't useful.

Q14. How Users Can Avoid Un-essential Storage Of Logging Information?

Pause the replication system and terminate the schema-related jobs.

Q15. Define Different Types Of Information Views.?

There are by and large three sorts of records perspectives in SAP HANA, which are all non-materialized.

• Attribute view

• Analytic view

• Calculation View

Q16. List The Different Compression Techniques In Hana?

• Run-duration encoding

• Cluster encoding

• Dictionary encoding

Q17. Explain How You Can Avoid Un-important Information From Being Stored?

To avoid un-vital data from being stored, you have to pause the replication with the aid of preventing the schema-associated jobs

Q18. Mention What Is Modeling Studio?

Modeling studio in HANA performs more than one mission 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 statistics from SAP Business Warehouse and other structures

Manage ERP times connection, the modern release does not help connecting to numerous ERP times

Use facts offerings for the modeling

Do modeling in HANA itself

crucial licenses for SAP BO information offerings

Q19. What Are The Various Components Of Sap Hana Administration?

• SAP HANA Studio

• SAP HANA Application Cloud

• SAP HANA Cloud

• Sap HANA DB The Sap Hana Training Videos and Certification Course can open the doors to a stellar career for you.

Q20. How To Perform Backup And Recovery Operations?

During a normal operation, records is with the aid of default saved to the disk at savepoints in SAPHANA. As quickly a there's any update and transaction, logs emerge as energetic and get stored from the disk reminiscence. In case of strength failure, the database restarts like any other DB returning to the last savepoint log nation. SAP HANA calls for backup to shield towards disk failure and reset DB to the preceding nation. The backups concurrently because the customers keep acting their tasks.

Q21. How To Define Transformation Rules In Hana?

Using superior replication settings, transformation guidelines are distinct to switch facts from source tables for the duration of replication system. For example, setting rules to covert fields, fill vacant fields and bypass records. These policies are established using superior replication settings (transaction IUUC_REPL_CONT)

Q22. Mention What Is The Role Of The Persistence Layer In Sap Hana?

SAP HANA has an in-reminiscence computing engine and get admission to the information straightaway without any backup. To avoid the hazard of dropping records in case of hardware failure or electricity cutoff, patience layer comes as a savior and stores all the facts inside the hard pressure which isn't always risky.

Q23. Explain How You Can Avoid Un-essential Logging Information From Being Stored?

You can keep away from un-necessary logging records from being saved through pausing the replication by means of stopping the schema-associated jobs.

Q24. Explain The Concept Of Persistence Layer.?

The staying power layer in SAP HANA handles all logging operations and transactions for secured backup and records restoring. This layer manages records saved in both rows and columns and presents steady savepoints. Built on the idea of endurance layer of SAP’s relational database, it ensures successful data restores.

Besides handling log data at the disk, HANA’s staying power layer lets in examine and write facts operations through all garage interfaces.

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

The two kinds of relational records stored in HANA includes

Row Store

Column Store

Q26. What Are Configuration And Monitoring Dashboard?

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

Q27. Mention What Is Sap Hana?

SAP HANA stands for High Performance Analytical Appliance- in-reminiscence computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication server control and cargo control.

Q28. List Advantages Of Column-primarily based Tables.?

• Allows smoother parallel processing of records as the data in columns is saved vertically. Thus, to access facts from a couple of columns, every operation can be allocated to a separate processor center.

• Only unique columns want to be approached for Select question and any column can be used for indexing.

• Efficient operations on the grounds that most columns hold unique values and consequently, excessive compression price.

Q29. Explain What Happens If The Replication Is Suspended For A Longer Period Of Time Or System Outage Of Slt Or Hana System?

If the replication is suspended for a longer period of time, the scale of the logging tables will increase.

Q30. Explain What Is Transformation Rules?

Transformation rule is the rule of thumb detailed in the superior replication setting transaction for the supply table such that statistics is transformed in the course of the replication process.

Q31. Mention What Is The Advantage Of Slt Replication?

SAP SLT works on cause based technique; such approach has no measurable overall performance impact inside the supply machine

It gives filtering functionality and transformation

It allows real-time facts replication, replicating simplest related information into HANA from non-SAP and SAP source systems

It is completely incorporated with HANA studios

Replication from several source systems to 1 HANA machine is authorized, additionally from one supply system to a couple of HANA systems is authorized.

Q32. Define Slt Configuration?

Configuration is the meaningful information to establish a connection between supply, SLT system and SAP HANA structure as said within the SLT gadget. Programmers are allowed to illustrate a brand new Configuration in Configuration and Monitoring Dashboard.

Q33. Name Various Components Of Sap Hana?

SAP HANA DB

SAP HANA Studio

SAP HANA Appliance

SAP HANA Application Cloud

Q34. Is The Table Size In Source System And Sap Hana System Same?

No

Q35. Explain Slt

SLT expands to SAP Landscape Transformation relating to cause –primarily based replication. SLT replication lets in records switch from supply to target, where the source can be SAP or non-SAP while the goal system must be SAP HANA with HANA database. Users can accomplish records replication from more than one sources. The 3 replication strategies supported by using HANA are:

• SLT

• SAP Business Objects Data Services (BODS)

• SAP HANA Direct Extractor Connection (DXC)

Q36. What Is The Main Sap Hana Database Component?

Index Server includes real information engines for statistics processing which include enter SQL and MDX statements and performs real transactions.

Q37. Explain Parallel Processing In Sap Hana?

Using the columnar data storage approach, the workload in SAP HANA is divided vertically. The columnar method permits linear searching and aggregation of facts as opposed to two-dimensional data shape. If more than one column is to be processed, each challenge is assigned to various processor. Operations on one column are then collimated via column divisions processed by means of one of a kind processors.

Q38. What Is Latency?

The time period to perform facts replication beginning from the supply to the target gadget is referred to as latency.

Q39. What Is Stall?

The ready process for records to load from the main memory to the CPU cache is known as Stall.

Q40. Explain The Role Of Transaction Manager And Session?

SAP HANA transaction supervisor synchronizes database transactions keeping the report of closed and open transactions. When a transaction is committed or rolled lower back, the manager informs all the active shops and engines about the action in an effort to carry out required actions in time.