Solved

You Have a Large 5-TB AVRO File Stored in a Cloud

Question 81

Multiple Choice

You have a large 5-TB AVRO file stored in a Cloud Storage bucket. Your analysts are proficient only in SQL and need access to the data stored in this file. You want to find a cost-effective way to complete their request as soon as possible. What should you do?


A) Load data in Cloud Datastore and run a SQL query against it.
B) Create a BigQuery table and load data in BigQuery. Run a SQL query on this table and drop this table after you complete your request.
C) Create external tables in BigQuery that point to Cloud Storage buckets and run a SQL query on these external tables to complete your request.
D) Create a Hadoop cluster and copy the AVRO file to NDFS by compressing it. Load the file in a hive table and provide access to your analysts so that they can run SQL queries.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents