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 the Data Modeling concept in HANA, Which of the below statement is incorrect about Schema?
A - In Star Schema, you can have multiple fact tables and Dim tables
B - In Star Schema, Dim tables are not normalized
C - In Galaxy Schema, you have multiple fact tables and multiple Dim tables.
D - In Snowflakes schema, you have multiple Dim tables in normalized form.
Answer : A
Explanation
In Star schema, you have one fact table and multiple dim tables.
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?
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 - 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?
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 - To manage remote objects from Teradata, Sybase IQ and Hadoop in HANA database, which of the below option can be used?
Answer : A
Explanation
SAP Smart data access
Q 8 - Which of the below option in HANA system allows you to perform analysis like Raw data, distinct value, etc. on a database table or on a Modeling view?
Answer : C
Explanation
Data Preview gives you 3 options- Raw Data, distinct values, analysis.
Q 10 - To get multiple measures from different tables, which of the below is most suitable view type to be used in HANA Modeling?
Answer : C
Explanation
Calculation Views are used to consume other Analytic, Attribute and other Calculation views and base column tables. These are used to perform complex calculations which are not possible with other type of Views including implementing Galaxy schema.
