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?
5. What are the Data Provisioning Technologies available to replicate data to HANA?
6. What are the different editions available in HANA appliance Software?
Ans: Platform 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?
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.