Exam Professional-Machine-Learning-Engineer Topic 1 Question 43 Discussion

Actual exam question for Google's Professional-Machine-Learning-Engineer exam
Question #: 43
Topic #: 1
You recently joined an enterprise-scale company that has thousands of datasets. You know that there are accurate descriptions for each table in BigQuery, and you are searching for the proper BigQuery table to use for a model you are building on AI Platform. How should you find the data that you need?

Suggested Answer: A Vote an answer

INFORMATION_SCHEMA metadata tables that are native to BigQuery. Use the result o find the table that you need.
Explanation:
A should be the way to go for large datasets --This is also good but it is legacy way of checking:- NFORMATION_SCHEMA contains these views for table metadata: TABLES and TABLE_OPTIONS for metadata about tables. COLUMNS and COLUMN_FIELD_PATHS for metadata about columns and fields. PARTITIONS for metadata about table partitions (Preview)

by Woodrow at Jan 06, 2024, 01:23 PM

Limited Time Offer

15%

Off

Get Premium Professional-Machine-Learning-Engineer Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.
0
0
0
10