nerdexam
Google

PROFESSIONAL-MACHINE-LEARNING-ENGINEER · Question #311

You work for a bank. You need to train a model by using unstructured data stored in Cloud Storage that predicts whether credit card transactions are fraudulent. The data needs to be converted to a str

The correct answer is B. Use the DLP API to de-identify the sensitive data before loading it into BigQuery.. The DLP API (Data Loss Prevention API) can be used to identify and de-identify sensitive data (such as PII) in a scalable manner. This ensures that sensitive information is obfuscated or tokenized while retaining the data's utility for analysis. De-identifying the data before loa

Submitted by certguy· Apr 18, 2026Data processing and feature engineering

Question

You work for a bank. You need to train a model by using unstructured data stored in Cloud Storage that predicts whether credit card transactions are fraudulent. The data needs to be converted to a structured format to facilitate analysis in BigQuery. Company policy requires that data containing personally identifiable information (PII) remain in Cloud Storage. You need to implement a scalable solution that preserves the data's value for analysis. What should you do?

Options

  • AUse BigQuery's authorized views and column-level access controls to restrict access to PII within
  • BUse the DLP API to de-identify the sensitive data before loading it into BigQuery.
  • CStore the unstructured data in a separate PII-compliant BigQuery database.
  • DRemove the sensitive data from the files manually before loading them into BigQuery.

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    81% (21)
  • C
    4% (1)
  • D
    12% (3)

Explanation

The DLP API (Data Loss Prevention API) can be used to identify and de-identify sensitive data (such as PII) in a scalable manner. This ensures that sensitive information is obfuscated or tokenized while retaining the data's utility for analysis. De-identifying the data before loading it into BigQuery ensures compliance with the bank's policy that PII must remain in Cloud Storage, while allowing structured data analysis in BigQuery without risking exposure of sensitive information.

Topics

#Data Privacy#PII De-identification#Google Cloud DLP API#Data Processing

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-MACHINE-LEARNING-ENGINEER Practice