Google Cloud Digital LeaderData and AI with Google CloudEasy
A global retail company wants to analyze customer purchasing behavior across their e-commerce platform and physical stores to personalize recommendations and optimize inventory. They need a fully managed, serverless, and highly scalable data warehouse solution that can handle petabytes of data and support complex analytical queries without requiring infrastructure management. Which Google Cloud product should they choose?
- ACloud Storage
- BCloud SQL
- CBigQuery
- DCloud Spanner
Show answer & explanationAnswer & explanation
Correct answer: C. BigQuery
BigQuery is Google Cloud's fully managed, serverless, and highly scalable enterprise data warehouse designed for petabyte-scale analytics, making it ideal for the retail company's needs.
Why the other options are wrong
- A. Cloud Storage is an object storage service, suitable for storing raw data but not for performing complex analytical queries directly.
- B. Cloud SQL is a relational database for transactional workloads, not a data warehouse for petabyte-scale analytics.
- D. Cloud Spanner is a globally distributed, strong consistent relational database, primarily for transactional workloads, not a data warehouse.
BigQuery
A fully managed, serverless, and highly scalable enterprise data warehouse on Google Cloud designed for petabytes of data.
- Serverless and cost-effective
- Supports SQL queries
- Ideal for large-scale analytics and business intelligence
Memory trick: Big data needs a Big Query to get answers.