Interview Questions.

Q1. What Is The Role Of Persistence Layer?

It ensures that the database is restored to the maximum recent committed country after a restart and that transactions are either absolutely performed or absolutely undone. The patience layer gives interfaces for writing and studying information. It also includes SAP HANA‘s logger that manages the transaction lo.  Log entries can be written implicitly by way of the persistence layer while records is written thru the persistence interface or explicitly by means of the use of a log interface.

Q2. What Is Derived Attribute Views?

In a few business cases, it is required to use the identical characteristic view greater than once.

In such cases, you can still derive an attribute view using the base view which acts as reference to the bottom characteristic view. The derived attribute view could be opened in the read-handiest mode. The only editable subject will be its description. The derived characteristic view will act as a reference to its base characteristic view.

Q3. For What Life Cycle Management Perspective Is Used?

We use Life cycle control attitude to Upgrade/Updates for HANA studio.

Q4. What Are The Advantages Of Column Based Tables And Row-based Tables?

Advantages of Column based tables:

Calculations are generally completed on unmarried or some columns simplest.

The table is searched primarily based on values of some columns.

The desk has a large number of columns.

The desk has a big range of rows and columnar operations are required (mixture, experiment, and so forth.).

High compression costs can be carried out because most of the people of the columns comprise just a few wonderful values (compared to some of rows).

Advantages of Row-based tables:

The application wishes to simplest procedure a unmarried record at one time (many selects and/or updates of unmarried information).

The utility normally desires to get entry to a complete report (or row).

The columns include mainly wonderful values so that the compression fee would be low.

Neither aggregations nor fast looking is required.

The desk has a small wide variety of rows (e. G. Configuration tables).

Q5. What Is The Operating System Of Imdb?

SUSE Linux Enterprise Server.

Q6. How Can We Load Data In Hana And How To Access The Data Stored In Hana?

Loading records:  There are several alternatives to be had to get facts into HANA. SAP affords a actual-time replication server known as SLT Replication. With this server you could replicate facts from a SAP gadget or non-SAP RDBMS systems into HANA. The statistics is copied in its local format and will then want to be de-normalized on HANA the usage of data perspectives (attribute perspectives, analytic perspectives and calculation views). According to the documentation, you can also leverage the Sybase Replication Server for log based replication. In addition, Data Services four.0 may be used to transport information into HANA and may replace data at close to actual time if wished.  Data Services four.Zero can also de-normalize the data given its abundance of information transforms and offer records high-quality and cleaning transforms with a view to help smooth the records before it's far loaded into HANA.

Access the statistics:  There are numerous ways to get entry to the facts inside HANA. The best way to get right of entry to facts is thru SAP Business Objects 4.@There are a couple of equipment within the Business Objects 4.Zero platform for accessing HANA information. You can utilize Web Intelligence, Crystal Reports, Explorer, “Analysis Edition for Microsoft Office”, Mobile and Dashboard (Xcelsius). In quick, any tool in the platform that helps ODBC or a Universe can be applied to get right of entry to facts within HANA. These options paintings for SAP BW (powered through HANA) or for HANA (Standalone). If you've got SAP BW powered through HANA, you may make use of any of the conventional query equipment. For those who like viewing raw data outcomes, you can make use of HANA Studios to execute SQL statements and look at the outcomes.

Q7. What Is The Component Present In Persistence Layer In The Hana Db?

The factor found in Persistence layer in the HANA DB is Page management & Logger.

Q8. Do We Need A Special Driver To Access Data Within Hana?

HANA gives both a 32-bit and 64-bit ODBC and JDBC drivers. SAP Business Objects 4.0, Data Services 4.Zero and plenty of other SAP based equipment have integrated support for those drivers to assist guide all the capabilities HANA has to provide.

Q9. Which Non-sap System Can Sap Hana Connect?

Oracle Enterprise, IBM Informix.

Q10. What Are The Views Available In The Quick Launch Of Information Modeler?

Navigator, Where-used list, Job log, Properties.

Q11. What Is Sap Hana Modeling?

SAP HANA Modeling at a look:

SAP HANA Information Modeling which also known as SAP HANA Data Modeling is the coronary heart of HANA utility improvement. You can create modeling views on top of database tables and enforce business common sense to create a significant report.

Q12. Which Section Controls The Data Processing In The Hana Db?

Transaction Manager controls the information processing in the HANA DB.

Q13. Why We Need To Go For Going In-reminiscence?

One motive is the variety of CPU cycles in keeping with second is increasing and the price of processors is lowering. For handling the information in memory, there is 5-minute rule that is primarily based at the inspiration that it expenses more to watch for the statistics to be fetched from disk than it charges to keep information in memory so it depends on how often you fetch the facts.

For example: there may be a desk and regardless of how big it's miles and this table is touched with the aid of a query as a minimum as soon as each fifty five mins, it's miles less costly (in hardware fees) to preserve it in memory than to study it from memory and if it is frequently accessed it's far less costly to save it in memory.

Q14. What Are The Types Of Joins Are Possible In Attribute View?

Referential be part of

Inner be a part of

Outer be a part of

Q15. How Can You Ensure That Data Is Consistent In Source System And Hana System?

Since any modifications in the source gadget are tracked in committed logging tables, the replication fame for each modified facts report is obvious. An entry of logging table is deleted after a a hit dedicate announcement from HANA database and this process ensures the facts consistency between a source gadget and HANA gadget.

Q16. What Are The Benefits Of Implementing Sap Hana With Sap Erp?

Performance optimization for operational reporting.

Processing of huge volumes of information.

Provision of actual-time analytics.

Q17. What Does Hana Db Performs During Power Outage?

Recovers log between ultimate information keep point & time of failure.

Q18. Opd For Data Replication Api Is Used In Which Replication?

Data offerings four.Zero.

Q19. Which Is The Default Perspective Of Imce Studio?

Administrator console

Q20. Name The Editions Of Sap Hana Software?

Platform version.

Enterprise version.

Enterprise extended edition.