You have a large 5-TB AVRO file stored in a Cloud Storage bucket. Your analysts are proficient only in SQL and need access to the data stored in this file. You want to find a cost-effective way to com

The correct answer is C. Create external tables in BigQuery that point to Cloud Storage buckets and run a SQL query on. An external data source (also known as a federated data source) is a data source that you can query directly even though the data is not stored in BigQuery. Instead of loading or streaming the data, you create a table that references the external data source. https://cloud.google

Submitted by anna_se· Mar 30, 2026Planning and configuring a cloud solution

Question

You have a large 5-TB AVRO file stored in a Cloud Storage bucket. Your analysts are proficient only in SQL and need access to the data stored in this file. You want to find a cost-effective way to complete their request as soon as possible. What should you do?

Options

ALoad data in Cloud Datastore and run a SQL query against it.
BCreate a BigQuery table and load data in BigQuery. Run a SQL query on this table and drop this
CCreate external tables in BigQuery that point to Cloud Storage buckets and run a SQL query on
DCreate a Hadoop cluster and copy the AVRO file to NDFS by compressing it. Load the file in a

How the community answered

(26 responses)

A
4% (1)
B
4% (1)
C
81% (21)
D
12% (3)

Explanation

An external data source (also known as a federated data source) is a data source that you can query directly even though the data is not stored in BigQuery. Instead of loading or streaming the data, you create a table that references the external data source. https://cloud.google.com/bigquery/external-data-sources

Topics

#BigQuery#external tables#Cloud Storage#AVRO

Community Discussion

No community discussion yet for this question.

Full ASSOCIATE-CLOUD-ENGINEER Practice