Topic 1 Question 183
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?
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.
ユーザの投票
コメント(5)
- 正解だと思う選択肢: A
A - date shifting. Bucketing is not an option here, because we would lose the order. Encryption is overpowered here
👍 3a190d622023/08/03 - 正解だと思う選択肢: A
Option A and D works, but the focus here is to preserve the interval data.
So option A is more suited in this case.
"Date shifting techniques randomly shift a set of dates but preserve the sequence and duration of a period of time. Shifting dates is usually done in context to an individual or an entity. That is, each individual's dates are shifted by an amount of time that is unique to that individual."
👍 3Xoxoo2023/09/18 - 正解だと思う選択肢: A
Option A is good
👍 2cyberpunk212023/08/24
シャッフルモード