• SAP HANA Video Tutorials

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

Explanation

Target table should have same columns and data types otherwise you can use a new template table option.

Q 2 - SAP HANA Administrator is using instance 00 to connect to HANA Studio. Which port is used in HANA system for this instance?

A - Port 30015

B - Port 3615

C - SSh port

D - Port 31015

Answer : A

Explanation

  • Port 3615 should be open to connect to Database
  • Port 31015 Instance No 10
  • Port 30015 Instance No 00
  • SSh port should also be opened.

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 - 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 - 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 - In SAP HANA Calculation view, which of the below default node type is not available to use in Scenario pane?

A - Join

B - Union

C - Index

D - Project

Answer : C

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 - Which of the below Modeling view in SAP HANA is specifically designed to execute Star schema queries?

A - Attribute View

B - Analytic View

C - Calculation View

D - Analytic View

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 - Which of the below user can access HANA system via HTTP/HTTPS applications and doesn’t have access to create objects in schema in HANA database?

A - Standard User

B - Public User

C - Restricted User

D - Power User

E - Application User

Answer : C

Explanation

Restricted users are those users who access HANA system with some applications and they don’t have SQL privileges on HANA system. When these users are created they don’t have any access initially.

If we compare restricted users with Standard users −

Restricted users can’t create objects in HANA database or their own Schemas.

They don’t have access to view any data in database as they don’t have generic Public role added to profile like standard users.

They can connect to HANA database only using HTTP/HTTPS

sap_hana_questions_answers.htm
Advertisements