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 - Consider the differences between OLTP and OLAP system, which of the below statement is incorrect about an OLAP system?

A - It has more indexes as compared to an OLTP system

B - It process historical data

C - It has Normalized data as compared to an OLTP database

D - It has less number of joins compared to an OLTP system

Answer : C

Explanation

Few Indexes, while in Data Warehouse many indexes for performance optimization.

Many Joins, Data is normalized. Data Warehouse less joins and denormalized.

Less Aggregation, while in Data Warehouse lots of aggregations are used.

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 Modeler is using Calculation view with Star Join to add measures from multiple fact tables. Which of the below statement is correct about Calculation view with Star Join?

A - You can only add base Column tables at Star Join level.

B - You can only add Attribute Views or Analytical views at Star Join

C - You can only add Dimension Calculation View at Star Join

D - You can add other Calculation views without Star Join and data type Cube

Answer : C

Explanation

You can only use dimension Calculation views in Calculation view without Star Join.

Q 4 - Which of the below is used to handle queries and manipulates multidimensional data stored in OLAP cubes?

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 - 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 - Which of the below privilege type is used for Backup/Restore, User Administration, Instance start and stop, etc.?

A - Object Privileges

B - System Privileges

C - Package Privileges

D - Analytic Privileges

Answer : B

Explanation

System privileges are used for Backup/Restore, User Administration, Instance start and stop, etc.

Q 7 - To manage remote objects from Teradata, Sybase IQ and Hadoop in HANA database, which of the below option can be used?

A - SAP Smart data access

B - HANA XS Engine

C - HANA Application Perspective

D - HANA Sybase Replication

Answer : A

Explanation

SAP Smart data access

Q 8 - Which of the below is not an audit trial type while configuring an audit policy in HANA system?

Answer : D

Explanation

Syslog(default) − Logging system of Linux Operating System.

Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.

CSV text − This type of audit trail is only used for test purpose in a non-production environment.

Q 9 - Which of the below component in SAP HANA Architecture distributed environment is used to store System landscape and topology information of system?

A - Name Server

B - Preprocessor

C - Index Server

D - Statistics Server

Answer : A

Explanation

NAME server contains System Landscape information of HANA system. In distributed environment, there are multiple nodes with each node has multiple CPU’s, Name server holds topology of HANA system and has information about all the running components and information is spread on all the components.

Topology of SAP HANA system is recorded here.
It decreases the time in re-indexing as it holds which data is on which server in distributed environment.

Q 10 - To get multiple measures from different tables, which of the below is most suitable view type to be used in HANA Modeling?

A - Attribute

B - Analytic

C - Calculation

D - Analytic Privilege

Answer : C

Explanation

Calculation Views are used to consume other Analytic, Attribute and other Calculation views and base column tables. These are used to perform complex calculations which are not possible with other type of Views including implementing Galaxy schema.

sap_hana_questions_answers.htm