Topic 1 Question 301
You are architecting a data transformation solution for BigQuery. Your developers are proficient with SQL and want to use the ELT development technique. In addition, your developers need an intuitive coding environment and the ability to manage SQL as code. You need to identify a solution for your developers to build these pipelines. What should you do?
Use Dataform to build, manage, and schedule SQL pipelines.
Use Dataflow jobs to read data from Pub/Sub, transform the data, and load the data to BigQuery.
Use Data Fusion to build and execute ETL pipelines.
Use Cloud Composer to load data and run SQL pipelines by using the BigQuery job operators.
ユーザの投票
コメント(3)
- 正解だと思う選択肢: A
- Aligns with ELT Approach: Dataform is designed for ELT (Extract, Load, Transform) pipelines, directly executing SQL transformations within BigQuery, matching the developers' preference. -SQL as Code: It enables developers to write and manage SQL transformations as code, promoting version control, collaboration, and testing.
- Intuitive Coding Environment: Dataform provides a user-friendly interface and familiar SQL syntax, making it easy for SQL-proficient developers to adopt.
- Scheduling and Orchestration: It includes built-in scheduling capabilities to automate pipeline execution, simplifying pipeline management.
👍 3raaad2024/01/06 - 正解だと思う 選択肢: A
A. Use Dataform to build, manage, and schedule SQL pipelines.
👍 2scaenruy2024/01/04 - 正解だと思う選択肢: A
Dataform = transformations in SQL
👍 1rahulvin2023/12/30
シャッフルモード