Explore topic-wise InterviewSolutions in .

What is SAP HANA or basic of SAP HANA
SAP HANA is one of the latest ERP Solution provided by SAP. It is a combination of Hardware and Software. SAP HANA is in-memory , column-oriented, relational database management system developed and marketed by SAP SE and platform which can be deployed on-premises or cloud also. We can also say it is a application development platform for processing high volumes of data in real time. DUE to real-time data platform FEATURE it is DIFFERENT from any other database engine in the market TODAY. SAP HANA also performs advanced analytics like predictive analytics, spatial data processing, text analytics, text search, streaming analytics, GRAPH data processing etc. SAP HANA also integrates different components like SAP HANA Database, SAP SLT (System Landscape Transformation) Replication server, SAP HANA Direct Extractor connection and Sybase replication technology

What do you knows by PERSISTENCE layer in SAP HANA?
As we knows SAP Hana has feature of in-memery computing ENGINE and access the DATA in straighaway without any backup. And this may cause some data loss as data is used straightway without of any backup. But to avoid risk of data losing data in case of power cutoff and hardware failure persistence layer comes as a savior and stores all the data in the HARD drive which is not volatile.

Can you DEFINE the term Schema in SAP HANA?
In SAP HANA term schema plays an important ROLE. It is a dedicated area of database which is basicaly used to store database objects and these objects are TABLES, packages, FOLDERS and procedures. And schema will provides a namespace for systems which connects to database.

Name the default NODES available in a Calculation view?
Below are the default nodes available in a Calculation view
(1)JOIN
(2)Union
(3)PROJECT
(4)AGGREGATION
(5)Rank

Which is not a replication METHOD for data replication from a SOURCE system to SAP HANA?
Choose the correct option from below LIST
(1)ETL based
(2)Trigger based
(3)Time based
(4)LOG based

Answer:-(3)Time based

What do you mean by sizing in SAP HANA?
There are many of software and application which REQUIRE minimum memory or hardisk and if the specific size and memory is not AVAILABLE it will not installed. Similarly Sizing in SAP HANA is basically refered to determine the hardware requirements for some specific installation requirements. In SAP HANA hardware components IMPORTANT for sizing point of view are CPU, memory (RAM) and hard disk. And the most crucial TASK in sizing is to extimate the size of server best suited for business user requirements. There are three ways to determine the sizing in SAP HANA:-
(1)By using Quick Sizer tool
(2)By using DB script
(3)By using ABAP report

Name the six main components of an INDEX SERVER in SAP HANA?
Below are the six main components of an index server:-
(1)Relational data engine
(2)Connection and SESSION manager
(3)AUTHORIZATION manager
(4)Planning engine
(5)Calc engine
(6)Persistence layer

Define the main role of master controller job in SAP HANA?
In SAP HANA job is arranged on demand and is RESPONSIBLE for below points:-
(1)It helps in creating synonyms
(2)It helps in writing NEW entries in admin tables in SLT server when table is either loaded or replicated.
(3)It helps in creating database triggers and logging table into the SOURCE system.

Basic definition of SAP HANA
SAP HANA is one of the best latest in-memory DATABASE and platform. And this can be DEPLOYED on-premises or we can say on cloud. SAP HANA is a combination of both hardware and software. And this combination integrates different components like SAP SLT REPLICATION Server, SAP HANA Database, Sybase Replication and SAP HANA DIRECT Extractor connection.
HANA is capable to process large amount of real time data in very short time period. And SAP HANA has unprecedented adoption by the SAP customers.

SAP HANA is different then other and why?
Below are the reasons which shows why SAP HANA is different:-
(1)SAP HANA was the first technology ever which is used for both OLTP and OLAP application processing.
(2)SAP HANA will provides query processing environment for both structure and unstructured data. Which is for both Relational database(tables) and less structured(texts,graphs) respectively.
(3)HANA is defined as High Performance ANALYTICAL Appliance, a?? full transactional?? RDBMS system given by SAP.
(4)SAP Hana consists of in-memory computing engine(IMCE) which will combine row based and column based architecture.
(5)As we knows SAP HANA is capable for both OLTP and OLAP into a single box which includes both HARDWARE and Software innovations.
(6)We can also called SAP HANA a Hybrid Database System.
(7)Due to multi-core processing engines of SAP HANA system it will process data parallelly. The parallel processing is done within different columns of the same database. Using a COLUMNAR database, the system optimizes data structure and eases storing large data by compressing it.

What is the full FORM of SAP HANA?
First we will define full form of SAP (SYSTEMS, application & products in Data processing). And now full form of HANA is (High Speed Analytical Appliance).