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 - 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 - 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 - In SAP Data Services to replicate the data from SAP ECC to HANA database, which data store type should be used to create a data store for ECC and HANA system?

A - SAP ECC system, Database

B - Database, SAP Applications

C - Database, SAP ECC system

D - SAP Applications, Database

Answer : D

Explanation

For ECC system, use SAP Applications while creating a datastore.

For SAP HANA, use Database as store type while creating a data store.

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?

Answer : B

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