• 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.

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 - 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 - While creating a SAP HANA Modeling view, which user parameter allows you to add a new field in the Data Preview that doesn’t exist in database or view level?

A - Hierarchies

B - Another View at Star Join level

C - Calculated Column

D - Distinct Value

E - Primary Key

Answer : C

Explanation

Calculated column allows you to add a column at report level that doesn’t exist in database or view level.

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 - Which of the below option can be used to check the configuration, current alerts, all services running and manufacturer details in HANA system?

A - System Monitor

B - Administration

C - SQL Editor

D - Open Perspective

Answer : B

Explanation

Administration tab is used to get all the details- about manufacturer, services running, alerts, performance, volumes, etc.

Q 10 - In SAP HANA Modeling, If a view is not activated how do you identify this by looking at the name of the view in package?

A - Red cross mark

B - Grey Diamond mark

C - Yellow oval mark

D - Blue tick mark

Answer : B

sap_hana_questions_answers.htm
Advertisements