PROFESSIONAL-CLOUD-SECURITY-ENGINEER Question #203: Real Exam Question with Answer & Explanation

Question

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?

Options

• AUse date shifting with the context set to the unique ID of the test subject.
• BExtract the date using TimePartConfig from each date field and append a random month and
• CUse bucketing to shift values to a predetermined date based on the initial value.
• DUse the FFX mode of format preserving encryption (FPE) and maintain data consistency.

Explanation

Cloud DLP's date shifting transformation shifts each date by a random number of days. When a consistent context key is provided - such as the unique ID of the test subject - the same random shift is applied uniformly to all date fields for that subject. This means the interval (elapsed days between start and stop) is preserved even though the absolute dates are changed, satisfying both the obfuscation and interval-preservation requirements. Option B (extracting and appending a random month) would destroy interval integrity. Option C (bucketing) maps values to fixed ranges and does not preserve exact intervals. Option D (format-preserving encryption) encrypts the values but does not guarantee that the numeric difference between two encrypted dates will equal the original interval.

No community discussion yet for this question.