Professional Cloud ArchitectManage and provision solution infrastructureEasy
A data engineering team is building a new data warehouse on Google Cloud. They need a fully managed, petabyte-scale, serverless data warehouse that can run complex SQL queries over structured and semi-structured data, and integrate seamlessly with business intelligence tools. Which Google Cloud service should they choose?
- ACloud Bigtable
- BCloud SQL
- CCloud Spanner
- DBigQuery
Show answer & explanationAnswer & explanation
Correct answer: D. BigQuery
BigQuery is a fully managed, serverless, petabyte-scale data warehouse designed for analytics. It supports standard SQL, handles structured and semi-structured data, and integrates well with BI tools, making it the perfect choice for this scenario.
Why the other options are wrong
- A. Cloud Bigtable is a NoSQL wide-column database for high-throughput operational analytics, not a SQL-based data warehouse.
- B. Cloud SQL is a regional relational database, not a petabyte-scale data warehouse for analytics.
- C. Cloud Spanner is a globally distributed relational database for transactional workloads, not primarily a data warehouse for analytics.
BigQuery
A fully managed, serverless, and highly scalable enterprise data warehouse that enables super-fast SQL queries using the processing power of Google's infrastructure.
- Serverless and petabyte-scale.
- Supports standard SQL queries.
- Separates compute and storage.
- Integrates with BI tools (Looker Studio, Tableau).
Memory trick: BigQuery: Big data, big queries, big insights.