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 - To perform complex calculations and aggregations, which of the table type is preferred?

A - Row Store

B - Column Store

C - Depends on Dimension table

D - All of the above are true

Answer : B


Column base tables are preferred to perform aggregations and calculations as similar data type comes together.

Answer : B


SAP HANA studio is an Eclipse-based development and administration tool for working with HANA.

It is a client tool, which can be used to access local or remote HANA system.

It provides an environment for Administration, Modeling and Data Provisioning.

There are several predefined User Interface addressing several applications types called Perspectives.

We can use the SAP HANA studio on the following platforms −

Microsoft Windows x32 and x64 versions of: Windows XP, Windows Vista, Windows 7.

Q 3 - In SAP HANA Modeling, Attributes views are used −

A) in Analytic and Calculation views.

B) represents master data.

C) are designed to perform Star schema queries

D) are used to filter size of dimension tables in Analytic and Calculation View

E) are defined either graphical using HANA Modeling feature or scripted in the SQL Choose the correct option.

A - A, C, D are correct

B - A, B, D are correct

C - A, D, E are correct

D - B, C, D are correct

Answer : B


Attribute views are dimensions, BW characteristics or master data.

Attribute views are used to join to a dimension or attribute view.

In most cases used to model master data like entities (like Product, Employee, Business Partner)

Highly re-used and shared in Analytic- and Calculation Views

Q 4 - Which of the below is used to handle queries and manipulates multidimensional data stored in OLAP cubes?

A - SQL Processor

B - MDX Processor

C - XS Engine

D - Index Server

E - Name Server

Answer : B


HANA can act as both relational as well as OLAP. When we use BW on HANA then we create cubes in BW and HANA will act as relational database and it will always produce a SQL Statement but when we directly access HANA views using OLAP connection then it will act as OLAP and MDX will be generated.

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 - To manage remote objects from Teradata, Sybase IQ and Hadoop in HANA database, which of the below option can be used?

A - SAP Smart data access

B - HANA XS Engine

C - HANA Application Perspective

D - HANA Sybase Replication

Answer : A


SAP Smart data access

Q 8 - In SAP HANA Data Modeling, where do you define hierarchies, variables/parameters while creating a Modeling view?

A - Semantic

B - Data foundation

C - Output pane

D - Properties pane

E - Star Join

Answer : A


In Semantic, you can define Hierarchies, parameters/variables.

Q 9 - When an Analytic View is joined to attribute views, is both the OLAP and JOIN Engine used?

A - True

B - False

Answer : B


Only the OLAP engine will be used

Q 10 - Which of the below allows you to load the large amount of data to HANA database by using a text file or via a clipboard?

A - SAP HANA Information Composer

B - SAP HANA cockpit


D - SAP HANA Data Provisioning

Answer : A


SAP HANA Information Composer. You can perform data loading or manipulation using this tool.

To upload data this can be done in two ways −

  • Uploading .xls, .csv file directly to HANA database
  • Other way is to copy data to clipboard and copy from there to HANA database.
  • It allows data to be loaded along with header.