As a data engineer working with Google BigQuery, you have a dataset that contains customers' street addresses. Your task is to extract all instances of these street addresses from the dataset. What approach should you take to achieve this?

Exam-Like

Write a SQL query in BigQuery by using REGEXP_CONTAINS on all tables in your dataset to find rows where the word 'street' appears._

6.5%

Create a deep inspection job on each table in your dataset with Cloud Data Loss Prevention and create an inspection template that includes the STREET_ADDRESS infoType._

56.5%

Create a discovery scan configuration on your organization with Cloud Data Loss Prevention and create an inspection template that includes the STREET_ADDRESS infoType._

28.3%

Create a de-identification job in Cloud Data Loss Prevention and use the masking transformation.

8.7%

Google Professional Data Engineer

Get started today

Comments

As a data engineer working with Google BigQuery, you have a dataset that contains customers' street addresses. Your task is to extract all instances of these street addresses from the dataset. What approach should you take to achieve this?