Associate Data Practitioner

By Google · Question Mode

QuestionQ56

Data Preparation and Ingestion

You are working with a small dataset in Cloud Storage that must be transformed and loaded into BigQuery for analysis. The transformation includes simple filtering and aggregation operations. You want to use the most efficient and cost-effective approach for data manipulation. What should you do?

Explanation

BigQuery supports loading data from Cloud Storage and transforming it with SQL. For a small workload involving simple filters and aggregations, this ELT approach avoids the additional infrastructure, operational overhead, and cost of a Dataproc cluster, Dataflow pipeline, or Cloud Data Fusion instance. Google Cloud generally recommends ELT for most customers and identifies BigQuery SQL as appropriate for transformations after loading.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!