Google Cloud Digital LeaderGeneral knowledge of Google CloudEasy
A data analytics team needs to process massive datasets (terabytes to petabytes) for business intelligence and ad-hoc analysis. They require a fully managed, serverless data warehouse that can perform lightning-fast SQL queries without provisioning or managing infrastructure. Which Google Cloud product is most appropriate?
- AGoogle Cloud Storage
- BGoogle Cloud BigQuery
- CGoogle Cloud SQL
- DGoogle Cloud Spanner
Show answer & explanationAnswer & explanation
Correct answer: B. Google Cloud BigQuery
Google Cloud BigQuery is a fully managed, serverless data warehouse designed for large-scale analytical queries, offering high performance on petabytes of data without infrastructure management.
Why the other options are wrong
- A. Cloud Storage is an object storage service, not a data warehouse for SQL queries.
- C. Cloud SQL is a relational database for transactional workloads, not a serverless data warehouse for petabyte-scale analytics.
- D. Cloud Spanner is a globally distributed relational database for transactional workloads, not primarily a serverless data warehouse for ad-hoc BI.
Google Cloud BigQuery
Google Cloud BigQuery is a fully managed, serverless, and highly scalable enterprise data warehouse designed for business intelligence and ad-hoc analysis of large datasets using SQL.
- Separation of compute and storage.
- Automatically scales to petabytes of data.
- Pay-per-query or flat-rate pricing.
- Supports standard SQL and integrates with BI tools.
Memory trick: For 'Big' 'Queries' on 'Big' data, choose 'BigQuery'.