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…

Question

Options

• AUse Data Catalog to search the BigQuery datasets by using keywords in the table description.
• BTag each of your model and version resources on AI Platform with the name of the BigQuery
• CMaintain a lookup table in BigQuery that maps the table descriptions to the table ID.
• DExecute a query in BigQuery to retrieve all the existing table names in your project using the

• A
  79% (37)
• B
  4% (2)
• C
  11% (5)
• D
  6% (3)

Explanation

Google Cloud Data Catalog is a fully managed metadata discovery and management service that automatically crawls and indexes BigQuery metadata, including table descriptions, schema, and tags. It provides a Google Search–like interface where you can search by keywords found in table descriptions, making it ideal for finding the right dataset at enterprise scale. Option B (tagging AI Platform resources) is backward - tagging the model with the table name doesn't help you find the table. Option C (maintaining a lookup table) is a manual, error-prone approach that defeats the purpose of having descriptions in BigQuery. Option D (querying table names with INFORMATION_SCHEMA) only returns table names, not searchable descriptions, and requires knowing the right project/dataset to query.

No community discussion yet for this question.