Question 620
A data architect recommends this approach: Use an ETL stage that transforms or masks the data before loading. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for ETL before landing. The reporting target receives already-prepared information.
Incorrect Answers
The other situation is better matched to Use Data Factory capabilities within Microsoft Fabric. Integrated Fabric pipelines and dataflows can prepare data for downstream workloads.
The other situation is better matched to Use a Fabric Data Warehouse. Analysts can query curated dimensional and fact tables with SQL semantics.
The other situation is better matched to Run the transformation as a scheduled batch analytics job. A bounded set of accumulated events is processed at the planned interval.