Exam Associate-Data-Practitioner Topic 2 Question 6 Discussion

Dataform workflowsare the ideal solution for migrating batch transformation pipelines to Google Cloud when you want to perform programmatic transformations using only SQL. Dataform allows you to define SQL- based workflows for data transformations and supports Git integration for version control, enabling collaboration and version tracking of your pipelines. This approach is purpose-built for SQL-driven data pipeline management and aligns perfectly with your requirements.
The solution must use SQL for transformations and integrate with Git for version control, focusing on batch pipelines. Let's evaluate:
* Option A: Cloud Data Fusion uses a visual UI with plugins, not SQL-only transformations. It lacks native Git integration (requires external tools), missing a key requirement.
* Option B: Dataform is a SQL-based workflow tool for BigQuery transformations, defining pipelines as SQLX scripts. It integrates natively with Git for version control, supporting batch ELT processes with minimal overhead.
* Option C: Cloud Composer uses Python DAGs and operators, not SQL-only transformations. Git is possible but not intrinsic to its workflow design.