SAP HANA - Home

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 - 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 - In SAP HANA Modeling, which of the view type provides Modeler with an inbuilt nodes-Projection, Join, Union and Rank?

Answer : C

Explanation

Graphical Calculation Views

Can consume other Analytical, Attribute, other Calculation Views & tables Built-in Union, Join, Projection & Aggregation nodes

Q 4 - Which of the below component in HANA system architecture ensures database is restored to most recent state and ensures that all the transactions are completed?

A - Transaction and Session Management

B - Preprocessor Server

C - SAP HANA Studio Repository

D - Persistence Layer

Answer : D

Explanation

The database persistence layer is responsible for durability and atomicity of transactions.

It ensures that the database can be restored to the most recent committed state after a restart and that transactions are either completely executed or completely undone.

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

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

Answer : C

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?