SAP HANA - Home

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 - Which of the below statement is true about Union and Union All set operators?

A - Union prints all the rows from both the tables.

B - Union All prints all the rows from both the tables.

C - Union and Union All has same function and both can be used to print all the rows of both the tables.

D - None of the above

Answer : B

Explanation

UNION is used to combine the results of two or more Select statements. However it will eliminate duplicate rows

Union All

This operation is similar to Union. But it also shows the duplicate rows.

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 - A SAP HANA Modeler is trying to activate an Analytical view and getting the error message- insufficient privilege. Which of the below user should get access on Schema and tables used in HANA view to activate the view?

Answer : A

Explanation

GRANT SELECT ON SCHEMA "B11SALES" TO _SYS_REPO WITH GRANT OPTION

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 - 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 - While creating a SAP HANA Modeling view, which user parameter allows you to add a new field in the Data Preview that doesnt exist in database or view level?

A - Hierarchies

B - Another View at Star Join level

C - Calculated Column

D - Distinct Value

E - Primary Key

Answer : C

Explanation

Calculated column allows you to add a column at report level that doesnt exist in database or view level.

Q 8 - While performing SAP HANA data Replication using SLT method, which of the below is not a supported mode?

Answer : E

Explanation

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