Your Company Uses BigQuery for Data Warehousing

question 121

Multiple Choice

Your 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?

• A) Go to Data Catalog and search for employee_ssn in the search box. Go to Data Catalog and search for 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. 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 . 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 . 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

---

Definitions:

Dependability

The quality of being trustworthy and reliable.

Good Job Performance

The successful execution of tasks and responsibilities assigned at work to a high standard.

Micromanager

A leader or manager who excessively controls or oversees workers or tasks, often to the detail, hindering autonomy.

Ergonomics Problems

Issues arising from the design of workplace environments that lead to reduced efficiency, discomfort, or health risks for workers.