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

11 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

9 months ago

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

upvoted 0 times

...

Lauryn

9 months ago

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

upvoted 0 times

...

Aleisha

10 months ago

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

upvoted 0 times

...

Phyliss

11 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

11 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

10 months ago

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

upvoted 0 times

...

Matthew

10 months ago

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

upvoted 0 times

...

Martin

10 months ago

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

upvoted 0 times

...

Pamela

10 months ago

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

upvoted 0 times

...

Stefania

11 months ago

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

upvoted 0 times

...

Clarinda

11 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

11 months ago

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

upvoted 0 times

...

Sabina

11 months ago

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

upvoted 0 times

...

Luis

11 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

11 months ago

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

upvoted 0 times

...

Fidelia

11 months ago

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

upvoted 0 times

...

Edmond

12 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

11 months ago

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

upvoted 0 times

...

Dorthy

11 months ago

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

upvoted 0 times

...

Curtis

11 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

11 months ago

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

upvoted 0 times

...

Glendora

11 months ago

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

upvoted 0 times

...

Luther

11 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

...