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 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 2 - 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 3 - 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
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?
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?
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?
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 - Which of the below migration method in SAP HANA allows you to export multiple packages to remote HANA server?
Delivery unit is a single Unit which can be mapped to multiple packages and can be exported as single entity so that all the packages assigned to Delivery Unit can be treated as single unit.
Users can use this option to export all the packages that make a delivery unit and the relevant objects contained in it to a HANA Server or to local Client location.
Q 8 - Which of the below is not an audit trial type while configuring an audit policy in HANA system?
Syslog(default) − Logging system of Linux Operating System.
Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.
CSV text − This type of audit trail is only used for test purpose in a non-production environment.
Q 9 - Which of the below component in SAP HANA Architecture distributed environment is used to store System landscape and topology information of system?
NAME server contains System Landscape information of HANA system. In distributed environment, there are multiple nodes with each node has multiple CPU’s, Name server holds topology of HANA system and has information about all the running components and information is spread on all the components.
Topology of SAP HANA system is recorded here.
It decreases the time in re-indexing as it holds which data is on which server in distributed environment.
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?
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