- 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
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 - To perform complex calculations and aggregations, which of the table type is preferred?
Answer : B
Explanation
Column base tables are preferred to perform aggregations and calculations as similar data type comes together.
Q 2 - A SAP HANA developer wants to create HTML application and to host it on web server in HANA. Which of the below component in HANA architecture can be used by Web applications to access HANA database?
Answer : C
Explanation
XS Engine allows external applications to access the SAP HANA system via the XS Engine clients. It allows UI5 based applications to use SAP HANA via http/https or other protocols.
Q 3 - In SAP HANA Modeling, Attributes views are used −
A) in Analytic and Calculation views.
B) represents master data.
C) are designed to perform Star schema queries
D) are used to filter size of dimension tables in Analytic and Calculation View
E) are defined either graphical using HANA Modeling feature or scripted in the SQL Choose the correct option.
Answer : B
Explanation
Attribute views are dimensions, BW characteristics or master data.
Attribute views are used to join to a dimension or attribute view.
In most cases used to model master data like entities (like Product, Employee, Business Partner)
Highly re-used and shared in Analytic- and Calculation Views
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 - Which of the below Data Replication method requires no additional server or application in the SAP HANA system landscape?
Answer : C
Explanation
Reuses existing proprietary extraction, transformation, and load mechanism built into SAP Business Suite systems over a simple HTTP(S) connection to SAP HANA.
Requires no additional server or application in the system landscape (Simplicity)
Q 6 - To perform Analytical reporting in SAP Business Objects on the top of HANA views, which of the below BI reporting tools can be directly connected to HANA system?
Answer : B
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 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 - 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?
Answer : C
Explanation
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