MENU
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?
Suggested Answer: A
Get Premium Professional Cloud Security Engineer Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
'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.'
42 comments · newest first
SH
Shawnna
11 months ago
B sounds interesting, but randomizing months could mess up trends.
BA
Barabara
11 months ago
Wait, can we really shift dates without losing accuracy?
BA
Barney
11 months ago
A could introduce too much bias, not a fan.
KI
Kirk
11 months ago
I think D is more secure with FPE.
JA
Jacquline
12 months ago
Option C seems like the best choice for preserving intervals.
BR
Britt
12 months ago
I feel like option B could introduce too much randomness. We need to keep the intervals intact, so I’m leaning towards option C for that reason.
PA
Paz
1 year ago
I practiced a similar question where we had to anonymize data. I think option A could work, but I'm worried about how it might affect the analysis.
NO
Noel
1 year ago
I'm not entirely sure about the best method here. Option D sounds familiar, but I can't recall if it really maintains the interval data as needed.
NA
Nathan
1 year ago
I remember we discussed the importance of preserving the interval data while obfuscating dates. I think option C might be the right approach since it mentions using a unique ID.
EL
Elfrieda
1 year ago
This is a good test of my data anonymization skills. I'll need to weigh the pros and cons of each approach to find the best solution.
TA
Tawna
1 year ago
I'm feeling pretty confident about this one. I think option D using format preserving encryption is the way to go to maintain data consistency.
CH
Charlene
1 year ago
Okay, I think I've got a strategy here. I'll use date shifting with the unique ID to obfuscate the dates while keeping the interval intact.
FR
Francisca
1 year ago
Hmm, I'm a bit unsure about this one. I want to make sure I preserve the interval data, but I'm not sure which approach is best.
LA
Lashanda
1 year ago
This looks like a tricky one. I'll need to think through the options carefully to make sure I don't introduce any bias or identify the batches.
AR
Art
1 year ago
I'm confident that the correct answer is D. Deny. That's the most important control to establish first.
RO
Rolande
1 year ago
This question seems straightforward, but I want to make sure I understand the key details about the AES and AACC interface before selecting the answers.
LE
Lenna
1 year ago
This question seems straightforward, I think I can handle it.
MA
Malika
1 year ago
I'm confident the answer is D - capacity can be measured at all of those levels, from the individual machine or worker up to the entire plant. Gotta cover all the bases on this exam!
IN
In
2 years ago
D is the clear winner here. Format preserving encryption is the way to go - keep the data useful while staying anonymous. Boom, problem solved!
DA
Daniela
2 years ago
That's true, FPE allows us to obfuscate the dates while preserving the interval data for analysis.
LA
Lauryn
2 years ago
It's important to maintain data consistency while keeping the information anonymous.
AL
Aleisha
2 years ago
I agree, using FFX mode of format preserving encryption is the best option.
PH
Phyliss
2 years ago
B just sounds like a mess. Randomly appending months and years? No thanks, I'll stick with D and keep my sanity.
SH
Shantay
2 years ago
I like the idea of bucketing in A, but it might not be precise enough for the clinical trial data. D seems the most robust solution.
TA
Tatum
2 years ago
D) Yeah, FFX mode of FPE seems like the most robust solution for preserving data integrity.
MA
Matthew
2 years ago
A) I agree, bucketing might not be precise enough for clinical trial data.
MA
Martin
2 years ago
D) Use the FFX mode of format preserving encryption (FPE) and maintain data consistency
PA
Pamela
2 years ago
A) Use bucketing to shift values to a predetermined date based on the initial value.
ST
Stefania
2 years ago
I suggest using the FFX mode of format preserving encryption to maintain data consistency.
CL
Clarinda
2 years ago
I think using date shifting with the context set to the unique ID of the test subject would be the best approach.
EM
Emeline
2 years ago
I disagree, I believe we should extract the date using TimePartConfig and append a random month and year.
SA
Sabina
2 years ago
I think we should use bucketing to shift values to a predetermined date.
LU
Luis
2 years ago
C is interesting, but using the test subject ID for date shifting could still reveal sensitive information. I'd prefer a more generic approach.
OC
Octavio
2 years ago
B) Extract the date using TimePartConfig from each date field and append a random month and year
FI
Fidelia
2 years ago
A) Use bucketing to shift values to a predetermined date based on the initial value.
ED
Edmond
2 years ago
D seems like the way to go. Format preserving encryption will keep the interval data intact while obfuscating the actual dates.
JO
Josephine
2 years ago
It's a secure way to handle the sensitive information in the study results.
DO
Dorthy
2 years ago
That way, the interval data will still be preserved for analysis.
CU
Curtis
2 years ago
I agree, using FFX mode of format preserving encryption will help maintain data consistency while protecting the sensitive information.
HE
Helga
2 years ago
It's important to maintain data consistency while obfuscating the dates.
GL
Glendora
2 years ago
I agree, using FFX mode of format preserving encryption will be the best option.
LU
Luther
2 years ago
D seems like the way to go. Format preserving encryption will keep the interval data intact while obfuscating the actual dates.