Google Cloud Digital LeaderInfrastructure modernization with Google CloudMedium
A financial analytics firm needs to perform complex SQL queries on petabytes of historical transaction data. This data is updated frequently with new transactions, but the queries are primarily for analytical purposes, not real-time operational lookups. The firm requires a fully managed, serverless solution that can handle massive data volumes and scale query performance without managing infrastructure. Which Google Cloud service is most suitable?
- ACloud Bigtable
- BBigQuery
- CCloud Spanner
- DCloud SQL
Show answer & explanationAnswer & explanation
Correct answer: B. BigQuery
BigQuery is a serverless, highly scalable, and cost-effective multi-cloud data warehouse designed for analyzing petabytes of data using SQL. It automatically manages infrastructure and scales query performance, making it ideal for complex analytical queries on large datasets.
Why the other options are wrong
- A. Cloud Bigtable is a NoSQL wide-column database for high-throughput operational analytics, not complex SQL queries on historical data.
- C. Cloud Spanner is a globally distributed transactional database, not primarily optimized for cost-effective petabyte-scale analytical queries.
- D. Cloud SQL is a regional transactional database, not designed for petabyte-scale analytical queries.
BigQuery
A serverless, highly scalable, and cost-effective multi-cloud data warehouse designed for business intelligence and analytics.
- Processes petabytes of data with SQL.
- Fully managed and serverless.
- Optimized for analytical workloads.
Memory trick: BigQuery: Big data, big questions, big answers.