GoogleGoogle
PROFESSIONAL-DATA-ENGINEER · Question #328
PROFESSIONAL-DATA-ENGINEER Question #328: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #328. The question stem and answer options stay visible for context.
Submitted by viktor_hu· Mar 30, 2026Building and operationalizing data processing systems
Question
You 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? 搒treet?appears.
Options
- AWrite a SQL query in BigQuery by using REGEXP_CONTAINS on all tables in your dataset to find rows where the word
- BCreate a deep inspection job on each table in your dataset with Cloud Data Loss Prevention and create an inspection template that includes the
- CCreate a discovery scan configuration on your organization with Cloud Data Loss Prevention and create an inspection template that includes the
- DCreate a de-identification job in Cloud Data Loss Prevention and use the masking transformation.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Cloud Data Loss Prevention (DLP)#Data Discovery#PII#BigQuery