1.
Your business wants to expose SAP S/4HANA CDS views in Datasphere for analytical modeling, but key figures are not aggregating correctly. How do you troubleshoot the semantic layer?
2.
You created a Datasphere View, but the performance is slow when consumed in SAC. What optimization techniques would you apply (joins, cache, federation vs replication)?
3.
A business user wants self-service data access but must only see data for their region. How would you implement Data Access Controls (DAC)?
4.
SAP S/4HANA is on-premise and you need real-time replication into Datasphere. Which Connection Type and Replication Flow settings do you use?
5.
Your Fact and Dimension tables are causing a “circular join” error. How do you redesign the model?
6.
A new requirement needs to combine SAP data with non-SAP data from Snowflake. How do you design the Datasphere Space architecture?
7.
The business wants a star schema but your source system provides only denormalized tables. How would you build the Consumption Model?
8.
A Data Flow failed due to schema drift in the source table. How do you handle schema evolution?
9.
You need to expose a Datasphere model to SAP Analytics Cloud but only a subset of measures must be visible. How do you control model exposure?
10.
A replication task is stuck in “Initial Load”. How do you troubleshoot the Data Flow Monitor?
11.
The customer wants SCD Type-2 history tracking for their Master Data in Datasphere. How do you design the flow?
12.
Your business wants row-level lineage to track data transformations end-to-end. How do you enable lineage and track impact analysis?
13.
Datasphere fails to connect to SAP BW/4HANA via ODP. What configuration do you verify at both the Datasphere and BW sides?
14.
You need to apply complex transformations (regex, loops, API calls). Would you use a Data Flow or a Python Operator? Explain the decision.
15.
A Datasphere Space is running out of storage. How do you optimize space usage and archiving?
16.
The business needs real-time KPIs updated every few seconds. How would you design streaming integration (Kafka / Event Mesh → Datasphere)?
17.
A Dimension view is not recognized correctly in the star schema. How do you fix the semantic type and primary key issues?
18.
Your data load into Datasphere is failing due to timezone mismatches. How do you standardize timestamps?
19.
You need to publish a Datasphere model as an SQL endpoint for an external application. How do you expose it?
20.
Your developers need Git-based version control for Datasphere artifacts. How would you set up Transport & Release Management?
21.
During consumption, a query runs slow due to federated access to S/4HANA. When would you switch to replication?
22.
Data duplication is observed after multiple loads. How do you design a delta load mechanism in Data Flows?
23.
A consumer Space must access objects from a Provider Space but should not modify them. How do you configure cross-space sharing?
24.
Datasphere does not allow editing a shared object because it’s locked by another user. How do you resolve object locking conflicts?
25.
The customer wants to migrate SAP BW InfoProviders to Datasphere. What is your migration strategy (federation vs transformation vs redesign)?