Question 600
A data architect recommends this approach: Use Azure Databricks with Apache Spark for the transformation workload. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for Databricks Spark. Parallel distributed processing handles larger-than-single-server transformations.
Incorrect Answers
The other situation is better matched to Partition analytical data using an appropriate time-based partition strategy. Queries can scan fewer partitions when predicates match the partition layout.
The other situation is better matched to Load new or changed records incrementally using a reliable change marker. Repeated ingestion can process a smaller changed subset rather than the full history.
The other situation is better matched to Store the raw extracts in a bronze or raw lake zone. Original records remain available for replay and audit of downstream transformations.