1. Home
  2. Discussions
  3. Google
  4. Google Cloud Certified
  5. Associate-Cloud-Engineer Discussions
  6. Associate-Cloud-Engineer Exam Topic 2 Question 16 Discussion

Google Cloud Certified - Associate Cloud Engineer Associate-Cloud-Engineer Question # 16 Topic 2 Discussion

 Google Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Google Cloud Certified - Associate Cloud Engineer Associate-Cloud-Engineer Question # 16 Topic 2 Discussion

Associate-Cloud-Engineer Exam Topic 2 Question 16 Discussion:
Question #: 16
Topic #: 2

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.

Get Premium Associate-Cloud-Engineer Questions
Actual exam question for Google Associate-Cloud-Engineer exam by Ember8854 at Aug 3, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next