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 : A

Explanation

In Star schema, you have one fact table and multiple dim tables.

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 - 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?

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 - To recover SAP HANA database to the specific point, which of the below recovery type should be used?

A - Most Recent State option

B - Point In Time option

C - Specific Log backup option

D - None of the above

Answer : B

Explanation

Point in Time.

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 provide unfiltered read only access to all system views, which of the below system privilege type should be added to user profile?

A - Data Admin

B - Catalog Read

C - Audit Admin

D - Credential Admin

Answer : B

Explanation

It authorizes users to have unfiltered read-only access to all system views.

Normally, the content of these views is filtered based on the privileges of the accessing user.

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