Answer-first summary for fast verification
Answer: 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.
The best approach to accurately identify and retrieve all occurrences of street addresses within a BigQuery dataset is to use Cloud Data Loss Prevention (Cloud DLP). Specifically, you should create a deep inspection job on each table in the dataset and use an inspection template that includes the STREET_ADDRESS infoType. This method ensures that all relevant data is correctly identified. Therefore, the correct answer is B.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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.
No comments yet.