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 - To perform complex calculations and aggregations, which of the table type is preferred?

A - Row Store

B - Column Store

C - Depends on Dimension table

D - All of the above are true

Answer : B

Explanation

Column base tables are preferred to perform aggregations and calculations as similar data type comes together.

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 - In SAP HANA database, while creating a new column base table we can define a null value for a Primary key?

A - True

B - False

Answer : B

Explanation

A Primary key is always unique and not null.

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 - To connect Microsoft Excel to HANA Modeling views, which of the below can be used for direct connectivity to create reports?

Answer : A

Explanation

MDX Provider

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 3^rd 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 - To manage remote objects from Teradata, Sybase IQ and Hadoop in HANA database, which of the below option can be used?

A - SAP Smart data access

B - HANA XS Engine

C - HANA Application Perspective

D - HANA Sybase Replication

Answer : A

Explanation

SAP Smart data access

Q 8 - Which of the below is not an audit trial type while configuring an audit policy in HANA system?

Answer : D

Explanation

Syslog(default) − Logging system of Linux Operating System.

Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.

CSV text − This type of audit trail is only used for test purpose in a non-production environment.

Q 9 - Which of the below Modeling view in SAP HANA is specifically designed to execute Star schema queries?

Answer : B

Explanation

Analytic views are designed to perform Star schema queries.

Analytic views contain atleast one fact table and multiple dimension tables with master data and perform calculations and aggregations.

They are similar to Info Cubes and Info objects in SAP BW.

Analytic views can be created on top of Attribute views and Fact tables and performs calculations like number of unit sold, total price, etc.

Q 10 - In SAP HANA Modeling, If a view is not activated how do you identify this by looking at the name of the view in package?

A - Red cross mark

B - Grey Diamond mark

C - Yellow oval mark

D - Blue tick mark

Answer : B

sap_hana_questions_answers.htm