Question 93 of 284
Single answerYour company uses BigQuery for data warehousing. Over time, many different business units in your company have created 1000+ datasets across hundreds of projects. Your CIO wants you to examine all datasets to find tables that contain an employee_ssn column. You want to minimize effort in performing this task.
What should you do?
✓AGo to Data Catalog and search for employee_ssn in the search box.
BWrite a shell script that uses the bq command line tool to loop through all the projects in your organization.
CWrite 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.
DWrite 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.
✓
Correct Answer: A
Go to Data Catalog and search for employee_ssn in the search box.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.