Interview Questions.

Question 1. What Is Sap Hana Studio?

Answer :

The SAP HANA studio is an Eclipse-primarily based development and administration tool for operating with HANA.
It permits technical users to manage the SAP HANA database, to create and manipulate user authorizations, to create new or alter existing models of facts etc.
It is a purchaser device, which can be used to get admission to local or remote HANA device.
Question 2. What Are The Supported Platforms For Hana Studio?

Answer :

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

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

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

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

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

SAP BI Interview Questions
Question 3. What Is Sap Hana 1.5, 1.2 Or 1.0 Sp03?

Answer :

They are all of the equal thing, and 1.Zero SP03 is touted to be the very last name which should move into Ramp Up (beta) in Q4 2011. This lets in any SAP Net Weaver BW 7.Three Data Warehouse to be migrated right into a HANA equipment. HANA 1.0 SP03 especially also hastens BW calculations and planning, this means that even more overall performance gains may be attained.

Question four. What Is A Restricted User In Sap Hana System?

Answer :

Restricted customers are the ones customers who get admission to HANA machine with a few programs and they don’t have SQL privileges on HANA gadget. When those customers are created they don’t have any get admission to first of all.

SAP BI Tutorial
Question five. What Is Schema In Sap Hana?

Answer :

There are 3 forms of schemas:

User Defined Schema
System Defined Schema
SLT Derived Schema
User Defined Schema : These are created with the aid of consumer (DBA or System Administrator

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

System Defined Schema : These schemas are added with the SAP HANA database and contain    HANA system records. There are machine schemas like _SYS_BIC, _SYS_BI, _SYS_REPO,_SYS_STATISTICS and so forth.

A database schema is a way to logically organization gadgets including tables, perspectives, saved approaches etc.

SAP BO Interview Questions
Question 6. Explain What Is Schema Mapping In Sap Hana ?

Answer :

Schema mapping is done whilst the physical schema inside the target gadget is not the same as the bodily schema inside the source gadget. As mentioned earlier, think we are moving components from Development System (DEV) to Production System (PROD).

The tables in DEV live in DEV_SCHEMA and the identical tables reside in PROD system in PROD_SCHEMA schema. If an attribute view is transported from DEV to PROD, it'll now not work because the schema name is referenced within the definition of attribute view. In order for the promoted objects to work in PROD, schema mapping wishes to be installation within the goal gadget.

Question 7. What Are System Requirements For Sap Hana?

Answer :

Java JRE 1.6 or 1.7 need to be mounted to run the SAP HANA studio. The Java runtime ought to be distinct inside the PATH variable. Make sure to pick out the ideal Java variant for set up of SAP HANA studio:

32-bit set up, pick out a 32-bit Java variant.

For a sixty four-bit installation, pick out a 64-bit Java variation.

SAP BO Tutorial SAP BASIS Interview Questions
Question eight. What Is A Delivery Unit In Sap Hana?

Answer :

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

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

Question nine. Why To Configure Import Server In Sap Hana ?

Answer :

In order to load facts from external assets to SAP HANA we need to establish a connection with the server. To connect, we need to provide info of Business Objects Data Services repository and ODBC drivers. Once the relationship is set up, we will import the tables definition after which load statistics into table definition.

SAP HANA Interview Questions
Question 10. Explain The Column And Row Store In Hana?

Answer :

HANA helps each form of statistics save in database.
Row store is used when you want to apply Select statement and no aggregations are finished.
Column keep is used to carry out aggregations and HANA Modeling is supported handiest on Column primarily based tables.
SAP BASIS Tutorial
Question 11. What Are The Different License Keys Types In Hana System? What Is Their Validity?

Answer :

Temporary License key
Permanent License Key
Temporary License key:

Temporary License keys are routinely installed while you installation the HANA database.
These keys are legitimate best for ninety days and also you have to request permanent license keys from SAP marketplace region earlier than expiry of this 90 days period after installation.
Permanent License Key:

Permanent License keys are legitimate until the predefine expiration date.
License keys specify amount of memory licensed to target HANA installation.
SAP HANA BI Development Interview Questions
Question 12. What Is The Difference Between Catalog And Content Tab?

Answer :

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

You can open SQL editor and design database items.

Content tab: This is used to hold layout time repository. You can create new packages and design Information perspectives in HANA device. Various perspectives can be created under content material tab to satisfy business requirement and to carry out analytical reports at the pinnacle of the Modeling perspectives.

SAP BI Interview Questions
Question 13. What Are The Different Perspectives Available In Hana?

Answer :

Modeler : used for developing numerous styles of perspectives and analytical privileges.

SAP HANA Development: Used for programming applications for developing improvement items to get entry to or replace information models inclusive of Server-aspect Java script or HTML documents.

Administration : Used to screen the system and change settings.

Debug: Used to debug code inclusive of SQLScript (.System files) or Server-facet Java script (.Xsjs documents).

SAP HANA Tutorial
Question 14. What Are The Supported Object Types In Modeler Perspective?

Answer :

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

Question 15. Explain Parallel Processing In Sap Hana?

Answer :

Using the columnar facts storage approach, the workload in SAP HANA is divided vertically.
The columnar technique lets in linear looking and aggregation of data instead of two-dimensional information shape.
If a couple of column is to be processed, each task is assigned to various processor.
Operations on one column are then collimated through column divisions processed with the aid of distinctive processors.
Sap Hana Modeling Interview Questions
Question 16. What Are The Advantages Of Attribute View?

Answer :

Attribute View act as Master records context, which presents Text or Description for Key/Non-key discipline.
Attribute View can be reuse in Analytic View and Calculation View.
Attributes View is used to pick 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 degree and aggregation option.
Question 17. Which Engine Is Used To Create Attribute View?

Answer :

Join engine is used to create attribute view
This engine is used whilst we execute any Attribute View in HANA or run local SQL on a couple of desk with be a part of situation.
If there are any calculations worried both in Attribute View or in native SQL then Join Engine will use Calculation Engine for calculations or fetch the end result.
Sap Hana Vora Interview Questions
Question 18. What Are The Characteristic Of Sap Hana Calculation View?

Answer :

Support Complex Calculation.
Support OLTP and OLAP fashions.
Support Client handling, language, foreign money conversion.
Support Union, Projection, Aggregation, Rank, etc.
SAP BO Interview Questions
Question 19. What Are The Types Of Calculation View?

Answer :

SAP HANA Graphical Calculation View (Created with the aid of SAP HANA Studio Graphical editor).

SAP HANA Script-based totally calculations Views (Created with the aid of SQL Scripts by using SAP HANA Studio).

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

Answer :

Different varieties of nodes, they are:

Join: This node is used to enroll in  supply gadgets and pass the end result to the following node. The be part of sorts may be inner, left outer, proper outer and textual content join.Note: We can only upload two source items to a be a part of node.

Union: This is used to carry out union all operation between more than one resources. The supply may be n wide variety of objects.

Projection: This is used to pick out columns, clear out the records and create additional columns before we use it in subsequent nodes like a union, aggregation and rank.

Aggregation: This is used to carry out aggregation on precise columns based on the chosen attributes.

Rank: This is the precise replacement for RANK characteristic in SQL. We can define the partition and order with the aid of clause based at the requirement.

Sap Hana Xsjs Interview Questions
Question 21. What Is Calculation View With Star Join?

Answer :

Calculation View with Star Join :

It does now not permit base column tables, Attribute Views or Analytic views to feature at records basis.
All Dimension tables need to be modified to Dimension Calculation views to apply in Star Join.
All Fact tables may be added and can use default nodes in Calculation View.
Question 22. Can We Call An Analytic View Or Calculation View Inside Another Calculation View In Sap Hana ?

Answer :

Yes. We can name all of the perspectives (attribute, analytic and calculation view) inside a calculation view.

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

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

It can carry out complicated calculations now not viable with other perspectives.

Question 23. Which Engine Is Used To Create Calculation View?

Answer :

SQL Engine which is likewise called SQL Parser/interface is used for all types of SQL statements generated through frontend software through specific distinct clients and also for local square run at database degree.

From SAP HANA SP7, we've got an alternative for Calculation Views in ‘Properties’ section, where we've an option to pick out calculation view to run in ‘SQL Engine’. Advantage of this feature is that, in preference to moving records between multiple engines HANA executes the entire script in SQL Engine to get the final result.

Sap Hana Sql Script Interview Questions
Question 24. What Are The Properties Of Analytic View?

Answer :

Following are the houses of SAP HANA Analytic View :

Analytic Views are used to carry out 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 desk surrounded with the aid of more than one dimension tables. Fact desk contains number one key for every Dim desk and measures.
Analytic Views are just like Info Objects and Info sets of SAP BW.
SAP BASIS Interview Questions
Question 25. Which Engine Is Used To Create Analytic View?

Answer :

OLAP Engine :

This engine could be referred to as in the backend every time we run any queries on Analytic Views in SAP HANA.
If there are not any additional calculations accomplished like calculated columns, restricted measures and counters, then the entirety will be processed in OLAP Engine.
OLAP Engine acts as be a part of engine for the ones Attribute Views used in Analytic Views, with none calculated columns
All the be part of engine work could be converted into ‘BwPopJoin’ that's a part of OLAP Engine.
If there are any calculations present, to be completed then Calculation engine may be used along with OLAP Engine.
Question 26. Tell Something You Know About Normalization And De-normalization?

Answer :

Normalization is nothing but the manner that is followed for the purpose or putting off the redundant statistics from the database. This is usually executed with the aid of splitting the desk into specific sections. This definitely makes certain of integrity. On the alternative aspect, the de-normalization is the process of thinking about the redundant records so that each one the queries that are complex may be more suitable in phrases of basic performance. 

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

Answer :

Yes, this is absolutely proper. However, it in large part relies upon on the way a users is dealing with this approach. Basically, information control is a complex approach and there are quite a few responsibilities which are genuinely very crucial. Managing the database with out an effective device is a large venture. If an organization can recollect a powerful tool like SAP HANA, quite a few tasks may be made truly and a ton of favorable outcomes can be derived actually.

SAP HANA Interview Questions
Question 28. Why There Is Actually A Need For The Businesses To Invest In A Rdbms Tool In The Present Time?

Answer :

Managing the information is very critical. In the present time, information plays an awesome function in the fulfillment of just about every commercial enterprise. Data helps in decision making, collaborations, start new ventures, tackling competition, enhancing pleasant and so on. There are a big variety of other motives as properly which are mandatory for the business to get it performed in a proper manner. Thus control of statistics is important.

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

Answer :

By information dealing with the users are free to derive results that can be taken into consideration for the longer term
A lot of difficulties related to statistics can be prevented without problems
The statistics can be controlled in sections and may be accessed easily
Well controlled statistics is beneficial in designing reports, preparing files and supporting diverse departments in other duties.
Question 30. What Are The Various Tasks In The Sap Hana Which Are Performed By The Modeling Studio?

Answer :

The first actual undertaking it perform is selecting the form of tables which can be to be saved inside the HANA. The choice of Meta information is also the duty of the modeling studio. All the information offerings for entering the records from warehouse or different region are dealt with with the aid of it. It genuinely manages the ERP times connections. The complete facts offerings may be used for modeling handiest through the modeling studio. Any sort of other modeling within the SAP HANA itself is dealt with by means of the studio. Moreover the tasks related to the encoding also are managed and controlled through the modeling studio.

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

Answer :

It is basically an technique that has been categorised as triggered one i.E. Customers want no longer to fear approximately the general impact of overall performance at the supply gadget. The customers can truely make certain of filtering, in addition to transformation of the facts even if the dimensions is cumbersome. In addition to this, real-time records replication also can be assured by using the customers.  It is feasible for the customers to honestly make certain of multiple source systems to best one device based on HANA. The reverse action is also feasible. 

Question 32. What Problems Can Unnecessary Information Can Cause In The Sap Hana And How You Can Avoid The Same From Being Stored In The Application?

Answer :

Many instances the customers have to address the statistics that is not relevant with any undertaking. Generally, it can motive slow statistics processing speeds and may affect accuracy and reliability upto a high extent. The users are unfastened to transient forestall the replication and this may keep away from the problem of storing any unwanted statistics or records within the device. To disable replication temporarily, the customers simply ought to prevent the schema associated jobs in the system. 

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

Answer :

It is a controller that can be deployed for numerous reasons and purposes. It clearly makes sure of making logging tables and triggers the equal within the system.  The synonyms also can be created with the assist of master controller. Also, the new entries in the administration tables can be made with the assist of this method. The entire table also can be loaded with this method.

SAP HANA BI Development Interview Questions
Question 34. Can You Tell Something About The Role Of Transaction Manager And Session In Sap Hana?

Answer :

All the database transactions can be co-ordinated simply with the transaction manager and the customers are unfastened to keep a near eye on the closed in addition to at the going for walks transactions. The transactions are notified to the users when they are rolled backed or when they're committed. This makes certain of the easy walking of the storage engines.

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

Answer :

Sap Hana is a young database with exciting features of SAP HANA. First of all Sap Hana is an in-memory database. It is out there for administration through diverse channels. Directly from the Server, It is not the most handy method however you may use hdbsql to manipulate databases. With the net-based interface Hana cockpit, you could browse and manipulate sap hana environments. The Client Hana Studio is the whole tool to manage Sap Hana however it has to be bodily mounted and consequently is dependent on the customer hardware.

Question 36. How To Secure A Sap Hana User Connexion?

Answer :

A Sap Hana database user is included within the first region with a password. However, a password could be very often required on the command line with a purpose to join and execute a batch or an SQL script. The username and password are then visible to all people. In order to avoid that scenario, it's miles possible to create a unique key in terms of a specific person. Username and password are then invisible thru using that key.

Sap Hana Modeling Interview Questions
Question 37. What Exactly Is The Significance Of Persistence Layer In Sap Hana?

Answer :

It is certainly an essential later in SAP HANA which performs a very critical position. Actually, HANA has a computing engine built interior and the customers have to make use of the statistics at once without taking any backup. The equal can create an trouble at some point of powerful failure and therefore it's far vital to preserve a backup of the equal. This layer comes as a savior and it ensure no loss of facts at some point of this type of state of affairs.

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

Answer :

If the queries inside the SQL are simple, the users are free to retrieve a completely large sum of records very easily from the gadget. Another true factor about SQL is it's far very clean to analyze and put into effect. There is a great aid available for SQL and all the queries may be addressed reliably. Using SQL, the database may be managed very without difficulty and in reality without thinking about a huge quantity of coding.