SAP HANA Online Quiz


Following quiz provides Multiple Choice Questions (MCQs) related to SAP HANA. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

Answer : C


Few Indexes, while in Data Warehouse many indexes for performance optimization.

Many Joins, Data is normalized. Data Warehouse less joins and denormalized.

Less Aggregation, while in Data Warehouse lots of aggregations are used.

Answer : B


UNION is used to combine the results of two or more Select statements. However it will eliminate duplicate rows

Union All

This operation is similar to Union. But it also shows the duplicate rows.

Q 3 - A SAP HANA developer has two tables and while joining the tables he is getting output as number of rows in table A multiplied by table B. Which of the below Join type is used?

A - Cross Join

B - Outer Join

C - Inner Join

D - Self Join

Answer : A


CROSS JOIN produces a result set which is the number of rows in the first table multiplied by the number of rows in the second table, if no WHERE clause is used along with CROSS JOIN. This kind of result is called as Cartesian Product.

Q 4 - A SAP HANA Modeler is trying to activate an Analytical view and getting the error message- insufficient privilege. Which of the below user should get access on Schema and tables used in HANA view to activate the view?





Answer : A



Q 5 - To connect Microsoft Excel to HANA Modeling views, which of the below can be used for direct connectivity to create reports?

A - MDX Provider

B - SQL Provider

C - XS Engine

D - Name Server

Answer : A


MDX Provider

Q 6 - Which of the below privilege type is used for Backup/Restore, User Administration, Instance start and stop, etc.?

A - Object Privileges

B - System Privileges

C - Package Privileges

D - Analytic Privileges

Answer : B


System privileges are used for Backup/Restore, User Administration, Instance start and stop, etc.

Q 7 - Which of the below migration method in SAP HANA allows you to export multiple packages to remote HANA server?

A - SAP Developer Mode

B - SAP Support mode

C - Local File

D - Delivery Unit

Answer : D


Delivery unit is a single Unit which can be mapped to multiple packages and can be exported as single entity so that all the packages assigned to Delivery Unit can be treated as single unit.

Users can use this option to export all the packages that make a delivery unit and the relevant objects contained in it to a HANA Server or to local Client location.

Q 8 - While performing SAP HANA data Replication using SLT method, which of the below is not a supported mode?

A - Load

B - Replicate

C - Suspend

D - Resume

E - Stop

Answer : E


Q 9 - Which of the below component in SAP HANA Architecture distributed environment is used to store System landscape and topology information of system?

A - Name Server

B - Preprocessor

C - Index Server

D - Statistics Server

Answer : A


NAME server contains System Landscape information of HANA system. In distributed environment, there are multiple nodes with each node has multiple CPU’s, Name server holds topology of HANA system and has information about all the running components and information is spread on all the components.

  • Topology of SAP HANA system is recorded here.

  • It decreases the time in re-indexing as it holds which data is on which server in distributed environment.

Q 10 - While creating a Relational connection to HANA database, where you can define connection pool time out details?

A - JDBC/ODBC drivers

B - Connection parameters

C - In Business Layer

D - In Data Foundation

Answer : B


This is defined in Connection parameters – Time out, array fetch size, batch size, etc.