• SAP HANA Video Tutorials

SAP HANA Mock Test



This section presents you various set of Mock Tests related to SAP HANA. You can download these sample mock tests at your local machine and solve offline at your convenience. Every mock test is supplied with a mock test key to let you verify the final score and grade yourself.

Questions and Answers

SAP HANA Mock Test I

Q 1 - To perform complex calculations and aggregations, which of the table type is preferred?

A - Row Store

B - Column Store

C - Depends on Dimension table

D - All of the above are true

Answer : B

Explanation

Column base tables are preferred to perform aggregations and calculations as similar data type comes together.

Answer : D

Explanation

Target table should have same columns and data types otherwise you can use a new template table option.

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

Explanation

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

Q 6 - In a Query panel, Report developer wants to add multiple conditions in a Where clause statement. Which of the operator type should be used?

A - Arithmetic Operator

B - Relational/Comparison Operator

C - Logical/Boolean Operators

D - Set Operator

Answer : C

Explanation

SELECT empno, ename, sal FROM emp WHERE sal >= 1500 AND sal <= 3000; SELECT empno, ename, sal FROM emp WHERE deptno = 10 OR deptno = 20;

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 8 - A SAP HANA developer wants to create HTML application and to host it on web server in HANA. Which of the below component in HANA architecture can be used by Web applications to access HANA database?

A - Index Server

B - Name Server

C - XS Engine

D - SAP Host Agent

Answer : C

Explanation

XS Engine allows external applications to access the SAP HANA system via the XS Engine clients. It allows UI5 based applications to use SAP HANA via http/https or other protocols.

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 10 - SAP HANA Administrator is using instance 00 to connect to HANA Studio. Which port is used in HANA system for this instance?

A - Port 30015

B - Port 3615

C - SSh port

D - Port 31015

Answer : A

Explanation

  • Port 3615 should be open to connect to Database
  • Port 31015 Instance No 10
  • Port 30015 Instance No 00
  • SSh port should also be opened.

Q 11 - 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 12 - 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

Answer Sheet

Question Number Answer Key
1 B
2 D
3 A
4 C
5 A
6 C
7 B
8 C
9 B
10 A
11 B
12 C
sap_hana_questions_answers.htm
Advertisements