31. What is Data Tiering Optimization (DTO)?
Manages hot, warm, cold data tiers using extension nodes or external storage.
32. What is Multi-tenant Database (MDC)?
Multiple isolated tenant DBs in one HANA container.
33. What is SAP HANA System Replication?
Disaster recovery setup that replicates DB to secondary site.
34. Sync vs Async Replication?
- Sync: Zero data loss, slower.
- Async: Fast, minimal impact, but small data loss possible.
35. What is SAP SLT?
SAP Landscape Transformation — real-time replication of data from ECC/S4 to HANA.
36. Difference ETL vs ELT?
- ETL: Transform before loading.
- ELT: Load raw data, transform in DB (HANA uses ELT often).
37. What are SQL Plan Cache and Expensive Statements Trace?
Performance tools to identify slow queries.
38. What is Table Delta Store?
Stores recent changes before they are merged into main store.
39. What is SAP HANA AFL?
Application Function Library — advanced algorithms like predictive, planning, PAL, APL.
40. What is SAP HANA Graph?
Graph processing engine used for network analysis.