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?

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

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

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

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

Show Suggested Answer

Suggested Answer: A

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

Limited Time Offer

25%

2 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

...