Google Associate Cloud Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Your logistics company has accumulated extensive data over the years, utilizing BigQuery for data warehousing. Multiple teams frequently analyze thousands of datasets across hundreds of projects. The CIO has tasked you with identifying all datasets containing an 'employee_nu' column with minimal effort. What is the most efficient method to accomplish this?_
A
Utilize the search functionality in the Data Catalog to look for 'employee_nu'._
B
Develop a shell script to iterate through all organization projects, using the bq command line tool to search for tables with the 'employee_nu' column._
C
Create a shell script to loop through all projects, executing a query on the INFORMATION_SCHEMA.COLUMNS view to locate the 'employee_nu' column.
D
Implement a Dataflow job to scan all projects, querying the INFORMATION_SCHEMA.COLUMNS view for the 'employee_nu' column.