- SAP HANA Tutorial
- SAP HANA - Home
- SAP HANA Introduction
- SAP HANA - Overview
- In-Memory Computing Engine
- SAP HANA - Studio
- Studio Administration View
- SAP HANA - System Monitor
- SAP HANA - Information Modeler
- SAP HANA - Core Architecture
- SAP HANA Modeling
- SAP HANA - Modeling
- SAP HANA - Data Warehouse
- SAP HANA - Tables
- SAP HANA - Packages
- SAP HANA - Attribute View
- SAP HANA - Analytic View
- SAP HANA - Calculation View
- SAP HANA - Analytic Privileges
- SAP HANA - Information Composer
- SAP HANA - Export and Import
- SAP HANA Reporting
- SAP HANA - Reporting View
- Bi 4.0 Connectivity to HANA Views
- SAP HANA - Crystal Reports
- SAP HANA - Excel Integration
- SAP HANA Security
- SAP HANA - Security Overview
- User Administration & Management
- SAP HANA - Authentications
- SAP HANA - Authorization methods
- SAP HANA - License Management
- SAP HANA - Auditing
- SAP HANA Data Replication
- SAP HANA - Data Replication Overview
- SAP HANA - ETL Based Replication
- SAP HANA - Log Based Replication
- SAP HANA - DXC Method
- SAP HANA - CTL Method
- SAP HANA - MDX Provider
- SAP HANA Monitoring
- SAP HANA - Monitoring and Alerting
- SAP HANA - Persistent Layer
- SAP HANA - Backup & Recovery
- SAP HANA - High Availability
- SAP HANA - Log Configuration
- SAP HANA SQL
- SAP HANA - SQL Overview
- SAP HANA - Data Types
- SAP HANA - SQL Operators
- SAP HANA - SQL Functions
- SAP HANA - SQL Expressions
- SAP HANA - SQL Stored Procedures
- SAP HANA - SQL Sequences
- SAP HANA - SQL Triggers
- SAP HANA - SQL Synonym
- SAP HANA - SQL Explain Plans
- SAP HANA - SQL Data Profiling
- SAP HANA - SQL Script
- SAP HANA Useful Resources
- SAP HANA - Questions and Answers
- SAP HANA - Quick Guide
- SAP HANA - Useful Resources
- SAP HANA - Discussion
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 - 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?
Answer : A
Explanation
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 - In SAP HANA Data Replication, Which of the below is a trigger based method for data provisioning and used for real time business scenarios in HANA database?
Answer : B
Explanation
SAP LT uses trigger based approach: has no measureable performance impact in source system.
It provides transformation and filtering capability.
It allows real-time (and scheduled) data replication, replicating only relevant data into HANA from SAP and non-SAP source systems.
It is fully integrated with HANA Studio.
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?
Answer : D
Explanation
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 - You have create a Universe on the top of HANA database to create reports in Web Intelligence. Which of the connection type can be used to publish Universe in Repository?
Answer : B
Explanation
.cns- connection type represents secured Repository connection that should be used to create Data foundation.
.cnx-represents local unsecured connection and if you use this connection while creating a Universe and while publishing Universe it will not allow you to publish that to repository.
Q 7 - Which of the below migration method in SAP HANA allows you to export multiple packages to remote HANA server?
Answer : D
Explanation
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 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 9 - Which of the below option can be used to check the configuration, current alerts, all services running and manufacturer details in HANA system?
Answer : B
Explanation
Administration tab is used to get all the details- about manufacturer, services running, alerts, performance, volumes, etc.
Q 10 - While creating a Relational connection to HANA database, where you can define connection pool time out details?
Answer : B
Explanation
This is defined in Connection parameters – Time out, array fetch size, batch size, etc.
To Continue Learning Please Login
Login with Google