Answer-first summary for fast verification
Answer: Export the records as an Avro file, copy the file onto a Transfer Appliance, send it to Google, and then load the Avro file into BigQuery using the BigQuery web UI in the GCP Console.
The most secure and time-efficient method for transferring millions of sensitive patient records from a 10 TB relational database to BigQuery is option C. This approach involves exporting the records as an Avro file, copying it onto a Transfer Appliance, and sending it to Google. Once received, the Avro file can be loaded into BigQuery via the GCP Console. This method ensures security by avoiding internet transmission and leverages the Transfer Appliance's high transfer rates. Other options either compromise on security by using public URLs or are less efficient due to the file format or transfer method chosen.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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 a CSV file, create a public URL for the CSV file, use Storage Transfer Service to move the file to Cloud Storage, and then load the CSV file into BigQuery using the BigQuery web UI in the GCP Console.
B
Export the records as an Avro file, upload the file to Google Cloud Storage (GCS) using gsutil, and then load the Avro file into BigQuery using the BigQuery web UI in the GCP Console.
C
Export the records as an Avro file, copy the file onto a Transfer Appliance, send it to Google, and then load the Avro file into BigQuery using the BigQuery web UI in the GCP Console.
D
Export the records as an Avro file, create a public URL for the Avro file, use Storage Transfer Service to move the file to Cloud Storage, and then load the Avro file into BigQuery using the BigQuery web UI in the GCP Console.