Professional Cloud ArchitectManage and provision solution infrastructureEasy
A financial services company is migrating its on-premises data warehouse to Google Cloud. They require a fully managed, petabyte-scale data warehouse that can handle complex analytical queries with high performance and support standard SQL. They also need to ensure data security and compliance with financial regulations. Which Google Cloud service is the most appropriate for this requirement?
- ACloud Storage
- BBigQuery
- CCloud SQL
- DCloud Spanner
Show answer & explanationAnswer & explanation
Correct answer: B. BigQuery
BigQuery is a fully managed, serverless, and highly scalable enterprise data warehouse designed for petabyte-scale analytics. It supports standard SQL and offers robust security features, making it ideal for the described scenario.
Why the other options are wrong
- A. Cloud Storage is an object storage service, not a data warehouse for querying structured data.
- C. Cloud SQL is a relational database service, not a petabyte-scale data warehouse for complex analytics.
- D. Cloud Spanner is a globally-distributed, strong-consistent relational database, not primarily a data warehouse.
BigQuery
Google Cloud's fully managed, serverless, and highly scalable enterprise data warehouse for petabyte-scale analytics.
- Serverless and cost-effective
- Supports standard SQL
- Designed for large-scale analytical queries
Memory trick: Big data, Big queries, Big results with BigQuery.