Professional Cloud ArchitectDesign and plan a cloud solution architectureEasy
A large enterprise is migrating its on-premises data warehouse to Google Cloud. The current data warehouse is several petabytes in size and requires high throughput for analytical queries. The enterprise also needs to ensure strong data consistency and durability. Which Google Cloud storage solution is most appropriate for this scenario?
- ACloud Storage Nearline
- BCloud Storage Standard
- CBigQuery
- DCloud Spanner
Show answer & explanationAnswer & explanation
Correct answer: C. BigQuery
BigQuery is a fully managed, serverless data warehouse designed for petabyte-scale analytics. It offers high throughput, strong consistency, and durability, making it ideal for migrating large enterprise data warehouses.
Why the other options are wrong
- A. Cloud Storage Nearline is for infrequently accessed data and not optimized for analytical queries.
- B. Cloud Storage Standard is object storage, suitable for general-purpose data storage but not optimized for data warehousing analytics.
- D. Cloud Spanner is a globally distributed relational database, not a data warehouse. It's designed for transactional workloads, not large-scale analytics.
BigQuery
A fully managed, serverless, and highly scalable enterprise data warehouse on Google Cloud designed for analytics.
- Petabyte-scale data warehousing
- Serverless and cost-effective
- High throughput for analytical queries
- Strong data consistency and durability
Memory trick: BigQuery's big queries analyze big data.