• SAP HANA Video Tutorials

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.

Questions and Answers

Q 1 - Consider different DW systems in place, which of the below DW system focus on predicting future outcomes using complex mathematical models?

A - Predictive Analysis

B - Data Mart

C - OLTP

D - OLAP

Answer : A

Explanation

Predictive analysis is about finding and quantifying hidden patterns in the data using complex mathematical models that can be used to predict future outcomes.

Q 2 - In a Query panel, Report developer wants to add multiple conditions in a Where clause statement. Which of the operator type should be used?

A - Arithmetic Operator

B - Relational/Comparison Operator

C - Logical/Boolean Operators

D - Set Operator

Answer : C

Explanation

SELECT empno, ename, sal FROM emp WHERE sal >= 1500 AND sal <= 3000; SELECT empno, ename, sal FROM emp WHERE deptno = 10 OR deptno = 20;

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 - Which of the below is used to handle queries and manipulates multidimensional data stored in OLAP cubes?

A - SQL Processor

B - MDX Processor

C - XS Engine

D - Index Server

E - Name Server

Answer : B

Explanation

HANA can act as both relational as well as OLAP. When we use BW on HANA then we create cubes in BW and HANA will act as relational database and it will always produce a SQL Statement but when we directly access HANA views using OLAP connection then it will act as OLAP and MDX will be generated.

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 - 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 - 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 - While performing SAP HANA data Replication using SLT method, which of the below is not a supported mode?

A - Load

B - Replicate

C - Suspend

D - Resume

E - Stop

Answer : E

Explanation

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 doesnt 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 dont have SQL privileges on HANA system. When these users are created they dont have any access initially.

If we compare restricted users with Standard users −

Restricted users cant create objects in HANA database or their own Schemas.

They dont have access to view any data in database as they dont 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