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.

Questions and Answers

Answer : D


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

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


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 database, while creating a new column base table we can define a null value for a Primary key?

A - True

B - False

Answer : B


A Primary key is always unique and not null.

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



Q 5 - Which of the below Data Replication method requires no additional server or application in the SAP HANA system landscape?


B - Data Service


D - Log based method

Answer : C


Reuses existing proprietary extraction, transformation, and load mechanism built into SAP Business Suite systems over a simple HTTP(S) connection to SAP HANA.

Requires no additional server or application in the system landscape (Simplicity)

Q 6 - Which of the below privilege type is used for Backup/Restore, User Administration, Instance start and stop, etc.?

A - Object Privileges

B - System Privileges

C - Package Privileges

D - Analytic Privileges

Answer : B


System privileges are used for Backup/Restore, User Administration, Instance start and stop, etc.

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


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?

A - Semantic

B - Data foundation

C - Output pane

D - Properties pane

E - Star Join

Answer : A


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?

A - Attribute View

B - Analytic View

C - Calculation View

D - Analytic View

Answer : B


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 user can access HANA system via HTTP/HTTPS applications and doesn’t have access to create objects in schema in HANA database?

A - Standard User

B - Public User

C - Restricted User

D - Power User

E - Application User

Answer : C


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

If we compare restricted users with Standard users −

Restricted users can’t create objects in HANA database or their own Schemas.

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

They can connect to HANA database only using HTTP/HTTPS