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?
In Star schema, you have one fact table and multiple dim tables.
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 - 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?
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 - Which of the below is used to handle queries and manipulates multidimensional data stored in OLAP cubes?
HANA can act as both relational as well as OLAP. When we use BW on HANA then we create cubes in BW and HANA will act as relational database and it will always produce a SQL Statement but when we directly access HANA views using OLAP connection then it will act as OLAP and MDX will be generated.
Q 5 - In SAP Data Services to replicate the data from SAP ECC to HANA database, which data store type should be used to create a data store for ECC and HANA system?
For ECC system, use SAP Applications while creating a datastore.
For SAP HANA, use Database as store type while creating a data store.
Q 6 - Which of the below privilege type is used for Backup/Restore, User Administration, Instance start and stop, etc.?
System privileges are used for Backup/Restore, User Administration, Instance start and stop, etc.
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 - In SAP HANA Data Modeling, where do you define hierarchies, variables/parameters while creating a Modeling view?
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?
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?
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