• 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

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.

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

A - Analytic View

B - Attribute View

C - Calculation View

D - All of the above

Answer : C

Explanation

Graphical Calculation Views

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

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 connect Microsoft Excel to HANA Modeling views, which of the below can be used for direct connectivity to create reports?

A - MDX Provider

B - SQL Provider

C - XS Engine

D - Name Server

Answer : A

Explanation

MDX Provider

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?

A - Syslog

B - CSV Text file

C - Database table

D - Backing

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 - SAP HANA Modeling can only be performed on column base tables?

A - True

B - False

Answer : A

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