Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
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.
Cryptographic Hashing (CryptoHashConfig) in Sensitive Data Protection computes an HMAC-SHA-256 message authentication code over an input string using a cryptographic key and returns a base64-encoded hash value.
patient_account_id, violating the requirement for authorized re-identification pipelines.cryptoHashConfig is a fixed-length base64-encoded string, which does not preserve the 10-digit numeric character set required by legacy schema validators.The organization required permanent, irreversible pseudonymization (one-way hashing) where downstream systems supported arbitrary string lengths and re-identification was strictly prohibited.
While cryptographic hashing is secure and maintains referential integrity for joins, it is unsuited for workflows requiring compliance audits that necessitate detokenization.
Deterministic Encryption (DE) uses AES-SIV to encrypt plaintext values into base64-encoded tokens with surrogates, while Character Masking (CharacterMaskConfig) replaces characters with a fixed symbol (e.g., * or #).
27 into ** or 2*, destroying distribution metrics).Downstream analytical systems had no character set or length constraints and the age field required partial redaction rather than numerical cohort bucketing.
A Transient Crypto Key (TransientCryptoKey) is an ephemeral key generated dynamically in-memory by Sensitive Data Protection for the duration of a single API request and immediately discarded. A Time Part Config (TimePartConfig) extracts specific temporal components (such as year or month) from date and timestamp fields.
timePartConfig is designed for date and timestamp fields, not integer age columns.TimePartConfig cannot evaluate or bucket numeric integer attributes.The dataset were processed in a single ad-hoc batch request where re-identification was never required and the age field was formatted as a full birth date string.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated