Google Exam Professional Cloud Security Engineer Topic 2 Question 83 Discussion

Actual exam question for Google's Professional Cloud Security Engineer exam

Question #: 83
Topic #: 2

[All Professional Cloud Security Engineer Questions]

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?

AUse bucketing to shift values to a predetermined date based on the initial value.

BExtract the date using TimePartConfig from each date field and append a random month and year

CUse date shifting with the context set to the unique ID of the test subject

DUse the FFX mode of format preserving encryption (FPE) and maintain data consistency

Show Suggested Answer

Suggested Answer: A

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

by Asha at Jul 07, 2024, 03:41 PM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Security Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

In

3 months 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!

upvoted 0 times

Daniela

2 months ago

That's true, FPE allows us to obfuscate the dates while preserving the interval data for analysis.

upvoted 0 times

...

Lauryn

2 months ago

It's important to maintain data consistency while keeping the information anonymous.

upvoted 0 times

...

Aleisha

2 months ago

I agree, using FFX mode of format preserving encryption is the best option.

upvoted 0 times

...

Phyliss

3 months ago

B just sounds like a mess. Randomly appending months and years? No thanks, I'll stick with D and keep my sanity.

upvoted 0 times

...

Shantay

3 months 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.

upvoted 0 times

Tatum

2 months ago

D) Yeah, FFX mode of FPE seems like the most robust solution for preserving data integrity.

upvoted 0 times

...

Matthew

3 months ago

A) I agree, bucketing might not be precise enough for clinical trial data.

upvoted 0 times

...

Martin

3 months ago

D) Use the FFX mode of format preserving encryption (FPE) and maintain data consistency

upvoted 0 times

...

Pamela

3 months ago

A) Use bucketing to shift values to a predetermined date based on the initial value.

upvoted 0 times

...

Stefania

4 months ago

I suggest using the FFX mode of format preserving encryption to maintain data consistency.

upvoted 0 times

...

Clarinda

4 months ago

I think using date shifting with the context set to the unique ID of the test subject would be the best approach.

upvoted 0 times

...

Emeline

4 months ago

I disagree, I believe we should extract the date using TimePartConfig and append a random month and year.

upvoted 0 times

...

Sabina

4 months ago

I think we should use bucketing to shift values to a predetermined date.

upvoted 0 times

...

Luis

4 months 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.

upvoted 0 times

Octavio

3 months ago

B) Extract the date using TimePartConfig from each date field and append a random month and year

upvoted 0 times

...

Fidelia

3 months ago

A) Use bucketing to shift values to a predetermined date based on the initial value.

upvoted 0 times

...

Edmond

4 months ago

D seems like the way to go. Format preserving encryption will keep the interval data intact while obfuscating the actual dates.

upvoted 0 times

Josephine

3 months ago

It's a secure way to handle the sensitive information in the study results.

upvoted 0 times

...

Dorthy

3 months ago

That way, the interval data will still be preserved for analysis.

upvoted 0 times

...

Curtis

3 months ago

I agree, using FFX mode of format preserving encryption will help maintain data consistency while protecting the sensitive information.

upvoted 0 times

...

Helga

4 months ago

It's important to maintain data consistency while obfuscating the dates.

upvoted 0 times

...

Glendora

4 months ago

I agree, using FFX mode of format preserving encryption will be the best option.

upvoted 0 times

...

Luther

4 months ago

D seems like the way to go. Format preserving encryption will keep the interval data intact while obfuscating the actual dates.

upvoted 0 times

...