You have a requirement to insert minute-resolution data from 50,000 sensors into a BigQuery table. You expect significant growth in data volume and need the data to be available within 1 minute of…

Question

Options

• AExport 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
• BExport the records from the database as an Avro file. Copy the file onto a Transfer Appliance and send it to Google, and then load the Avro file into BigQuery
• CExport the records from the database into a CSV file. Create a public URL for the CSV file, and then use Storage Transfer Service to move the file to Cloud
• DExport the records from the database as an Avro file. Create a public URL for the Avro file, and then use Storage Transfer Service to move the file to Cloud

• A
  13% (4)
• B
  77% (24)
• C
  6% (2)
• D
  3% (1)

Explanation

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? in the GCP Console. using the BigQuery web UI in the GCP Console. Storage. Load the CSV file into BigQuery using the BigQuery web UI in the GCP Console. Storage. Load the Avro file into BigQuery using the BigQuery web UI in the GCP Console. Explanation/Reference: In sense of speek(time-effective) https://cloud.google.com/transfer-appliance/docs/4.0/overview#transfer-speeds ransfer Appliance, you can receive the appliance and capture 300 terabytes of data in under 25 days. Your data can be accessed in Cloud Storage within another 25 days, all without consuming any outbound network bandwidth.

No community discussion yet for this question.