Register Login

SAP HANA Admin Interview Question and Answers

Updated May 18, 2018

SAP HANA Admin FAQs

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

Ans: 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?

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

3. How do you install SAP HANA?

Ans: HDBLCM Tool - To install individual or multiple Hana Server Component.

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

Ans:

  • Administrator
  • Modeler
  • Development
  • Debug

5. What are the Data Provisioning Technologies available to replicate data to HANA?
Ans:
SLT
BODS
SXC

6. What are the different editions available in HANA appliance Software?
Ans: 
Platform Edition 
Enterprise Edition

7. How do you update SAP HANA Studio/Client & HANA Revisions?
Ans:
Use HDBLCM Tool
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?
Ans:
1 TB RAM
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?
Ans:
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?
Ans:
No, Hana database supports compression.

11. What are the critical services HANA DB Server Consists?
Ans:
Index Server
Name Server
Statistics Server
Preprocessor Server
XS Engine

12. What’s new with SPS09 - Admin Features?
Ans: 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?
Ans:
Name Server will have master and slave nodes.
Index Server will have workers and standby nodes.

Read Here for More SAP HANA Interview Questions.


×