AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: Scenario: Your company’s data platform ingests CSV gcp video

Question 1 Be Honest
« Back   Next gcp data-engineer-pro Question »
Answer

Full Certification Question

Scenario: Your company’s data platform ingests CSV file dumps of booking and user profile data from upstream sources into Cloud Storage. The data analyst team wants to join these datasets on the email field available in both datasets for analysis. However, personally identifiable information (PII) should not be accessible to the analysts. You need to de-identify the email field in both datasets before loading them into BigQuery for analysts. Question: How should you de-identify the email field in both datasets before loading them into BigQuery?