
Ultimate access to all questions.
You need to train a model to predict fraudulent credit card transactions using unstructured data stored in Cloud Storage. The data must be converted to a structured format for analysis in BigQuery. Due to company policy, any data containing personally identifiable information (PII) must remain in Cloud Storage. You need to implement a scalable solution that preserves the data's analytical value. What should you do?
A
Use BigQuery’s authorized views and column-level access controls to restrict access to PII within the dataset.
B
Use the DLP API to de-identify the sensitive data before loading it into BigQuery.
C
Store the unstructured data in a separate PII-compliant BigQuery database.
D
Remove the sensitive data from the files manually before loading them into BigQuery.