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

Explanation

In Star schema, you have one fact table and multiple dim tables.

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?

A - Cross Join

B - Outer Join

C - Inner Join

D - Self Join

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?

A - SYS_REPO

B - SYS_READ

C - DATA ADMIN

D - REPO READ

Answer : A

Explanation

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

Q 5 - Which of the below Data Replication method requires no additional server or application in the SAP HANA system landscape?

A - SLT

B - Data Service

C - DXC

D - Log based method

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 - You have create a Universe on the top of HANA database to create reports in Web Intelligence. Which of the connection type can be used to publish Universe in Repository?

A - cnx

B - cns

C - unx

D - unv

Answer : B

Explanation

.cns- connection type represents secured Repository connection that should be used to create Data foundation.

.cnx-represents local unsecured connection and if you use this connection while creating a Universe and while publishing Universe it will not allow you to publish that to repository.

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?

A - Open Content

B - Open Definition

C - Data Preview

D - Open Details

Answer : C

Explanation

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

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

A - True

B - False

Answer : A

Q 10 - Which of the below allows you to load the large amount of data to HANA database by using a text file or via a clipboard?

A - SAP HANA Information Composer

B - SAP HANA cockpit

C - SAP HANA Live

D - SAP HANA Data Provisioning

Answer : A

Explanation

SAP HANA Information Composer. You can perform data loading or manipulation using this tool.

To upload data this can be done in two ways −

  • Uploading .xls, .csv file directly to HANA database
  • Other way is to copy data to clipboard and copy from there to HANA database.
  • It allows data to be loaded along with header.

sap_hana_questions_answers.htm

Advertisements