Google Associate Cloud Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Your company utilizes Google BigQuery for its data warehousing needs. Over the years, various business units within the organization have generated more than 1000 datasets spanning across hundreds of projects. The Chief Information Officer (CIO) has requested that you review all these datasets to identify tables that include a column named employee_ssn. You aim to complete this task with minimal effort. What approach should you take?_
A
Go to Data Catalog and search for employee_ssn in the search box._
B
Write a shell script that uses the bq command line tool to loop through all the projects in your organization.
C
Write a script that loops through all the projects in your organization and runs a query on INFORMATION_SCHEMA.COLUMNS view to find the employee_ssn column.
D
Write a Cloud DataFlow job that loops through all the projects in your organization and runs a query on INFORMATION_SCHEMA.COLUMNS view to find employee_ssn column.