You have a large 5-TB AVRO file stored in a Cloud Storage bucket, and your team of analysts, who are only skilled in SQL, require access to the data within this file. Considering the urgency and the need for a cost-effective solution, how would you facilitate their access to the data promptly?

Exam-Like

Load data in Cloud Datastore and run a SQL query against it.

7.5%

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.

20.6%

Create external tables in BigQuery that point to Cloud Storage buckets and run a SQL query on these external tables to complete your request.

65.0%

Create a Hadoop cluster and copy the AVRO file to HDFS by compressing it. Load the file in a hive table and provide access to your analysts so they can run SQL queries.

7.0%

Google Associate Cloud Engineer

Get started today

Comments

You have a large 5-TB AVRO file stored in a Cloud Storage bucket, and your team of analysts, who are only skilled in SQL, require access to the data within this file. Considering the urgency and the need for a cost-effective solution, how would you facilitate their access to the data promptly?