Google Associate Data Practitioner Exam - Topic 1 Question 18 Discussion

Actual exam question for Google's Associate Data Practitioner exam

Question #: 18
Topic #: 1

[All Associate Data Practitioner Questions]

Your company's customer support audio files are stored in a Cloud Storage bucket. You plan to analyze the audio files' metadata and file content within BigQuery to create inference by using BigQuery ML. You need to create a corresponding table in BigQuery that represents the bucket containing the audio files. What should you do?

ACreate an external table.

BCreate a temporary table.

CCreate a native table.

DCreate an object table.

Show Suggested Answer

Suggested Answer: D

To analyze audio files stored in a Cloud Storage bucket and represent them in BigQuery, you should create an object table. Object tables in BigQuery are designed to represent objects stored in Cloud Storage, including their metadata. This enables you to query the metadata of audio files directly from BigQuery without duplicating the data. Once the object table is created, you can use it in conjunction with other BigQuery ML workflows for inference and analysis.

by Tina at Nov 23, 2025, 02:46 PM

Limited Time Offer

25%

Off

Get Premium Associate Data Practitioner Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Michel

7 days ago

A is definitely the way to go for metadata analysis!

upvoted 0 times

...

Moon

12 days ago

D isn't a standard option for this scenario.

upvoted 0 times

...

Chauncey

17 days ago

C is not ideal since we need to reference external files.

upvoted 0 times

...

Hoa

22 days ago

B seems tempting, but temporary tables won't work long-term.

upvoted 0 times

...

Dalene

27 days ago

D) sounds too complicated for just audio files.

upvoted 0 times

...

Lashon

1 month ago

C) is not suitable here, we need to link to external data.

upvoted 0 times

...

Stanford

1 month ago

Wait, can you really analyze audio metadata in BigQuery? Sounds cool!

upvoted 0 times

...

Ammie

2 months ago

I think B) is a waste of time for this.

upvoted 0 times

...

Caitlin

2 months ago

A) Create an external table. That's the way to go!

upvoted 0 times

...

Augustine

2 months ago

D) Create an object table. Wait, is that even a thing in BigQuery? I'm pretty sure the answer is A) Create an external table.

upvoted 0 times

...

Maybelle

2 months ago

A) Create an external table. Definitely the way to go, can't beat that direct connection to the Cloud Storage bucket.

upvoted 0 times

...

Mica

3 months ago

B) Create a temporary table. Hmm, not sure that's the best option here. Wouldn't a permanent table be more appropriate?

upvoted 0 times

...

Harris

3 months ago

A) Create an external table. Yep, that's the right choice to connect BigQuery to the Cloud Storage bucket.

upvoted 0 times

...

Christiane

3 months ago

C) Create a native table. That's the standard approach for working with data in BigQuery, right?

upvoted 0 times

...

Jestine

3 months ago

A) Create an external table. Seems like the way to go, since the files are stored in a Cloud Storage bucket.

upvoted 0 times

...

Dino

3 months ago

Object tables sound familiar, but I don't recall them being used for this kind of analysis. I think external tables are the way to go.

upvoted 0 times

...

Lai

3 months ago

I practiced a similar question, and I believe a native table is for data that's fully loaded into BigQuery, which doesn't apply to our audio files.

upvoted 0 times

...

Eric

4 months ago

I'm not entirely sure, but I remember something about temporary tables being useful for short-term data. Is that relevant here?

upvoted 0 times

...

Arthur

4 months ago

I'm a bit confused on the difference between an external table and an object table. I'll need to make sure I understand the pros and cons of each before deciding.

upvoted 0 times

...

Donte

4 months ago

Agreed! External tables let you analyze without moving data.

upvoted 0 times

...

Desiree

4 months ago

I think A is the best option. External tables are great for this.

upvoted 0 times

...

Novella

4 months ago

I'm pretty confident that option A is the way to go. Connecting an external table to the Cloud Storage bucket is the most efficient way to get the data into BigQuery for the analysis.

upvoted 0 times

...

Makeda

5 months ago

I think we should create an external table since we're dealing with files stored in Cloud Storage, right?

upvoted 0 times

...

Frank

5 months ago

Creating an external table sounds like the right approach here. That way I can analyze the audio file metadata and content without having to worry about managing the data storage myself.

upvoted 0 times

...

Mable

5 months ago

Hmm, I'm a little unsure about this one. I'm not sure if creating a temporary table or a native table would be better. I'll need to review the differences between those options.

upvoted 0 times

...

Berry

5 months ago

I think I would go with option A and create an external table. That way I can access the data in the Cloud Storage bucket directly without having to load it into BigQuery first.

upvoted 0 times

Shanice

2 days ago

I agree, option A seems the best choice.

upvoted 0 times

...