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

Answer : B

Explanation

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 - 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 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 - In SAP HANA Job based replication, which of the below can be used to add a schedule, to trace, monitor and error check a replication job?

A - Data Service Designer

B - Data Service Repository Manager

C - Data Service Management Console

D - Data Services Server Manager

Answer : C

Explanation

Data Service Management Console – You can trace, monitor, error check replication jobs in repository.

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

Explanation

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

Explanation

Only the OLAP engine will be used

Q 10 - Which of the below user can access HANA system via HTTP/HTTPS applications and doesn’t have access to create objects in schema in HANA database?

A - Standard User

B - Public User

C - Restricted User

D - Power User

E - Application User

Answer : C

Explanation

Restricted users are those users who access HANA system with some applications and they don’t have SQL privileges on HANA system. When these users are created they don’t have any access initially.

If we compare restricted users with Standard users −

Restricted users can’t create objects in HANA database or their own Schemas.

They don’t have access to view any data in database as they don’t have generic Public role added to profile like standard users.

They can connect to HANA database only using HTTP/HTTPS

sap_hana_questions_answers.htm
Advertisements