Your organization needs to build a data lake that allows data analysts to query petabytes of data. The data is semi-structured and will be in formats like Avro, JSON, and Parquet. Which GCP service would be the best fit for this requirement?
Choose an answer
Tap an option to check your answer.
Correct answer: Google BigQuery.
Why this is the answer
*Explanation:* A. Correct, BigQuery is designed for ad-hoc querying of petabytes of data and supports semi-structured formats like Avro, JSON, and Parquet. B. Incorrect, Cloud Spanner is more focused on OLTP workloads. C. Incorrect, Cloud SQL is not designed to handle petabytes of semi-structured data. D) Incorrect, Cloud Datastore is a NoSQL database and not designed for querying petabytes of data. E) Incorrect, Cloud Bigtable is optimized for high-throughput, scalable NoSQL storage but is not ideal for ad-hoc querying of petabytes of data.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed