1️⃣ You need to migrate on-premise SAP HANA to SAP HANA Cloud with minimal downtime. What migration strategy will you use?
Discuss HCMT, HDI containers, smart data integration, backup/restore limitations, near-zero downtime migration.
2️⃣ Query performance in SAP HANA Cloud has dropped after migrating models from on-prem HANA. How do you analyze and fix it?
Check SQL Analyzer, PlanViz, column store compression, buffer cache, workload class.
3️⃣ Your customer wants to integrate SAP HANA Cloud with S/4HANA and external SQL systems. How do you design the architecture?
Explain SDI, SDQ, DP Agent, virtual tables, federated queries.
4️⃣ A calculation view in HANA Cloud is running slow. Describe your step-by-step troubleshooting.
Look at pruning, join cardinality, performance tracing, in-memory configuration.
5️⃣ The data lake in HANA Cloud is not syncing with the main in-memory store. How do you diagnose the issue?
Check Remote Table Replication, Replication Flow, SDI monitors.
6️⃣ Customer requires row-level security for multiple business units. How do you implement it?
Use analytic privileges, SQL roles, data masking, row-level filters.
7️⃣ A model in HANA Cloud requires ML forecasting. Which approach do you choose?
Options: PAL/APL, HANA ML APIs, BTP AI Core, Python containers.
8️⃣ When connecting Power BI to HANA Cloud, reports are extremely slow. What optimizations are needed?
Use Calculation Views, in-built measures, avoid data extraction, use MDX / SQL.
9️⃣ You need to expose HANA Cloud data securely to a BTP application. How do you configure it?
Use HDI roles, XSUAA, OAuth, privilege propagation.
1️⃣0️⃣ A large table in HANA Cloud is consuming too much memory. How do you optimize?
Use compression techniques, partitioning, merging delta, tiering to data lake.
1️⃣1️⃣ You are asked to design a multi-environment landscape (Dev/QAS/Prod) for HANA Cloud. What is the recommended setup?
Use subaccounts, HDI containers, transport management, git-based CI/CD.
1️⃣2️⃣ Virtual tables with SDI show latency. How do you tune them?
Check adapters, DP Agent, network issues, replication mode.
1️⃣3️⃣ You need automatic data retention and archival for compliance. How do you implement it?
Use data tiering, data lake, TTL policies, partition strategy.
1️⃣4️⃣ Customer complains that full backups consume too much storage. What do you recommend?
Use incremental backups, configuration flows, and retention policy tuning.
1️⃣5️⃣ You want to restrict developers from accessing raw tables but allow model consumption. How do you configure privacy?
Use HDI container privileges, restricted roles, object owner vs application user.
1️⃣6️⃣ System shows “out of memory” errors during heavy ETL loads. What is your remediation plan?
Adjust workload classes, table partitioning, remove unnecessary materialized views.
1️⃣7️⃣ A replication flow between HANA Cloud and S/4HANA is failing. How do you debug?
Check monitoring dashboard, credentials, communication arrangement, field mapping.
1️⃣8️⃣ SAP Analytics Cloud live model is slow with HANA Cloud. What do you optimize?
Optimize views, use star-join view, correct join types.
1️⃣9️⃣ You need to build a data mart on HANA Cloud for multiple LoBs. What design would you follow?
Layered architecture: Raw → Cleansed → Consumption, HDI containers.
2️⃣0️⃣ A critical business query must run under 2 seconds. How do you guarantee performance?
Performance tuning, workload class, caching, SQL optimizations.
2️⃣1️⃣ You must expose a calculation view to external apps via OData. What approach do you use?
Use XSODATA, BTP CAP, HDI container service bindings.
2️⃣2️⃣ You discover circular joins in a calculation view. How do you fix them?
Rewrite as graphical + SQL scripted views, change join order, apply pruning.
2️⃣3️⃣ You need real-time CDC replication into HANA Cloud from Oracle. What do you use?
Use SDI Log Reader Adapter, ODBC, or SLT if ERP-based.
2️⃣4️⃣ Data masking is required for PII fields. How will you implement it?
Use SQL data masking, analytic privileges, role-based access.
2️⃣5️⃣ Customer wants to scale HANA Cloud compute dynamically for quarter-end load. How do you configure it?
Explain elastic scaling, multi-tier memory, workload class, autoscaling rules.