MENU
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?
Suggested Answer: D
Get Premium Associate Data Practitioner Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
31 comments · newest first
MI
Michel
6 months ago
A is definitely the way to go for metadata analysis!
MO
Moon
6 months ago
D isn't a standard option for this scenario.
CH
Chauncey
7 months ago
C is not ideal since we need to reference external files.
HO
Hoa
7 months ago
B seems tempting, but temporary tables won't work long-term.
DA
Dalene
7 months ago
D) sounds too complicated for just audio files.
LA
Lashon
7 months ago
C) is not suitable here, we need to link to external data.
ST
Stanford
7 months ago
Wait, can you really analyze audio metadata in BigQuery? Sounds cool!
AM
Ammie
8 months ago
I think B) is a waste of time for this.
CA
Caitlin
8 months ago
A) Create an external table. That's the way to go!
AU
Augustine
8 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.
MA
Maybelle
8 months ago
A) Create an external table. Definitely the way to go, can't beat that direct connection to the Cloud Storage bucket.
MI
Mica
9 months ago
B) Create a temporary table. Hmm, not sure that's the best option here. Wouldn't a permanent table be more appropriate?
HA
Harris
9 months ago
A) Create an external table. Yep, that's the right choice to connect BigQuery to the Cloud Storage bucket.
CH
Christiane
9 months ago
C) Create a native table. That's the standard approach for working with data in BigQuery, right?
JE
Jestine
9 months ago
A) Create an external table. Seems like the way to go, since the files are stored in a Cloud Storage bucket.
DI
Dino
9 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.
LA
Lai
9 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.
ER
Eric
10 months ago
I'm not entirely sure, but I remember something about temporary tables being useful for short-term data. Is that relevant here?
AR
Arthur
10 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.
DO
Donte
10 months ago
Agreed! External tables let you analyze without moving data.
DE
Desiree
10 months ago
I think A is the best option. External tables are great for this.
NO
Novella
10 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.
MA
Makeda
11 months ago
I think we should create an external table since we're dealing with files stored in Cloud Storage, right?
FR
Frank
11 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.
MA
Mable
11 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.
BE
Berry
11 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.
SH
Sherita
5 months ago
External tables for the win!
AL
Alberta
6 months ago
Plus, it saves storage costs!
LE
Leota
6 months ago
Definitely, no need to load data first.
MI
Miesha
6 months ago
External tables are so convenient!
SH
Shanice
6 months ago
I agree, option A seems the best choice.