Google Cloud Certified - Associate Cloud Engineer Associate-Cloud-Engineer Question # 56 Topic 6 Discussion

Google Cloud Certified - Associate Cloud Engineer Associate-Cloud-Engineer Question # 56 Topic 6 Discussion

Associate-Cloud-Engineer Exam Topic 6 Question 56 Discussion:
Question #: 56
Topic #: 6

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.


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.


Get Premium Associate-Cloud-Engineer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.