Professional Cloud ArchitectManage and provision solution infrastructureEasy
An analytics team needs to process massive datasets (petabytes) for complex, ad-hoc queries and generate business intelligence reports. The data is structured and semi-structured. They require a fully managed, serverless data warehouse that can scale automatically to handle fluctuating workloads, provide high query performance, and support standard SQL. Which Google Cloud service should they choose?
- ABigQuery
- BCloud Storage
- CCloud SQL
- DCloud Spanner
Show answer & explanationAnswer & explanation
Correct answer: A. BigQuery
BigQuery is a fully managed, serverless, highly scalable data warehouse designed for petabyte-scale analytics, supporting complex SQL queries and providing excellent performance for business intelligence workloads.
Why the other options are wrong
- B. Cloud Storage is object storage, not a data warehouse, and requires additional services for querying and analysis.
- C. Cloud SQL is a relational database for transactional workloads, not optimized for petabyte-scale analytical queries.
- D. Cloud Spanner is a globally distributed, relational database for transactional workloads, not primarily an analytical data warehouse.
BigQuery
A fully managed, serverless, and highly scalable enterprise data warehouse on Google Cloud, designed for analytics.
- Handles petabytes of data.
- Supports standard SQL queries.
- Provides high performance and automatic scaling.
Memory trick: BigQuery for big data, big questions, big answers.