Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Google Exam Professional Data Engineer Topic 3 Question 100 Discussion

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

You are designing storage for two relational tables that are part of a 10-TB database on Google Cloud. You want to support transactions that scale horizontally. You also want to optimize data for range queries on nonkey columns. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

To re-encrypt all of your CMEK-protected Cloud Storage data after a key has been exposed, and to ensure future writes are protected with a new key, creating a new Cloud KMS key and a new Cloud Storage bucket is the best approach. Here's why option C is the best choice:

Re-encryption of Data:

By creating a new Cloud Storage bucket and copying all objects from the old bucket to the new bucket while specifying the new Cloud KMS key, you ensure that all data is re-encrypted with the new key.

This process effectively re-encrypts the data, removing any dependency on the compromised key.

Ensuring CMEK Protection:

Creating a new bucket and setting the new CMEK as the default ensures that all future objects written to the bucket are automatically protected with the new key.

This reduces the risk of objects being written without CMEK protection.

Deletion of Compromised Key:

Once the data has been copied and re-encrypted, the old key can be safely deleted from Cloud KMS, eliminating the risk associated with the compromised key.

Steps to Implement:

Create a New Cloud KMS Key:

Create a new encryption key in Cloud KMS to replace the compromised key.

Create a New Cloud Storage Bucket:

Create a new Cloud Storage bucket and set the default CMEK to the new key.

Copy and Re-encrypt Data:

Use the gsutil tool to copy data from the old bucket to the new bucket while specifying the new CMEK key:

gsutil -o 'GSUtil:gs_json_api_version=2' cp -r gs://old-bucket/* gs://new-bucket/

Delete the Old Key:

After ensuring all data is copied and re-encrypted, delete the compromised key from Cloud KMS.


Cloud KMS Documentation

Cloud Storage Encryption

Re-encrypting Data in Cloud Storage

Contribute your Thoughts:

Sage
29 days ago
Wait, we're supposed to optimize for range queries? I thought we were designing storage for a dance club database. Guess I better re-read the question.
upvoted 0 times
...
Nickolas
1 months ago
Yo, what's up with these options? It's like they're trying to trick us or something. I'm just going to go with the one that sounds the most 'cloud-y'.
upvoted 0 times
Raymon
4 days ago
True, we need to optimize data for those nonkey columns.
upvoted 0 times
...
Arthur
6 days ago
But adding secondary indexes is important for range queries.
upvoted 0 times
...
Lajuana
10 days ago
Yeah, Cloud Spanner seems like a good choice for horizontal scaling.
upvoted 0 times
...
Arminda
16 days ago
I think option C sounds the most 'cloud-y'.
upvoted 0 times
...
...
Daisy
1 months ago
Cloud Dataflow, huh? Sounds like a lot of extra work to me. I'd rather just let Cloud Spanner do its thing and keep things simple.
upvoted 0 times
Magdalene
2 days ago
But Cloud Dataflow could help optimize data for range queries on nonkey columns.
upvoted 0 times
...
Shawnee
17 days ago
I agree, Cloud Spanner seems like the easier option.
upvoted 0 times
...
...
Devorah
1 months ago
I'm all about that Cloud SQL life. With some secondary indexes, it can totally handle those query patterns. Plus, it's a familiar relational database, so I'm comfortable with it.
upvoted 0 times
Billy
6 days ago
User 3: I agree, Cloud SQL with secondary indexes is a solid choice for optimizing data.
upvoted 0 times
...
Brock
14 days ago
User 2: Yeah, Cloud SQL is familiar and can handle it well.
upvoted 0 times
...
Goldie
1 months ago
User 1: Cloud SQL with secondary indexes is the way to go for those query patterns.
upvoted 0 times
...
...
Keshia
2 months ago
Cloud Spanner for the win! It's the perfect choice for a 10-TB database that needs horizontal scalability and support for range queries. Secondary indexes are the way to go.
upvoted 0 times
Lai
1 days ago
C) Use Cloud Spanner for storage. Add secondary indexes to support query patterns.
upvoted 0 times
...
Jamika
2 months ago
A) Use Cloud SQL for storage. Add secondary indexes to support query patterns.
upvoted 0 times
...
...
Remona
2 months ago
But wouldn't adding secondary indexes to Cloud Spanner optimize data for range queries on nonkey columns?
upvoted 0 times
...
Ben
2 months ago
I agree with Benbie. Cloud Spanner can support transactions that scale horizontally.
upvoted 0 times
...
Bobbie
2 months ago
I think we should use Cloud Spanner for storage.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77