Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Associate Cloud Engineer Exam - Topic 2 Question 111 Discussion

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?
C) Create external tables in BigQuery that point to Cloud Storage buckets and run a SQL query on these external tables to complete your request.
A) Load data in Cloud Datastore and run a SQL query against it.
B) Create a BigQuery table and load data in BigQuery. Run a SQL query on this table and drop this table after you complete your request.
D) Create 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.

Google Associate Cloud Engineer Exam - 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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Madelyn
9 months ago
Wait, why not just use external tables? C seems easier.
upvoted 0 times
...
Herman
9 months ago
Definitely B! Quick and cost-effective.
upvoted 0 times
...
Carmela
9 months ago
Surprised there's no mention of using Dataflow here!
upvoted 0 times
...
Elvera
9 months ago
I thought Hadoop was outdated for this kind of task?
upvoted 0 times
...
Francine
9 months ago
BigQuery is super efficient for large datasets!
upvoted 0 times
...
Barney
10 months ago
I'm leaning towards option B, but I worry about the costs of loading such a large file into BigQuery just to drop it afterward.
upvoted 0 times
...
Yolande
10 months ago
I feel like we practiced a similar question where using external tables in BigQuery was the right choice, but I can't recall the exact details.
upvoted 0 times
...
Freeman
10 months ago
I think option C sounds familiar because it allows querying directly from Cloud Storage without needing to load the data, which seems efficient.
upvoted 0 times
...
Lavonna
10 months ago
I remember we discussed using BigQuery for large datasets, but I'm not sure if creating a table and dropping it later is the best approach for cost-effectiveness.
upvoted 0 times
...
Jennifer
11 months ago
Option D with Hadoop seems like overkill for this use case. The data is already in a Cloud Storage bucket, so I think the best approach is to use BigQuery, either through external tables or by loading the data directly.
upvoted 0 times
...
Howard
11 months ago
I'm leaning towards option B. Creating a temporary BigQuery table and loading the data there might be a bit more work, but it could provide better performance for the analysts' SQL queries.
upvoted 0 times
...
Reta
11 months ago
Option C seems like the most straightforward solution. Creating external tables in BigQuery that point to the Cloud Storage bucket should allow the analysts to run SQL queries without having to load the entire 5-TB file.
upvoted 0 times
...
Paulene
11 months ago
This looks like a tricky one. I'm not sure if I should go with option B or C. I'll need to think through the pros and cons of each approach.
upvoted 0 times
...
Lashaun
12 months ago
I disagree, I believe option C is better. It allows direct querying of data in Cloud Storage.
upvoted 0 times
...
Katina
1 year ago
I think option B is the best choice. It's cost-effective and efficient.
upvoted 0 times
...

Save Cancel