Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
A
Write a SQL query in BigQuery by using REGEXP_CONTAINS on all tables in your dataset to find rows where the word 'street' appears.
B
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.
C
Create a discovery scan configuration on your organization with Cloud Data Loss Prevention and create an inspection template that includes the STREET_ADDRESS infoType.
D
Create a de-identification job in Cloud Data Loss Prevention and use the masking transformation.
