New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

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

Google Cloud Certified - Associate Cloud Engineer Associate-Cloud-Engineer Question # 90 Topic 10 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 # 90 Topic 10 Discussion

Associate-Cloud-Engineer Exam Topic 10 Question 90 Discussion:
Question #: 90
Topic #: 10

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 Lumen6277 at Nov 16, 2025, 9:27:27 PM

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