• 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 : D

Explanation

Target table should have same columns and data types otherwise you can use a new template table option.

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 - In SAP HANA Modeling, to copy an existing view and without making any changes to it, which of the below option should be used?

A - Copy

B - Derived

C - Standard

D - Time

E - All of the above

Answer : B

Explanation

Copy from − If you want to use already existing attribute view s template then go for this(you can modification if required for current one).

Derived − This is kind of reference type. You cannot do modifications to the current one (Do the changes for main one).

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