Your company is conducting clinical trials with study results stored in BigQuery. The medication administration intervals contain start and end dates that could identify specific batches and introduce bias if exposed. You need to obfuscate the actual start and end dates while preserving the exact interval duration for analysis.

What should you do?

Exam-Like

Use date shifting with the context set to the unique ID of the test subject.

Extract the date using TimePartConfig from each date field and append a random month and year.

Use bucketing to shift values to a predetermined date based on the initial value.

Use the FFX mode of format preserving encryption (FPE) and maintain data consistency.

Google Professional Cloud Security Engineer