• SAP HANA Video Tutorials

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

Q 1 - Consider different DW systems in place, which of the below DW system focus on predicting future outcomes using complex mathematical models?

A - Predictive Analysis

B - Data Mart



Answer : A


Predictive analysis is about finding and quantifying hidden patterns in the data using complex mathematical models that can be used to predict future outcomes.

Q 2 - SAP HANA Administrator is using instance 00 to connect to HANA Studio. Which port is used in HANA system for this instance?

A - Port 30015

B - Port 3615

C - SSh port

D - Port 31015

Answer : A


  • Port 3615 should be open to connect to Database
  • Port 31015 Instance No 10
  • Port 30015 Instance No 00
  • SSh port should also be opened.

Q 3 - In SAP HANA database, while creating a new column base table we can define a null value for a Primary key?

A - True

B - False

Answer : B


A Primary key is always unique and not null.

Q 4 - In SAP HANA Data Replication, Which of the below is a trigger based method for data provisioning and used for real time business scenarios in HANA database?

A - Data Service

B - Landscape Transformation

C - Sybase Replication


Answer : B


SAP LT uses trigger based approach: has no measureable performance impact in source system.

It provides transformation and filtering capability.

It allows real-time (and scheduled) data replication, replicating only relevant data into HANA from SAP and non-SAP source systems.

It is fully integrated with HANA Studio.

Q 5 - In SAP HANA Job based replication, which of the below can be used to add a schedule, to trace, monitor and error check a replication job?

A - Data Service Designer

B - Data Service Repository Manager

C - Data Service Management Console

D - Data Services Server Manager

Answer : C


Data Service Management Console – You can trace, monitor, error check replication jobs in repository.

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 - To provide unfiltered read only access to all system views, which of the below system privilege type should be added to user profile?

A - Data Admin

B - Catalog Read

C - Audit Admin

D - Credential Admin

Answer : B


It authorizes users to have unfiltered read-only access to all system views.

Normally, the content of these views is filtered based on the privileges of the accessing user.

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.