You are responsible for a large data analytics project where you'll be using BigQuery. The source data is in Avro format stored in Google Cloud Storage. Your priority is to minimize the query cost. What should you do?
Choose an answer
Tap an option to check your answer.
Correct answer: Load the Avro files into BigQuery tables using batch loads.
Why this is the answer
*Explanation:* The most cost-effective approach for minimizing query cost when working with Avro data in BigQuery is to **load the Avro files into BigQuery tables using batch loads (option D)**. Federated queries (option A. can be more costly, streaming data loads (option B. are expensive for large datasets, materialized views (option C. still have the overhead of source Avro data, and using Dataflow (option E) adds additional processing cost.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed