Google Associate Cloud EngineerPlanning and configuring a cloud solutionEasy
A data analytics team needs to perform complex SQL queries on a petabyte-scale dataset. The team wants a fully managed, serverless solution that can handle massive data volumes and provide fast query results without requiring infrastructure provisioning or management. Which Google Cloud data storage and analytics service is best suited for this requirement?
- ACloud SQL
- BCloud Firestore
- CCloud Storage (with custom ETL)
- DBigQuery
Show answer & explanationAnswer & explanation
Correct answer: D. BigQuery
BigQuery is a fully managed, serverless data warehouse designed for petabyte-scale analytics. It allows users to run complex SQL queries on massive datasets without managing any infrastructure, perfectly matching the team's needs.
Why the other options are wrong
- A. Cloud SQL is a relational database for transactional workloads, not optimized for petabyte-scale analytical queries.
- B. Cloud Firestore is a NoSQL document database, not suitable for complex SQL analytics on petabyte-scale structured data.
- C. Cloud Storage can store petabytes of data, but performing complex SQL queries directly requires additional services and custom ETL, which BigQuery handles natively.
BigQuery
A fully managed, serverless, and highly scalable enterprise data warehouse on Google Cloud designed for petabyte-scale analytics, allowing users to run complex SQL queries.
- Serverless and fully managed
- Petabyte-scale data warehousing
- Supports standard SQL queries
- Separation of compute and storage
- Pay-per-query or flat-rate pricing
Memory trick: Analytics: Big data needs a 'Big' solution to find the 'Query' answer!