SAP HANA Online Quiz

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.

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.

Q 2 - 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;

Q 3 - A SAP HANA developer has two tables and while joining the tables he is getting output as number of rows in table A multiplied by table B. Which of the below Join type is used?

Answer : A

Explanation

CROSS JOIN produces a result set which is the number of rows in the first table multiplied by the number of rows in the second table, if no WHERE clause is used along with CROSS JOIN. This kind of result is called as Cartesian Product.

Q 4 - In SAP HANA Modeling, to copy an existing view and without making any changes to it, which of the below option should be used?

Answer : B

Explanation

Copy from − If you want to use already existing attribute view s template then go for this(you can modification if required for current one).

Derived − This is kind of reference type. You cannot do modifications to the current one (Do the changes for main one).

Q 5 - To connect Microsoft Excel to HANA Modeling views, which of the below can be used for direct connectivity to create reports?

Answer : A

Explanation

MDX Provider

Q 6 - In SAP HANA security, which of the below can be used to limit the data access based on the attributes and for a specific time period in Modeling Views?

A - Roles Management

B - Object Privilege

C - Analytic Privilege

D - System Privilege

E - Package Privilege

Answer : C

Explanation

Analytic Privileges are used to limit access on HANA Information views. You can assign different types of right to different users on different component of a View in Analytic Privileges.

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

Answer : A

Explanation

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

Q 9 - Which of the below Modeling view in SAP HANA is specifically designed to execute Star schema queries?

Answer : B

Explanation

Analytic views are designed to perform Star schema queries.

Analytic views contain atleast one fact table and multiple dimension tables with master data and perform calculations and aggregations.

They are similar to Info Cubes and Info objects in SAP BW.

Analytic views can be created on top of Attribute views and Fact tables and performs calculations like number of unit sold, total price, etc.

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