Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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 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.