Google Professional Machine Learning Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You recently joined an enterprise-scale company that has thousands of datasets stored in BigQuery. The datasets have detailed descriptions, and you need to find the appropriate BigQuery table to use for building a machine learning model on Google Cloud AI Platform. Considering the scale and complexity of the datasets, what is the most efficient method to locate the data you need?
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.
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 to find the table that you need._