SAP HANA - Home

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

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 - In SAP HANA Modeling, which of the view type provides Modeler with an inbuilt nodes-Projection, Join, Union and Rank?

Answer : C

Explanation

Graphical Calculation Views

Can consume other Analytical, Attribute, other Calculation Views & tables Built-in Union, Join, Projection & Aggregation nodes

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?

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?

Answer : A

Explanation

MDX Provider

Q 6 - In SAP HANA database, an administrator can see that log area is filling continuously and causing database to hang. What can be done to fix this issue?

A - Limit File Size

B - Use backint destination type

C - Enable Automatic log backup

D - Use 3^rd party backup tool

Answer : C

Explanation

Enable Automatic log backup option: It helps you to keep log area vacant. If you disable this log area will continue to fill and that can result database to hang.

Q 7 - While creating a SAP HANA Modeling view, which user parameter allows you to add a new field in the Data Preview that doesnt 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 doesnt exist in database or view level.

Q 8 - While performing SAP HANA data Replication using SLT method, which of the below is not a supported mode?

Answer : E

Explanation

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 - Which of the below user can access HANA system via HTTP/HTTPS applications and doesnt have access to create objects in schema in HANA database?

Answer : C

Explanation

Restricted users are those users who access HANA system with some applications and they dont have SQL privileges on HANA system. When these users are created they dont have any access initially.

If we compare restricted users with Standard users −

Restricted users cant create objects in HANA database or their own Schemas.

They dont have access to view any data in database as they dont have generic Public role added to profile like standard users.

They can connect to HANA database only using HTTP/HTTPS

sap_hana_questions_answers.htm