SAP HANA Online Quiz

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.

Q 1 - Consider the Data Modeling concept in HANA, Which of the below statement is incorrect about Schema?

A - In Star Schema, you can have multiple fact tables and Dim tables

B - In Star Schema, Dim tables are not normalized

C - In Galaxy Schema, you have multiple fact tables and multiple Dim tables.

D - In Snowflakes schema, you have multiple Dim tables in normalized form.

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?

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 developer has two tables and while joining the tables he is getting output as number of rows in table A multiplied by table B. Which of the below Join type is used?

Answer : A

Explanation

CROSS JOIN produces a result set which is the number of rows in the first table multiplied by the number of rows in the second table, if no WHERE clause is used along with CROSS JOIN. This kind of result is called as Cartesian Product.

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?

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

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 - Which of the below privilege type is used for Backup/Restore, User Administration, Instance start and stop, etc.?

A - Object Privileges

B - System Privileges

C - Package Privileges

D - Analytic Privileges

Answer : B

Explanation

System privileges are used for Backup/Restore, User Administration, Instance start and stop, etc.

Q 7 - In SAP HANA Calculation view, which of the below default node type is not available to use in Scenario pane?

Answer : C

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?

Answer : C

Explanation

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

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?

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