Introduction

SAP and SAP technology provides enormous opportunity in IT industry. With increasing operations and market, the need of SAP functional consultants has observed sharp increase in job opportunities. The main job profile for SAP functional consultants is primarily based on SAP HANA (including MTA and CAP). In this article we will discuss the basic questions asked by interviewers from both technical as well as functional consultants of different years of experiences.

Basic SAP HANA Interview Questions

1. Explain SAP HANA.
2. What is the difference between Row Storage and Column Storage in SAP HANA?
3. What is a Schema in SAP HANA?
4. Explain different types of views in SAP HANA.
5. Explain ADBC (ABAP Data base Connectivity).
6. How to create a table in SAP HANA.

Advance SAP HANA Interview Questions

1. What is the meaning of In-memory computing in SAP HANA?
2. Explain the use of replication server.
3. Explain persistence layer in SAP HANA.
4. Explain the architecture of SAP HANA.
5. What is the concept of sizing in SAP HANA?
6. Explain SAP HANA System Monitor.
7. Explain SAP HANA Information Modeler.
8. What are types of Information View in SAP HANA?
9. Explain types of HANA engines.
10. Explain different types of joins in SAP HANA.
11. Explain the concept of packages in SAP HANA.

SAP HANA MTA Questions

1. What are cross MTA dependencies of SAP HANA?
2. Explain MTA Deployment Descriptor.
3. How SAP HANA fits into SAP MTA (Multi Target Application)?
4. How to create authentication (UAA) instance or an SAP HANA service instance in SAP MTA?
5. How SAP HANA DB Interacts with Java/Node.JS as well as Fiori Application in SAP MTA?

SAP HANA CAP Questions

1. How to use SAP CAP to expose HANA Cloud Tables as OData services?
2. How to deploy HANA over SAP CAP Module?
3. How to create database model in SAP CAP (Cloud Application Programming)?
4. How to use CAP and SAP Cloud SDK to Extend S/4HANA?
5. How to setup mock S/4 HANA Service in CAPM?