• SAP HANA Video Tutorials

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

Explanation

Point in Time.

Q 6 - In SAP HANA database, an administrator can see that log area is filling continuously and causing database to hang. What can be done to fix this issue?

A - Limit File Size

B - Use backint destination type

C - Enable Automatic log backup

D - Use 3rd party backup tool

Answer : C

Explanation

Enable Automatic log backup option: It helps you to keep log area vacant. If you disable this log area will continue to fill and that can result database to hang.

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

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 - To get multiple measures from different tables, which of the below is most suitable view type to be used in HANA Modeling?

A - Attribute

B - Analytic

C - Calculation

D - Analytic Privilege

Answer : C

Explanation

Calculation Views are used to consume other Analytic, Attribute and other Calculation views and base column tables. These are used to perform complex calculations which are not possible with other type of Views including implementing Galaxy schema.

sap_hana_questions_answers.htm
Advertisements