Google Associate Cloud EngineerPlanning and configuring a cloud solutionEasy
A data analytics team needs to process large datasets (tens of terabytes) using SQL queries. The data is accessed frequently for interactive analysis and dashboarding, and they require a fully managed, highly scalable, and cost-effective solution. Which Google Cloud data warehouse service should they choose?
- ABigQuery
- BCloud Spanner
- CCloud Bigtable
- DCloud SQL
Show answer & explanationAnswer & explanation
Correct answer: A. BigQuery
BigQuery is a serverless, highly scalable, and cost-effective data warehouse designed for petabyte-scale analytics. It is optimized for running complex SQL queries on large datasets for interactive analysis and dashboarding.
Why the other options are wrong
- B. Cloud Spanner is a globally distributed relational database, overkill for pure data warehousing and more expensive for this specific use case.
- C. Cloud Bigtable is a NoSQL database for high-throughput, low-latency key-value data, not optimized for SQL analytics on large datasets.
- D. Cloud SQL is a relational database designed for transactional workloads, not petabyte-scale analytical queries.
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.
- Serverless and fully managed
- Petabyte-scale analytics
- SQL-based querying
Memory trick: ANALYZE (Analytics, No-Ops, Large Data, SQL, Yield)