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:
Verified
Q76: You significantly changed a complex Deployment Manager
Q77: You deployed an LDAP server on Compute
Q78: You have a developer laptop with the
Q79: You have production and test workloads that
Q80: You are using Deployment Manager to create
Q82: Your company has an existing GCP organization
Q83: You are building an archival solution for
Q84: You have production and test workloads that
Q85: You need to configure IAM access audit
Q86: You have a workload running on Compute
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents