SAP Hana Interview Questions and Answers
Most Frequently Asked SAP Hana Interview Questions
SAP HANA platform replicates and ingests structured data from both SAP and non-SAP relational databases, applications and other systems rapidly. It uses in-memory database technology which allows the processing of massive amounts of real-time data in a shorter time period. SAP HANA is used to process an enormous amount of data in a short time. It also can be used to treat data stored in RAM as opposed to reading it from a disk.
Here are a few of the crucial advantages of using SAP HANA:
- Acquire customer-centric application
- Enhanced user experience
- Optimum data management
- A centralized process for fewer settlement issues
- Possibility to extend the ability of HANA
| S.no | SAP HANA | Oracle |
|---|---|---|
| 1. | It’s an in-memory, column-based data store. | It’s a relational database management system. |
| 2. | Server operating systems it uses appliance or cloud service. | Server operating systems it uses AIX, Linux, HP-UX, Solaris, Windows, and Solaris. |
| 3. | No XML support | Supports XML. |
| 4. | Server-side scripts used here is SQLScript and R. | Server-side scripts used here is PL/SQL. |
Here is the list of different data types used in SAP HANA.
- Date Times Types
- Numeric Types
- Boolean
- Character String
- Binary Types
- Large Object Types
- Multi-valued Types
SAP HANA Studio is an Eclipse-based IDE (Integrated Development Environment) which is used to develop artifacts in a HANA server. It enables technical users to manage the SAP HANA database better, to create new or modify existing data models and to develop and maintain user authorizations.
A set of global interviewer chosen SAP HANA interview questions as their best choice to be asked in the interviews.
Here are system requirements to install SAP HANA:
- CPU: Intel Xeon E5 – 26xx v2/v3 or Intel Xeon E7 – x8xx v1, 8 cores minimum, up to 1.5TB, 2 socket, and scale up only.
- RAM: minimum of 128 GB Ram to max memory supported by the system.
- Drives & Storage: Minimum 2 times of the memory.
- Operation system: SUSE Linux Latest or Red Hat Linux Latest
| S.no | Column Storage | Row Storage |
|---|---|---|
| 1. | Table records are stored in the sequence of columns. | Here the table records will be stored in a sequence of rows. |
| 2. | SAP HANA is primarily optimized for column store. | Used when the application requires to only process a single record at one time. |
In SAP HANA, Schema is used to categorize database content according to customer defined groupings which have a particular meaning for users. It also helps to determine access rights to the database objects.
There are three types of Schema used in SAP HANA:
- User Defined Schema
- System Defined Schema
- SLT Derived Schema
In SAP HANA, the master controller is used to create the database triggers and also for logging the table into the source system. A crucial role is played for the creation of the synonyms.
Here are the benefit highlights of SAP NW 7.5:
- Special dictionary tools for Eclipse
- Optimizations in HANA
- Introduction of common ABAP programming for analytical and transactional applications
- Support for Industry 4.0 scenarios
- Support of Eclipse 4.4 and Java 8 for SAP NetWeaver Developer Studio
- Support for Big Data
- Stable kernel
- In-app extensibility for S/4HANA
These above-mentioned SAP HANA interview questions and answers are suitable for both experienced as well as freshers.