Google Exam Associate Cloud Engineer Topic 2 Question 111 Discussion

Actual exam question for Google's Associate Cloud Engineer exam

Question #: 111
Topic #: 2

[All Associate Cloud Engineer Questions]

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?

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 table after you complete your request.

CCreate external tables in BigQuery that point to Cloud Storage buckets and run a SQL query on these external tables to complete your request.

DCreate a Hadoop cluster and copy the AVRO file to NDFS by compressing it. Load the file in a hive table and provide access to your analysts so that they can run SQL queries.

Show Suggested Answer

Suggested Answer: C

https://cloud.google.com/bigquery/external-data-sources

An external data source is a data source that you can query directly from BigQuery, even though the data is not stored in BigQuery storage.

BigQuery supports the following external data sources:

Amazon S3

Azure Storage

Cloud Bigtable

Cloud Spanner

Cloud SQL

Cloud Storage

Drive

by Ashleigh at Aug 18, 2025, 04:36 AM

Limited Time Offer

25%

Off

Get Premium Associate Cloud Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!