Google
ASSOCIATE-CLOUD-ENGINEER · Question #118
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 dat
Sign in or unlock ASSOCIATE-CLOUD-ENGINEER to reveal the answer and full explanation for question #118. The question stem and answer options stay visible for context.
Submitted by eva_at· Mar 30, 2026Ensuring successful operation of a cloud solution
Question
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?
Options
- 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
- CWrite a script that loops through all the projects in your organization and runs a query on
- DWrite a Cloud Dataflow job that loops through all the projects in your organization and runs a
Unlock ASSOCIATE-CLOUD-ENGINEER to see the answer
You've previewed enough free ASSOCIATE-CLOUD-ENGINEER questions. Unlock ASSOCIATE-CLOUD-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Data Catalog#BigQuery#metadata search#data governance