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

Explanation

Few Indexes, while in Data Warehouse many indexes for performance optimization.

Many Joins, Data is normalized. Data Warehouse less joins and denormalized.

Less Aggregation, while in Data Warehouse lots of aggregations are used.

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 Data Replication, Which of the below is a trigger based method for data provisioning and used for real time business scenarios in HANA database?

A - Data Service

B - Landscape Transformation

C - Sybase Replication

D - DXC

Answer : B

Explanation

SAP LT uses trigger based approach: has no measureable performance impact in source system.

It provides transformation and filtering capability.

It allows real-time (and scheduled) data replication, replicating only relevant data into HANA from SAP and non-SAP source systems.

It is fully integrated with HANA Studio.

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 - To perform Analytical reporting in SAP Business Objects on the top of HANA views, which of the below BI reporting tools can be directly connected to HANA system?

A - Dashboard

B - SAP Lumira

C - WebI Report

D - All of the above

Answer : B

Q 7 - To provide unfiltered read only access to all system views, which of the below system privilege type should be added to user profile?

A - Data Admin

B - Catalog Read

C - Audit Admin

D - Credential Admin

Answer : B

Explanation

It authorizes users to have unfiltered read-only access to all system views.

Normally, the content of these views is filtered based on the privileges of the accessing user.

Q 8 - Consider a SAP HANA system with a permanent license which is about to expire. How many days an administrator has to get it renew after the permanent license is expired.

A - 28 days

B - 30 days

C - 14 days

D - 45 days

Answer : A

Explanation

Permanent License keys are valid till the predefine expiration date. License keys specify amount of memory licensed to target HANA installation. They can installed from SAP Market place under Keys and Requests tab. When a permanent License key is expired, a temporary license key is issued which is valid for only 28 days. During this period you have to install a permanent License key again.

Q 9 - SAP HANA Modeling can only be performed on column base tables?

A - True

B - False

Answer : A

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

Advertisements