Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You are tasked with securely and efficiently transferring millions of sensitive patient records from a 10 TB relational database to BigQuery. Which method should you choose?
A
Export the records as an Avro file, upload it to Google Cloud Storage (GCS) using gsutil, and then load it into BigQuery via the GCP Console.
B
Export the records as an Avro file, copy it onto a Transfer Appliance, send it to Google, and then load it into BigQuery via the GCP Console.
C
Export the records into a CSV file, create a public URL for it, use Storage Transfer Service to move it to Cloud Storage, and then load it into BigQuery via the GCP Console.
D
Export the records as an Avro file, create a public URL for it, use Storage Transfer Service to move it to Cloud Storage, and then load it into BigQuery via the GCP Console.
