Answer-first summary for fast verification
Answer: Use Data Catalog to search the BigQuery datasets by using keywords in the table description.
The most efficient way to locate the data you need within thousands of datasets in BigQuery is to use Data Catalog. Data Catalog allows you to search BigQuery datasets using keywords in the table description, which leverages the detailed descriptions already present for each table. This method is streamlined and scalable for an enterprise-scale company with a large volume of data, making it the best choice among the given options.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.