Interview Questions.

Q1. What Are The Supported Platforms For Hana Studio?

The SAP HANA studio runs on the Eclipse platform three.6.

We can use the SAP HANA studio on the subsequent structures:

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

SUSE Linux Enterprise Server SLES 11: x86 sixty four-bit model

Note : For Mac OS, HANA studio is available however there may be no HANA customer for that.

Q2. How To Secure A Sap Hana User Connexion?

A Sap Hana database consumer is included inside the first place with a password. However, a password could be very often required at the command line so as to connect and execute a batch or an SQL script. The username and password are then visible to anyone. In order to avoid that scenario, it's miles possible to create a special key on the subject of a specific user. Username and password are then invisible via the usage of that key.

Q3. What Are The Various Tasks In The Sap Hana Which Are Performed By The Modeling Studio?

The first actual undertaking it perform is selecting the sort of tables which might be to be stored inside the HANA. The choice of Meta data is likewise the obligation of the modeling studio. All the statistics services for entering the facts from warehouse or different vicinity are treated through it. It simply manages the ERP instances connections. The entire statistics services can be used for modeling simplest through the modeling studio. Any sort of other modeling inside the SAP HANA itself is handled by the studio. Moreover the responsibilities associated with the encoding are also controlled and managed through the modeling studio.

Q4. What Are System Requirements For Sap Hana?

Java JRE 1.6 or 1.7 need to be installed to run the SAP HANA studio. The Java runtime ought to be particular within the PATH variable. Make positive to pick the ideal Java variation for installation of SAP HANA studio:

32-bit installation, pick out a 32-bit Java variant.

For a sixty four-bit set up, select a sixty four-bit Java variant.

Q5. 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 instances the customers must cope with the data that isn't relevant with any task. Generally, it could motive gradual data processing speeds and might have an effect on accuracy and reliability upto a excessive volume. The customers are loose to brief stop the replication and this could avoid the problem of storing any undesirable statistics or facts in the machine. To disable replication temporarily, the customers simply need to forestall the schema related jobs within the system. 

Q6. Explain What Is Schema Mapping In Sap Hana ?

Schema mapping is finished whilst the bodily schema within the target device isn't the same as the physical schema in the supply device. As stated in advance, assume we are transferring additives from Development System (DEV) to Production System (PROD).

The tables in DEV are living in DEV_SCHEMA and the same tables reside in PROD machine in PROD_SCHEMA schema. If an characteristic view is transported from DEV to PROD, it's going to not paintings because the schema name is referenced in the definition of characteristic view. In order for the promoted items to paintings in PROD, schema mapping wishes to be installation within the target device.

Q7. Tell Something You Know About Normalization And De-normalization?

Normalization is not anything but the procedure this is adopted for the reason or casting off the redundant records from the database. This is usually done through splitting the desk into specific sections. This in reality makes positive of integrity. On the opposite side, the de-normalization is the technique of considering the redundant information so that each one the queries which might be complicated can be greater in phrases of average overall performance. 

Q8. Why To Configure Import Server In Sap Hana ?

In order to load records from outside assets to SAP HANA we need to establish a connection with the server. To connect, we need to offer information of Business Objects Data Services repository and ODBC drivers. Once the relationship is established, we will import the tables definition and then load statistics into table definition.

Q9. What Is Sap Hana Studio?

The SAP HANA studio is an Eclipse-primarily based development and management tool for operating with HANA.

It permits technical customers to control the SAP HANA database, to create and manage person authorizations, to create new or alter present models of statistics etc.

It is a patron device, which can be used to get admission to local or far flung HANA system.

Q10. What Sort Of Advantages Do Businesses Have With Effective Database Management?

By facts handling the users are free to derive outcomes that may be taken into consideration for the longer term

A lot of difficulties related to statistics may be prevented without difficulty

The facts can be controlled in sections and may be accessed without difficulty

Well controlled records is useful in designing reports, preparing documents and assisting diverse departments in different responsibilities.

Q11. What Is A Delivery Unit In Sap Hana?

Delivery unit (DU) is a box utilized by the Life Cycle Manager (LCM) to move repository gadgets among the SAP HANA systems.

The call of Delivery Unit have to contain simplest capital letters (A-Z), digits (zero-nine) and underscores (_).

Q12. What Are The Advantages Of Attribute View?

Attribute View act as Master facts context, which affords Text or Description for Key/Non-key field.

Attribute View can be reuse in Analytic View and Calculation View.

Attributes View is used to pick out a subset of columns and rows from a database table.

Attributes (fields) can be calculated from a couple of table fields.

There isn't any measure and aggregation option.

Q13. What Are The Benefits That Sql Can Bring For You?

If the queries within the SQL are simple, the customers are free to retrieve a completely massive sum of records very without difficulty from the device. Another accurate thing approximately SQL is it's far very clean to research and enforce. There is a significant aid to be had for SQL and all the queries may be addressed reliably. Using SQL, the database can be controlled very easily and actually with out considering a big quantity of coding.

Q14. Explain Parallel Processing In Sap Hana?

Using the columnar facts storage approach, the workload in SAP HANA is divided vertically.

The columnar technique permits linear looking and aggregation of statistics as opposed to two-dimensional information structure.

If multiple column is to be processed, each task is assigned to diverse processor.

Operations on one column are then collimated with the aid of column divisions processed by means of one of a kind processors.

Q15. What Is A Restricted User In Sap Hana System?

Restricted customers are those customers who get entry to HANA gadget with some programs and that they don’t have SQL privileges on HANA gadget. When those customers are created they don’t have any access initially.

Q16. Which Engine Is Used To Create Analytic View?

OLAP Engine :

This engine can be referred to as in the backend each time we run any queries on Analytic Views in SAP HANA.

If there are no extra calculations executed like calculated columns, restricted measures and counters, then the entirety may 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 may be converted into ‘BwPopJoin’ that's part of OLAP Engine.

If there are any calculations present, to be achieved then Calculation engine could be used at the side of OLAP Engine.

Q17. Can You Tell Some Important Benefits That Users Can Have From The Slt Replication In Sap Hana?

It is essentially an technique that has been categorized as induced one i.E. Users need now not to fear approximately the overall effect of performance at the supply system. The customers can truly make certain of filtering, as well as transformation of the statistics although the size is cumbersome. In addition to this, actual-time information replication also can be confident via the users.  It is possible for the customers to truly ensure of multiple supply systems to most effective one device based totally on HANA. The opposite action is likewise feasible. 

Q18. Can You Tell Something About The Role Of Transaction Manager And Session In Sap Hana?

All the database transactions may be co-ordinated virtually with the transaction supervisor and the users are loose to preserve a near eye at the closed as well as on the strolling transactions. The transactions are notified to the customers whilst they are rolled backed or whilst they are dedicated. This makes certain of the clean going for walks of the storage engines.

Q19. What Are The Different License Keys Types In Hana System? What Is Their Validity?

Temporary License key

Permanent License Key

Temporary License key:

Temporary License keys are robotically installed when you install the HANA database.

These keys are legitimate simplest for ninety days and you have to request everlasting license keys from SAP market area earlier than expiry of this 90 days length after set up.

Permanent License Key:

Permanent License keys are valid until the predefine expiration date.

License keys specify amount of reminiscence licensed to target HANA installation.

Q20. Why There Is Actually A Need For The Businesses To Invest In A Rdbms Tool In The Present Time?

Managing the information could be very essential. In the prevailing time, data plays an exceptional role within the success of just about each commercial enterprise. Data enables in choice making, collaborations, start new ventures, tackling opposition, improving first-class and so on. There are a huge range of other motives as well which are mandatory for the commercial enterprise to get it carried out in a right way. Thus management of information is important.

Q21. Which Engine Is Used To Create Attribute View?

Join engine is used to create attribute view

This engine is used while we execute any Attribute View in HANA or run local SQL on multiple desk with be part of circumstance.

If there are any calculations concerned both in Attribute View or in local SQL then Join Engine will use Calculation Engine for calculations or fetch the result.

Q22. What Is Calculation View With Star Join?

Calculation View with Star Join :

It does not permit base column tables, Attribute Views or Analytic perspectives to add at statistics foundation.

All Dimension tables should be changed to Dimension Calculation views to use in Star Join.

All Fact tables may be added and might use default nodes in Calculation View.

Q23. What Are The Different Types Of Nodes In Calculation View?

Different forms of nodes, they're:

Join: This node is used to sign up for two source items and bypass the end result to the next node. The be part of sorts may be internal, left outer, right outer and textual content be a part of.Note: We can handiest add two source items to a join node.

Union: This is used to carry out union all operation between multiple assets. The supply may be n number of objects.

Projection: This is used to pick columns, filter out the information and create additional columns earlier than we use it in subsequent nodes like a union, aggregation and rank.

Aggregation: This is used to perform aggregation on precise columns primarily based on the chosen attributes.

Rank: This is the exact replacement for RANK characteristic in SQL. We can outline the partition and order through clause based on the requirement.

Q24. What Is Schema In Sap Hana?

There are three styles of schemas:

User Defined Schema

System Defined Schema

SLT Derived Schema

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

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

System Defined Schema : These schemas are introduced with the SAP HANA database and comprise    HANA gadget statistics. There are machine schemas like _SYS_BIC, _SYS_BI, _SYS_REPO,_SYS_STATISTICS etc.

A database schema is a manner to logically institution gadgets such as tables, perspectives, stored strategies and many others.

Q25. What Are The Different Perspectives Available In Hana?

Modeler : used for creating numerous kinds of perspectives and analytical privileges.

SAP HANA Development: Used for programming applications for developing development items to access or replace facts fashions together with Server-side Java script or HTML files.

Administration : Used to display the device and change settings.

Debug: Used to debug code such as SQLScript (.Process documents) or Server-aspect Java script (.Xsjs documents).

Q26. What Do You Know About The Master Controller Job In The Hana?

It is a controller that may be deployed for diverse motives and functions. It really makes certain of creating logging tables and triggers the identical in the gadget.  The synonyms also can be created with the help of grasp controller. Also, the new entries inside the administration tables may be made with the help of this technique. The entire table can also be loaded with this approach.

Q27. What Are The Types Of Calculation View?

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

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

Q28. What Are The Supported Object Types In Modeler Perspective?

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

Q29. What Is Sap Hana 1.5, 1.2 Or 1.0 Sp03?

They are all the same factor, and 1.0 SP03 is touted to be the final name which need to go into Ramp Up (beta) in Q4 201@This allows any SAP Net Weaver BW 7.3 Data Warehouse to be migrated into a HANA appliance. HANA 1.0 SP03 mainly additionally quickens BW calculations and planning, which means that even more overall performance gains can be attained.

Q30. Organizations Have To Spend A Very Large Amount Of Money Every Year On Database Management, Are You Agree With This?

Yes, that is totally proper. However, it largely relies upon at the manner a customers is coping with this approach. Basically, statistics control is a complicated technique and there are quite a few tasks that are truely very vital. Managing the database with out an powerful device is a big undertaking. If an company can keep in mind a effective device like SAP HANA, plenty of responsibilities may be made truly and a ton of favorable consequences can be derived genuinely.

Q31. What Exactly Is The Significance Of Persistence Layer In Sap Hana?

It is in reality an crucial later in SAP HANA which plays a completely essential position. Actually, HANA has a computing engine built inside and the users have to utilize the facts without delay with out taking any backup. The identical can create an problem all through effective failure and for this reason it's miles necessary to preserve a backup of the equal. This layer comes as a savior and it ensure no loss of facts in the course of one of these situation.

Q32. Which Engine Is Used To Create Calculation View?

SQL Engine which is likewise known as SQL Parser/interface is used for all kinds of SQL statements generated by means of frontend utility thru exceptional distinct clients and additionally for native square run at database stage.

From SAP HANA SP7, we've got an alternative for Calculation Views in ‘Properties’ section, wherein we've got an option to choose calculation view to run in ‘SQL Engine’. Advantage of this selection is that, instead of shifting records among more than one engines HANA executes the whole script in SQL Engine to get the very last end result.

Q33. What Is The Best Way To Manage, Operate, And Monitor Sap Hana Systems?

Sap Hana is a young database with thrilling capabilities of SAP HANA. First of all Sap Hana is an in-reminiscence database. It is accessible for management through diverse channels. Directly from the Server, It is not the maximum handy approach however you can use hdbsql to control databases. With the internet-based totally interface Hana cockpit, you could browse and manage sap hana environments. The Client Hana Studio is the whole tool to manage Sap Hana but it must be physically installed and consequently is depending on the client hardware.

Q34. What Are The Properties Of Analytic View?

Following are the residences of SAP HANA Analytic View :

Analytic Views are used to perform complicated calculations and Aggregate features like Sum, Count, Min, Max, Etc.

Analytic Views are designed to run Start schema queries.

Each Analytic View has one Fact table surrounded via multiple size tables. Fact table carries primary key for every Dim table and measures.

Analytic Views are much like Info Objects and Info sets of SAP BW.

Q35. Can We Call An Analytic View Or Calculation View Inside Another Calculation View In Sap Hana ?

Yes. We can call all of the views (characteristic, analytic and calculation view) interior a calculation view.

Note: Calculation perspectives are composite perspectives and can be used to mix different perspectives.

It can eat different Analytical, Attribute, different Calculation Views & tables.

It can carry out complicated calculations not possible with other views.

Q36. What Is The Difference Between Catalog And Content Tab?

Catalog: This contains RDBMS items like schemas, tables, perspectives, tactics, and so forth.

You can open SQL editor and design database objects.

Content tab: This is used to hold design time repository. You can create new applications and layout Information perspectives in HANA system. Various views may be created underneath content tab to fulfill commercial enterprise requirement and to perform analytical reports on the top of the Modeling perspectives.

Q37. Explain The Column And Row Store In Hana?

HANA supports both sort of statistics save in database.

Row keep is used when you want to use Select declaration and no aggregations are performed.

Column keep is used to perform aggregations and HANA Modeling is supported only on Column based tables.

Q38. What Are The Characteristic Of Sap Hana Calculation View?

Support Complex Calculation.

Support OLTP and OLAP fashions.

Support Client dealing with, language, foreign money conversion.

Support Union, Projection, Aggregation, Rank, etc.