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

Answer : A

Explanation

In Star schema, you have one fact table and multiple dim tables.

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 - In SAP HANA Modeling, which of the view type provides Modeler with an inbuilt nodes-Projection, Join, Union and Rank?

A - Analytic View

B - Attribute View

C - Calculation View

D - All of the above

Answer : C

Explanation

Graphical Calculation Views

Can consume other Analytical, Attribute, other Calculation Views & tables Built-in Union, Join, Projection & Aggregation nodes

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

Explanation

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 - Which of the below Data Replication method requires no additional server or application in the SAP HANA system landscape?

A - SLT

B - Data Service

C - DXC

D - Log based method

Answer : C

Explanation

Reuses existing proprietary extraction, transformation, and load mechanism built into SAP Business Suite systems over a simple HTTP(S) connection to SAP HANA.

Requires no additional server or application in the system landscape (Simplicity)

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

Explanation

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 - Which of the below option in HANA system allows you to perform analysis like Raw data, distinct value, etc. on a database table or on a Modeling view?

A - Open Content

B - Open Definition

C - Data Preview

D - Open Details

Answer : C

Explanation

Data Preview gives you 3 options- Raw Data, distinct values, analysis.

Q 9 - Which of the below Modeling view in SAP HANA is specifically designed to execute Star schema queries?

A - Attribute View

B - Analytic View

C - Calculation View

D - Analytic View

Answer : B

Explanation

Analytic views are designed to perform Star schema queries.

Analytic views contain atleast one fact table and multiple dimension tables with master data and perform calculations and aggregations.

They are similar to Info Cubes and Info objects in SAP BW.

Analytic views can be created on top of Attribute views and Fact tables and performs calculations like number of unit sold, total price, 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