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 3 Question 120 Discussion

You need to copy millions of sensitive patient records from a relational database to BigQuery. The total size of the database is 10 TB. You need to design a solution that is secure and time-efficient. What should you do?
A) Export the records from the database as an Avro file. Upload the file to GCS using gsutil, and then load the Avro file into BigQuery using the BigQuery web UI in the GCP Console.
B) Export the records from the database as an Avro file. Copy the file onto a Transfer Appliance and send it to Google, and then load the Avro file into BigQuery using the BigQuery web UI in the GCP Console.
C) Export the records from the database into a CSV file. Create a public URL for the CSV file, and then use Storage Transfer Service to move the file to Cloud Storage. Load the CSV file into BigQuery using the BigQuery web UI in the GCP Console.
D) Export the records from the database as an Avro file. Create a public URL for the Avro file, and then use Storage Transfer Service to move the file to Cloud Storage. Load the Avro file into BigQuery using the BigQuery web UI in the GCP Console.

Google Professional Data Engineer Exam - Topic 3 Question 120 Discussion

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

You need to copy millions of sensitive patient records from a relational database to BigQuery. The total size of the database is 10 TB. You need to design a solution that is secure and time-efficient. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Avery at Apr 10, 2026, 12:24 AM

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
Sena
3 hours ago
Option B is the best for security.
upvoted 0 times
...
Dallas
5 days ago
Avro files are the way to go for this size!
upvoted 0 times
...
Eun
10 days ago
Definitely not C, that's way too risky.
upvoted 0 times
...
Dante
16 days ago
Surprised that CSV is even an option here!
upvoted 0 times
...
Marsha
2 months ago
I think A is faster, though.
upvoted 0 times
...
Myong
2 months ago
Option B is the best choice for security!
upvoted 0 times
...
Melita
3 months ago
I remember that using gsutil is generally faster for uploads, but I’m not sure if it’s the best for sensitive data compared to the Transfer Appliance.
upvoted 0 times
...
Matthew
3 months ago
I practiced a similar question where we had to consider both security and efficiency. I feel like option B is the safest choice, but I’m not entirely confident.
upvoted 0 times
...
Ty
3 months ago
I think using a Transfer Appliance might be the best option here since the database is so large, but I can't recall if it’s the only secure method.
upvoted 0 times
...
Tiffiny
3 months ago
I remember we discussed the importance of using Avro for schema evolution, but I'm not sure if exporting to a public URL is secure enough for sensitive data.
upvoted 0 times
...

Save Cancel