![SAP HANA Tutorial](/sap_hana/images/sap-hana-mini-logo.jpg)
- 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.
![Questions and Answers](/images/questions_and_answers.png)
Q 1 - In SAP HANA Data replication, replicating data from a table in ECC system to HANA database, target table should have?
A - Equal number of columns in target table as of source system
B - Name of columns should be same in Target table
C - Target system data definition doesn't matter and it prints null for blank values
Answer : D
Explanation
Target table should have same columns and data types otherwise you can use a new template table option.
Q 2 - Which of the below statement is true about Union and Union All set operators?
A - Union prints all the rows from both the tables.
Answer : B
Explanation
UNION is used to combine the results of two or more Select statements. However it will eliminate duplicate rows
Union All
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?
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 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 - To recover SAP HANA database to the specific point, which of the below recovery type should be used?
Answer : B
Explanation
Point in Time.
Q 6 - Which of the below privilege type is used for Backup/Restore, User Administration, Instance start and stop, etc.?
Answer : B
Explanation
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?
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 - Consider a SAP HANA system with a permanent license which is about to expire. How many days an administrator has to get it renew after the permanent license is expired.
Answer : A
Explanation
Permanent License keys are valid till the predefine expiration date. License keys specify amount of memory licensed to target HANA installation. They can installed from SAP Market place under Keys and Requests tab. When a permanent License key is expired, a temporary license key is issued which is valid for only 28 days. During this period you have to install a permanent License key again.
Q 9 - Which of the below Modeling view in SAP HANA is specifically designed to execute Star schema queries?
Answer : B
Explanation
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 - 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.