ASSOCIATE-CLOUD-ENGINEER Question #118: Real Exam Question with Answer & Explanation

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

Explanation

Data Catalog allows you to discover, manage, and understand data assets across Google Cloud Platform. Data Catalog API natively indexes Cloud BigQuery, Cloud Storage, and Cloud Pub/Sub The Data Catalog API can be used to: Search for data assets across different projects and GCP resources Create tags and tag templates to add structured business metadata unique to your organization Automate the tagging process of data assets as part of a data ingestion pipeline https://cloud.google.com/data-catalog/docs/how-to/search

No community discussion yet for this question.