exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam

Exam Associate Data Practitioner topic 1 question 62 discussion

Actual exam question from Google's Associate Data Practitioner
Question #: 62
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?

  • A. Create an external table.
  • B. Create a temporary table.
  • C. Create a native table.
  • D. Create an object table.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
n2183712847
1 month, 3 weeks ago
Selected Answer: D
object table due to audio files in cloud storage bucket
upvoted 1 times
...
n2183712847
1 month, 4 weeks ago
Selected Answer: D
The best option is D. Object table. Option D is best because Object tables directly represent Cloud Storage buckets in BigQuery, letting you query file metadata and content for BigQuery ML. Option A (External table) is incorrect because while possible, Object tables are more specialized for Cloud Storage buckets. Option B (Temporary table) is incorrect because it's for short-term data, not external sources. Option C (Native table) is incorrect because it requires loading data into BigQuery, not querying it in Cloud Storage directly. Therefore, Option D, Object table, is the most direct for Cloud Storage file analysis in BigQuery.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago