Google Cloud Digital LeaderInfrastructure modernization with Google CloudEasy
A global financial institution is migrating its legacy data warehouses to Google Cloud. They require a fully managed, petabyte-scale analytics data warehouse that can handle complex SQL queries, offer strong consistency, and provide real-time insights from large datasets. They also need to integrate seamlessly with their existing business intelligence (BI) tools. Which Google Cloud product should they choose?
- ACloud Spanner
- BCloud Storage
- CBigQuery
- DCloud SQL
Show answer & explanationAnswer & explanation
Correct answer: C. BigQuery
BigQuery is a fully managed, petabyte-scale, serverless data warehouse designed for analytics, supporting complex SQL queries, real-time insights, and integration with BI tools, making it ideal for migrating legacy data warehouses.
Why the other options are wrong
- A. Cloud Spanner is a globally distributed relational database for transactional workloads, not primarily an analytics data warehouse.
- B. Cloud Storage is an object storage service, not a data warehouse capable of running complex SQL queries.
- D. Cloud SQL is a managed relational database for transactional workloads, not an analytics data warehouse at petabyte scale.
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.
- Petabyte-scale analytics
- Serverless architecture, no infrastructure to manage
- Supports standard SQL and integrates with BI tools
Memory trick: BigQuery: Big data, big insights, big and fast queries.