Question 236 of 307
Single answerYou have one BigQuery dataset which includes customers’ street addresses. You want to retrieve all occurrences of street addresses from the dataset. What should you do?
AWrite a SQL query in BigQuery by using REGEXP_CONTAINS on all tables in your dataset to find rows where the word “street†appears.
✓BCreate 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.
CCreate a discovery scan configuration on your organization with Cloud Data Loss Prevention and create an inspection template that includes the STREET_ADDRESS infoType.
DCreate a de-identification job in Cloud Data Loss Prevention and use the masking transformation.
✓
Correct Answer: 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.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.