SAP HANA Online Quiz


Advertisements


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

Explanation

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

Q 2 - A SAP HANA developer wants to create HTML application and to host it on web server in HANA. Which of the below component in HANA architecture can be used by Web applications to access HANA database?

A - Index Server

B - Name Server

C - XS Engine

D - SAP Host Agent

Answer : C

Explanation

XS Engine allows external applications to access the SAP HANA system via the XS Engine clients. It allows UI5 based applications to use SAP HANA via http/https or other protocols.

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

Explanation

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

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

Explanation

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 - In SAP Data Services to replicate the data from SAP ECC to HANA database, which data store type should be used to create a data store for ECC and HANA system?

A - SAP ECC system, Database

B - Database, SAP Applications

C - Database, SAP ECC system

D - SAP Applications, Database

Answer : D

Explanation

For ECC system, use SAP Applications while creating a datastore.

For SAP HANA, use Database as store type while creating a data store.

Q 6 - To perform Analytical reporting in SAP Business Objects on the top of HANA views, which of the below BI reporting tools can be directly connected to HANA system?

A - Dashboard

B - SAP Lumira

C - WebI Report

D - All of the above

Answer : B

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

Explanation

SAP Smart data access

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

Explanation

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

Explanation

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

Explanation

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


sap_hana_questions_answers.htm

Advertisements