professional-cloud-data-engineer
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
An organization is designing an automated Dataflow ingestion pipeline to de-identify sensitive structured records containing Personally Identifiable Information (PII) before storing them in BigQuery for analytics. The privacy compliance team establishes the following technical constraints:
patient_account_id column must retain referential integrity for analytical joins, remain reversible for authorized re-identification pipelines, and preserve its original 10-digit numeric character set to maintain backward compatibility with legacy schema validators.patient_age column must be abstracted into discrete 10-year cohorts to mitigate re-identification risk while preserving population distribution metrics.Which transformation configuration in Cloud Sensitive Data Protection (Cloud DLP) meets all of these requirements?
Format-Preserving Encryption (FPE) in FFX mode (CryptoReplaceFfxFpeConfig) and Bucketed Generalization (FixedSizeBucketingConfig) are primitive de-identification transformations provided by Cloud Sensitive Data Protection (Cloud DLP API). FPE performs two-way pseudonymization by encrypting values while strictly preserving the original character length and alphabet, whereas fixed-size bucketing generalizes continuous numerical values into bounded intervals.
cryptoReplaceFfxFpeConfig with a common_alphabet set to NUMERIC guarantees that the 10-digit account ID is transformed into a 10-digit numeric token, preventing validation failures in downstream legacy systems.fixedSizeBucketingConfig with a bucket size of 10 replaces specific integer ages with 10-year ranges (e.g., 20:30, 30:40), minimizing re-identification risk while maintaining statistical utility.kmsWrapped under cryptoKey embeds an AES encryption key that is wrapped (encrypted) by a Cloud KMS key encryption key (KEK), ensuring plaintext secrets are never stored in templates or logs.This configuration fulfills all legacy format constraints, security mandates, and analytical generalization goals without requiring custom code or secondary token mapping databases.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.