41. What is SAP HANA Spatial?
Geospatial engine used for maps, GPS, transport, route optimization.
42. What is HANA Cloud vs On-Premise?
- Cloud: Fully managed, elastic scaling.
- On-Premise: Customer-managed.
43. What is SQL Optimizer?
Component that chooses best execution plan, indexes, joins.
44. What is Join Pruning?
Optimizer removes unnecessary joins to improve performance.
45. What is Query Pushdown?
Pushing execution logic to HANA DB instead of app server for faster performance.
46. What are Calculation Engine and OLAP Engine?
Engines for executing complex modeling and analytical logic.
47. What is Memory Footprint?
Amount of RAM consumed by tables, caches, runtime.
48. What is Hot, Warm, Cold Data?
- Hot: In-memory
- Warm: Extension nodes
- Cold: NLS/External storage
49. What is Data Aging?
Technique to move older data to warm storage while keeping hot data for transactions.
50. What is SAP HANA Cockpit Alerts?
Pre-configured alerts for performance, availability, memory, CPU, replication.