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.
Q 1 - To perform complex calculations and aggregations, which of the table type is preferred?
Column base tables are preferred to perform aggregations and calculations as similar data type comes together.
Q 2 - In SAP HANA Data replication, replicating data from a table in ECC system to HANA database, target table should have?
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?
Predictive analysis is about finding and quantifying hidden patterns in the data using complex mathematical models that can be used to predict future outcomes.
Q 4 - Consider the differences between OLTP and OLAP system, which of the below statement is incorrect about an OLAP system?
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.
Q 5 - Consider the Data Modeling concept in HANA, Which of the below statement is incorrect about Schema?
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?
SELECT empno, ename, sal FROM emp WHERE sal >= 1500 AND sal <= 3000; SELECT empno, ename, sal FROM emp WHERE deptno = 10 OR deptno = 20;
Q 7 - Which of the below statement is true about Union and Union All set operators?
UNION is used to combine the results of two or more Select statements. However it will eliminate duplicate rows
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?
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.
Q 9 - Which of the below statement is incorrect about HANA Studio?
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?
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.
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?
Graphical Calculation Views
Can consume other Analytical, Attribute, other Calculation Views & tables Built-in Union, Join, Projection & Aggregation nodes
|Question Number||Answer Key|