Answer-first summary for fast verification
Answer: 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.
The most secure and time-efficient method for transferring sensitive patient records from a 10 TB relational database to BigQuery is option B. This approach involves exporting the records as an Avro file, copying the file onto a Transfer Appliance, and sending it to Google. This method ensures security and speed by avoiding internet transmission and leveraging the Transfer Appliance's high transfer rates. Option A, while secure, may be less time-efficient due to the upload process. Options C and D involve less secure methods, such as creating public URLs, and may not be as efficient for large data volumes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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.
No comments yet.