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

SAP HANA studio is an Eclipse-based development and administration tool for working with HANA.

It is a client tool, which can be used to access local or remote HANA system.

It provides an environment for Administration, Modeling and Data Provisioning.

There are several predefined User Interface addressing several applications types called Perspectives.

We can use the SAP HANA studio on the following platforms −

Microsoft Windows x32 and x64 versions of: Windows XP, Windows Vista, Windows 7.

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 - In SAP HANA Data Replication, Which of the below is a trigger based method for data provisioning and used for real time business scenarios in HANA database?

A - Data Service

B - Landscape Transformation

C - Sybase Replication

D - DXC

Answer : B

Explanation

SAP LT uses trigger based approach: has no measureable performance impact in source system.

It provides transformation and filtering capability.

It allows real-time (and scheduled) data replication, replicating only relevant data into HANA from SAP and non-SAP source systems.

It is fully integrated with HANA Studio.

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 - 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 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 - Which of the below allows you to load the large amount of data to HANA database by using a text file or via a clipboard?

A - SAP HANA Information Composer

B - SAP HANA cockpit

C - SAP HANA Live

D - SAP HANA Data Provisioning

Answer : A

Explanation

SAP HANA Information Composer. You can perform data loading or manipulation using this tool.

To upload data this can be done in two ways −

  • Uploading .xls, .csv file directly to HANA database
  • Other way is to copy data to clipboard and copy from there to HANA database.
  • It allows data to be loaded along with header.

sap_hana_questions_answers.htm

Advertisements