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