Tag Archives: SAP HANA Admin Interview Questions For Freshers

SAP HANA Admin Interview Questions and Answers

Our experts providing  SAP HANA Admin interview questions & Answers/Faqs can develop your carrier & knowledge to find the right job in a good MNC’s, doesn’t matter what kind of company you’re hired.

1. How do you perform BW-on-HANA Migration?

DMO- Database Migration. This is a new feature available in SUM(Software Update Manager Tool).

2. How many VMs are supported on a single HANA Production System?

Multiple SAP HANA Virtual Machines on a Single server are only supported today in non-production environments.

3. How do you install SAP HANA?

HDBLCM Tool – To install individual or multiple Hana Server Component.

4. What are the different perspectives available in HANA Studio?


5. What are the Data Provisioning Technologies available to replicate data to HANA?


6. What are the different editions available in HANA appliance Software?

Platform Edition
Enterprise Edition

7. How do you update SAP HANA Studio/Client & HANA Revisions?

1. Stop all processes
2. Make a System Backup if necessary
3. Perform an update
4. Update the depending Components
5. Perform the post update steps
6. Restart all processes

8. What is the maximum database size for virtual SAP HANA Appliance?

Cold Data can reside on disk for virtualized SAP HANA databases greater than 1 TB.

9. What are the tools to export Data from HANA to external System?

SLT – Database Migration Option
BODS – BO Data Services to export the data from HANA to external systems.

10. Will the table size in SAP HANA database and in the source system be the same?

No, Hana database supports compression.

11. What are the critical services HANA DB Server Consists?

Index Server
Name Server
Statistics Server
Preprocessor Server
XS Engine

12. What’s new with SPS09 – Admin Features?

SAP HANA Cockpit – Web-based tool for administration and monitoring of a single SAP HANA Database.

SAP DB Control Center  – Web-based tool for administration and monitoring of your landscape of SAP Database.

New/Enhanced Monitoring Views

SAP HANA Multitenant Database Containers

Improved Resource Monitoring

13. HANA in HA or Distribution Environment Terminology?

Name Server will have master and slave nodes.
Index Server will have workers and standby nodes……..For more  Click Here

For Course Content  Click Here

Top ↑