問題文
The company keeps a development catalog and a production catalog, and both contain a schema named sales with a table named orders. An analyst is asked to make sure a scheduled query always reads the production copy. What is the reliable way to do that?
選択肢
- Remove access to the development catalog for the whole analyst team, so only production is readable.
- Write the table reference with all three levels, catalog, schema and table, naming the production catalog explicitly in the query.
- Rename the development table so that the two names differ, because a query can only be unambiguous if the table names are unique.
- Rely on the default catalog of the workspace, because scheduled queries always run against the production default.