- 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 differences between OLTP and OLAP system, which of the below statement is incorrect about an OLAP system?
A - It has more indexes as compared to an OLTP system
B - It process historical data
Answer : C
Explanation
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 - SAP HANA Administrator is using instance 00 to connect to HANA Studio. Which port is used in HANA system for this instance?
Answer : A
Explanation
- Port 3615 should be open to connect to Database
- Port 31015 Instance No 10
- Port 30015 Instance No 00
- SSh port should also be opened.
Q 3 - In SAP HANA database, while creating a new column base table we can define a null value for a Primary key?
Answer : B
Explanation
A Primary key is always unique and not null.
Q 4 - Which of the below component in HANA system architecture ensures database is restored to most recent state and ensures that all the transactions are completed?
A - Transaction and Session Management
Answer : D
Explanation
The database persistence layer is responsible for durability and atomicity of transactions.
It ensures that the database can be restored to the most recent committed state after a restart and that transactions are either completely executed or completely undone.
Q 5 - In SAP HANA Job based replication, which of the below can be used to add a schedule, to trace, monitor and error check a replication job?
B - Data Service Repository Manager
Answer : C
Explanation
Data Service Management Console You can trace, monitor, error check replication jobs in repository.
Q 6 - In SAP HANA security, which of the below can be used to limit the data access based on the attributes and for a specific time period in Modeling Views?
Answer : C
Explanation
Analytic Privileges are used to limit access on HANA Information views. You can assign different types of right to different users on different component of a View in Analytic Privileges.
Q 7 - To provide unfiltered read only access to all system views, which of the below system privilege type should be added to user profile?
Answer : B
Explanation
It authorizes users to have unfiltered read-only access to all system views.
Normally, the content of these views is filtered based on the privileges of the accessing user.
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 - When an Analytic View is joined to attribute views, is both the OLAP and JOIN Engine used?
Answer : B
Explanation
Only the OLAP engine will be used
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.