Professional Cloud Security EngineerDemo

By Google · Question Mode

QuestionQ208

Ensuring data protection

Your company runs clinical trials and must analyze the results of a recent study stored in BigQuery. The period during which the medicine was taken includes start and stop dates. The interval data is essential to the analysis, but particular dates could identify a specific batch and introduce bias. You need to obfuscate the start and end dates in each row while preserving the interval data.

What should you do?

  • A Use date shifting with the context set to the unique ID of the test subject.
  • B Extract the date using TimePartConfig from each date field and append a random month and year.
  • C Use bucketing to shift values to a predetermined date based on the initial value.
  • D Use the FFX mode of format preserving encryption (FPE) and maintain data consistency.
Explanation

Date shifting randomly offsets dates while preserving the sequence and duration of a period. Setting the context to each test subject's unique ID makes the same shift apply to that subject's start and end dates, retaining the medication interval while concealing the original dates.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!