Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Data Engineer Exam - Topic 1 Question 67 Discussion

You are preparing an organization-wide dataset. You need to preprocess customer data stored in a restricted bucket in Cloud Storage. The data will be used to create consumer analyses. You need to follow data privacy requirements, including protecting certain sensitive data elements, while also retaining all of the data for potential future use cases. What should you do?
C) Use Dataflow and Cloud KMS to encrypt sensitive fields and write the encrypted data in BigQuery. Share the encryption key by following the principle of least privilege.
A) Use Dataflow and the Cloud Data Loss Prevention API to mask sensitive data. Write the processed data in BigQuery.
B) Use the Cloud Data Loss Prevention API and Dataflow to detect and remove sensitive fields from the data in Cloud Storage. Write the filtered data in BigQuery.
D) Use customer-managed encryption keys (CMEK) to directly encrypt the data in Cloud Storage. Use federated queries from BigQuery. Share the encryption key by following the principle of least privilege.

Google Professional Data Engineer Exam - Topic 1 Question 67 Discussion

Actual exam question for Google's Professional Data Engineer exam
Question #: 67
Topic #: 1
[All Professional Data Engineer Questions]

You are preparing an organization-wide dataset. You need to preprocess customer data stored in a restricted bucket in Cloud Storage. The data will be used to create consumer analyses. You need to follow data privacy requirements, including protecting certain sensitive data elements, while also retaining all of the data for potential future use cases. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Denise at Mar 22, 2023, 05:20 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Cathrine
10 months ago
Wait, can we really use CMEK like that? Sounds sketchy!
upvoted 0 times
...
Jesus
10 months ago
D sounds risky, sharing keys could lead to breaches.
upvoted 0 times
...
Wendell
10 months ago
C is interesting, but encrypting might complicate future analyses.
upvoted 0 times
...
Kina
11 months ago
I disagree, B is better since it removes sensitive fields entirely.
upvoted 0 times
...
Isadora
11 months ago
A seems like the best option for masking sensitive data.
upvoted 0 times
...
Hector
11 months ago
I recall that using customer-managed encryption keys is important for compliance, but I’m not clear on how that fits with the other options here.
upvoted 0 times
...
Titus
11 months ago
I’m a bit confused about whether encrypting data with Cloud KMS is necessary if we’re just masking sensitive data.
upvoted 0 times
...
Theodora
11 months ago
I think option A sounds familiar because it mentions using Dataflow and the DLP API together, which we practiced in a similar question.
upvoted 0 times
...
Devorah
11 months ago
I remember studying about the Cloud Data Loss Prevention API, but I'm not sure if it should be used for masking or removing data.
upvoted 0 times
...
Michel
11 months ago
I vaguely recall something about customer-managed encryption keys in our study materials. Option D seems to align with that, but I’m uncertain about using federated queries with it.
upvoted 0 times
...
Stefan
11 months ago
I feel like I saw a similar question about encryption in our practice exams. Option C mentions using Cloud KMS, which sounds familiar, but I'm not sure if it's the best approach here.
upvoted 0 times
...
Ceola
11 months ago
I'm not entirely sure, but I think option B could be a good fit too. It talks about detecting and removing sensitive fields, which seems relevant to data privacy.
upvoted 0 times
...
Sharika
11 months ago
I remember we discussed the importance of data masking in our last class. I think option A might be the right choice since it mentions masking sensitive data.
upvoted 0 times
...
Altha
11 months ago
Upgrading the system model seems like it would likely require a full system outage, so I'm going to rule that out. I'll focus on the first two options.
upvoted 0 times
...
Audry
11 months ago
The key here is understanding how explicit settings and ACT settings are prioritized. I believe option C is the false statement.
upvoted 0 times
...
Xochitl
11 months ago
I think Ethereum is a permissionless blockchain. We discussed that in class!
upvoted 0 times
...
Avery
1 year ago
Honestly, I'm just hoping the correct answer isn't 'All of the above'. That would be a real head-scratcher!
upvoted 0 times
Scarlet
1 year ago
C) Use Dataflow and Cloud KMS to encrypt sensitive fields and write the encrypted data in BigQuery. Share the encryption key by following the principle of least privilege.
upvoted 0 times
...
Reta
1 year ago
B) Use the Cloud Data Loss Prevention API and Dataflow to detect and remove sensitive fields from the data in Cloud Storage. Write the filtered data in BigQuery.
upvoted 0 times
...
Louvenia
1 year ago
A) Use Dataflow and the Cloud Data Loss Prevention API to mask sensitive data. Write the processed data in BigQuery.
upvoted 0 times
...
...
Dannie
1 year ago
Gotta love these data privacy questions! Option A sounds like a nice balance between masking sensitive info and keeping the full dataset. Not bad, not bad at all.
upvoted 0 times
Altha
1 year ago
Yeah, it's crucial to follow data privacy requirements while preprocessing customer data.
upvoted 0 times
...
Agustin
1 year ago
Using Dataflow and the Cloud Data Loss Prevention API seems like a solid approach.
upvoted 0 times
...
Ruthann
1 year ago
I agree, it's important to balance data privacy with retaining useful information.
upvoted 0 times
...
Alisha
1 year ago
Option A sounds like a good choice. It masks sensitive data while keeping the full dataset.
upvoted 0 times
...
Mammie
1 year ago
Yeah, it's crucial to follow data privacy requirements when handling customer data.
upvoted 0 times
...
Roy
1 year ago
Using Dataflow and the Cloud Data Loss Prevention API seems like a solid approach.
upvoted 0 times
...
Patria
1 year ago
I agree, it's important to balance data privacy with retaining useful information.
upvoted 0 times
...
Craig
1 year ago
Option A sounds like a good choice. It masks sensitive data while keeping the full dataset.
upvoted 0 times
...
...
Monroe
1 year ago
Hmm, Option B might be the easiest solution, but I'm worried about potentially losing valuable data in the process. Better to err on the side of caution.
upvoted 0 times
Ettie
1 year ago
User 2: I agree, it's better to be cautious and not risk losing any valuable information.
upvoted 0 times
...
Nichelle
1 year ago
User 1: I think Option B is the safest choice to protect sensitive data.
upvoted 0 times
...
...
Diane
1 year ago
I'm leaning towards Option D. Handling the encryption at the storage level and using federated queries in BigQuery could be more efficient and secure.
upvoted 0 times
Tawna
1 year ago
Definitely. This approach can help protect sensitive data while retaining it for future use cases.
upvoted 0 times
...
Quiana
1 year ago
It's important to follow the principle of least privilege when sharing encryption keys.
upvoted 0 times
...
Jina
1 year ago
I agree. Using federated queries in BigQuery can also help maintain data privacy.
upvoted 0 times
...
Leila
1 year ago
Option D sounds like a good choice. Encrypting the data at the storage level is a secure approach.
upvoted 0 times
...
...
Melvin
1 year ago
Option C seems like the way to go. Encrypting the sensitive data while retaining the full dataset for future use is a smart approach.
upvoted 0 times
...
Lisha
1 year ago
That's a good point, but I still think option A is more secure in terms of protecting sensitive data elements.
upvoted 0 times
...
Flo
1 year ago
I disagree, I believe option B is better as it uses the Cloud Data Loss Prevention API and Dataflow to detect and remove sensitive fields.
upvoted 0 times
...
Lisha
1 year ago
I think option A is the best choice because it uses Dataflow and the Cloud Data Loss Prevention API to mask sensitive data.
upvoted 0 times
...

Save Cancel