Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.