ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 61 - Professional Machine Learning Engineer discussion

Report
Export

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?

A.
Use Data Catalog to search the BigQuery datasets by using keywords in the table description.
Answers
A.
Use Data Catalog to search the BigQuery datasets by using keywords in the table description.
B.
Tag each of your model and version resources on AI Platform with the name of the BigQuery table that was used for training.
Answers
B.
Tag each of your model and version resources on AI Platform with the name of the BigQuery table that was used for training.
C.
Maintain a lookup table in BigQuery that maps the table descriptions to the table ID. Query the lookup table to find the correct table ID for the data that you need.
Answers
C.
Maintain a lookup table in BigQuery that maps the table descriptions to the table ID. Query the lookup table to find the correct table ID for the data that you need.
D.
Execute a query in BigQuery to retrieve all the existing table names in your project using the INFORMATION_SCHEMA metadata tables that are native to BigQuery. Use the result o find the table that you need.
Answers
D.
Execute a query in BigQuery to retrieve all the existing table names in your project using the INFORMATION_SCHEMA metadata tables that are native to BigQuery. Use the result o find the table that you need.
Suggested answer: A

Explanation:

Data Catalog is a fully managed and scalable metadata management service that allows you to quickly discover, manage, and understand your data in Google Cloud. You can use Data Catalog to search the BigQuery datasets by using keywords in the table description, as well as other metadata attributes such as table name, column name, labels, tags, and more. Data Catalog also provides a rich browsing experience that lets you explore the schema, preview the data, and access the BigQuery console directly from the Data Catalog UI. Data Catalog helps you find the data that you need for your model building on AI Platform without writing any code or queries.

[Data Catalog documentation]

[Data Catalog overview]

[Searching for data assets]

asked 18/09/2024
Shan Panikker
28 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first