Google Professional Data Engineer
Get started today
Ultimate access to all questions.
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?
Explanation:
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.