Google Cloud Professional Data Engineer PDE — Topic 1 Question 101

Question

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?

Accepted Answer

Correct answer: A. The correct answer is A. Option 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. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage.

Google Cloud Professional Data Engineer PDE — Question 101