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 : D


Target table should have same columns and data types otherwise you can use a new template table option.

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 - A SAP HANA Modeler is using Calculation view with Star Join to add measures from multiple fact tables. Which of the below statement is correct about Calculation view with Star Join?

A - You can only add base Column tables at Star Join level.

B - You can only add Attribute Views or Analytical views at Star Join

C - You can only add Dimension Calculation View at Star Join

D - You can add other Calculation views without Star Join and data type Cube

Answer : C


You can only use dimension Calculation views in Calculation view without Star Join.

Q 4 - Which of the below component in HANA system architecture ensures database is restored to most recent state and ensures that all the transactions are completed?

A - Transaction and Session Management

B - Preprocessor Server

C - SAP HANA Studio Repository

D - Persistence Layer

Answer : D


The database persistence layer is responsible for durability and atomicity of transactions.

It ensures that the database can be restored to the most recent committed state after a restart and that transactions are either completely executed or completely undone.

Q 5 - To recover SAP HANA database to the specific point, which of the below recovery type should be used?

A - Most Recent State option

B - Point In Time option

C - Specific Log backup option

D - None of the above

Answer : B


Point in Time.

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 - In SAP HANA Calculation view, which of the below default node type is not available to use in Scenario pane?

A - Join

B - Union

C - Index

D - Project

Answer : C

Q 8 - Consider a SAP HANA system with a permanent license which is about to expire. How many days an administrator has to get it renew after the permanent license is expired.

A - 28 days

B - 30 days

C - 14 days

D - 45 days

Answer : A


Permanent License keys are valid till the predefine expiration date. License keys specify amount of memory licensed to target HANA installation. They can installed from SAP Market place under Keys and Requests tab. When a permanent License key is expired, a temporary license key is issued which is valid for only 28 days. During this period you have to install a permanent License key again.

Q 9 - Which of the below option can be used to check the configuration, current alerts, all services running and manufacturer details in HANA system?

A - System Monitor

B - Administration

C - SQL Editor

D - Open Perspective

Answer : B


Administration tab is used to get all the details- about manufacturer, services running, alerts, performance, volumes, etc.

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.