You Recently Joined an Enterprise-Scale Company That Has Thousands of Datasets

question 21

Multiple Choice

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.
• 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 o find the table that you need.

---

Definitions:

Wheat Farmer

An agriculturist specialized in the cultivation of wheat crops.

Marginal Cost

The increase in total production cost that arises from producing one additional unit of a good or service, providing insight into the cost mechanics of scaling up operations.

Competitive

A market characteristic where multiple firms or entities vie for customers, influencing prices, quality, and services in the process.

Market Price

Market Price is the current price at which a good or service can be bought or sold in a marketplace.