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

Q 1 - Consider different DW systems in place, which of the below DW system focus on predicting future outcomes using complex mathematical models?

A - Predictive Analysis

B - Data Mart

C - OLTP

D - OLAP

Answer : A

Explanation

Predictive analysis is about finding and quantifying hidden patterns in the data using complex mathematical models that can be used to predict future outcomes.

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, Attributes views are used −

A) in Analytic and Calculation views.

B) represents master data.

C) are designed to perform Star schema queries

D) are used to filter size of dimension tables in Analytic and Calculation View

E) are defined either graphical using HANA Modeling feature or scripted in the SQL Choose the correct option.

A - A, C, D are correct

B - A, B, D are correct

C - A, D, E are correct

D - B, C, D are correct

Answer : B

Explanation

Attribute views are dimensions, BW characteristics or master data.

Attribute views are used to join to a dimension or attribute view.

In most cases used to model master data like entities (like Product, Employee, Business Partner)

Highly re-used and shared in Analytic- and Calculation Views

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 - To perform Analytical reporting in SAP Business Objects on the top of HANA views, which of the below BI reporting tools can be directly connected to HANA system?

A - Dashboard

B - SAP Lumira

C - WebI Report

D - All of the above

Answer : B

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 - In SAP HANA Data Modeling, where do you define hierarchies, variables/parameters while creating a Modeling view?

A - Semantic

B - Data foundation

C - Output pane

D - Properties pane

E - Star Join

Answer : A

Explanation

In Semantic, you can define Hierarchies, parameters/variables.

Q 9 - When an Analytic View is joined to attribute views, is both the OLAP and JOIN Engine used?

A - True

B - False

Answer : B

Explanation

Only the OLAP engine will be used

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