Quiz Answer Key

1. SAP HANA is a comprehensive suite that combines the HANA Database, Data Modeling, HANA Administration, and Data Provisioning. The acronym “HANA” officially stands for High-Performance Analytic Appliance, although former SAP executive Dr. Vishal Sikka also stated it stands for Hassos New Architecture.
2. An In-Memory Computing Engine stores all data from the source system in RAM memory, eliminating the time needed to load data from a hard disk. This provides significantly faster data access, with memory reads being up to 1 million times faster than in a conventional disk-based database.
3. The Index Server is the core component of the SAP HANA database system, containing the actual data and the engines for processing it. It handles all SQL and MDX query requests, manages transactions and sessions, and contains the Persistence Layer responsible for data durability.
4. Row store tables are preferred when SQL queries need to return a complete row, as data is stored horizontally. Column store tables, where data is stored vertically, are performance-optimized for queries involving aggregate functions (like Sum, Count, Max) and calculations, as the query only needs to access the specific columns involved.
5. The three types of Information Views are Attribute Views, Analytic Views, and Calculation Views. Attribute Views represent master data, Analytic Views are used for star schema queries with calculations on a fact table, and Calculation Views are used to perform complex calculations on top of other views.
6. SAP HANA Studio is an Eclipse-based client tool that serves as the central development environment and main administration tool for a HANA system. Its three main perspectives are SAP HANA Studio Administration for administration tasks, SAP HANA Studio Database Development for content development like DataMarts, and SAP HANA Studio Application Development for creating native applications.
7. A Delivery Unit is a single, transportable entity that can be mapped to multiple packages within SAP HANA. It allows users to export all assigned packages and their relevant objects as a single unit to a server or local client, simplifying the process of moving content between systems.
8. Analytic Privileges are a security feature used to limit user access to data within HANA Information Views. They enforce row and column-level security on the attributes of a view, ensuring that users can only see the specific data for which they are authorized.
9. The three main data replication methods mentioned are SAP LT Replication (a trigger-based method for real-time replication), ETL Based Replication (using SAP Business Object Data Services – BODS), and Direct Extractor Connection (DXC) method (a batch-driven technique reusing existing BI extractors).
10. SQL Scripts are a set of SQL extensions that allow developers to push complex application logic into the HANA database. They optimize performance by executing complex calculations directly at the database layer, which eliminates the need to transfer large datasets to the application layer and takes full advantage of HANA’s processing power.

——————————————————————————–