Google Cloud Digital LeaderData and AI with Google CloudEasy
A global retail company wants to analyze customer purchasing behavior across their e-commerce website, physical stores, and mobile application to identify trends and personalize marketing campaigns. They need a fully managed, serverless, and highly scalable data warehouse solution that can handle petabytes of structured and semi-structured data and support complex analytical queries. Which Google Cloud product is best suited for this requirement?
- ACloud SQL
- BCloud Storage
- CBigQuery
- DCloud Spanner
Show answer & explanationAnswer & explanation
Correct answer: C. BigQuery
BigQuery is designed as a fully managed, serverless, and highly scalable enterprise data warehouse that excels at analyzing petabytes of data using SQL, making it ideal for cross-platform customer behavior analysis.
Why the other options are wrong
- A. Cloud SQL is a relational database for transactional workloads, not an analytical data warehouse for petabytes of data.
- B. Cloud Storage is an object storage service, primarily used for storing raw data, not for direct analytical querying as a data warehouse.
- D. Cloud Spanner is a globally distributed relational database for transactional workloads, not optimized for large-scale analytical queries.
BigQuery
BigQuery is Google Cloud's fully managed, serverless, and highly scalable enterprise data warehouse for analytics.
- Serverless and cost-effective
- Handles petabytes of data
- Supports complex SQL queries for analytics
Memory trick: BigQuery is BIG on Queries for BIG data.