Google Cloud Professional Cloud Security Engineer — Question 105

Your company conducts clinical trials and needs to analyze the results of a recent study that are stored in BigQuery. The interval when the medicine was taken contains start and stop dates. The interval data is critical to the analysis, but specific dates may identify a particular batch and introduce bias. You need to obfuscate the start and end dates for each row and preserve the interval data.

What should you do?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A, as date shifting allows for the obfuscation of the start and end dates while maintaining the relative interval between them, thus preserving the integrity of the analysis. Options B and C do not adequately preserve the interval data, and option D, while it maintains data consistency, does not specifically address the need for obfuscation of the dates.