Google Cloud Associate Data Practitioner — Question 29

Your company is migrating their batch transformation pipelines to Google Cloud. You need to choose a solution that supports programmatic transformations using only SQL. You also want the technology to support Git integration for version control of your pipelines. What should you do?

Answer options

• A. Use Cloud Data Fusion pipelines.
• B. Use Dataform workflows.
• C. Use Dataflow pipelines.
• D. Use Cloud Composer operators.

Correct answer: B

Explanation

The correct choice is B, as Dataform workflows are specifically designed for SQL-based transformations and offer Git integration for version control. Options A, C, and D do not focus primarily on SQL transformations or lack the necessary Git integration for effective version management.