Question

A healthcare analytics team wants to share a BigQuery dataset of patient visit records with a research partner. The dataset contains admission dates and discharge dates. Researchers need to compute accurate lengths of stay and study seasonal trends, but the actual calendar dates for any individual patient must not be identifiable. Which Sensitive Data Protection (DLP) transformation should the team apply to the date fields?

Accepted Answer

Apply a date-shifting transformation that moves each patient's dates by a random but consistent per-patient offset within a configured range.

Answer

Redact the date fields entirely using a redaction transformation before sharing the dataset.

Answer

Apply cryptographic deterministic tokenization (surrogate) to each date value using a wrapped KMS key.

Answer

Bucket the dates into fixed ranges using a fixed-size bucketing transformation on the date values.