Google Cloud Digital LeaderDigital transformation with Google CloudMedium
A large telecommunications company is undergoing a significant digital transformation to provide new 5G services and enhance customer engagement through personalized offers. They need to analyze massive volumes of real-time network telemetry data, customer interaction logs, and billing information to detect anomalies, predict churn, and deliver tailored experiences. The solution requires a highly scalable, serverless data warehouse that can perform complex analytical queries on petabytes of structured and semi-structured data, without requiring infrastructure management. Which Google Cloud service is the primary choice for this analytical workload?
- ABigQuery
- BCloud Storage
- CCloud SQL
- DCloud Spanner
Show answer & explanationAnswer & explanation
Correct answer: A. BigQuery
BigQuery is a serverless, highly scalable, and cost-effective enterprise data warehouse designed for petabyte-scale analytics. It excels at performing complex analytical queries on structured and semi-structured data without requiring infrastructure management, making it ideal for the telecommunications company's needs.
Why the other options are wrong
- B. Cloud Storage is an object storage service, primarily for storing data, not for performing complex analytical queries directly.
- C. Cloud SQL is a managed relational database service, suitable for transactional workloads, but not optimized for petabyte-scale analytical queries.
- D. Cloud Spanner is a globally distributed relational database for transactional workloads, not primarily a data warehouse for petabyte-scale analytics.
BigQuery
A fully managed, serverless, and highly scalable enterprise data warehouse for analytics.
- Handles petabytes of data.
- Optimized for complex analytical queries (OLAP).
- Serverless, pay-as-you-go model.
Memory trick: BigQuery: Big data, big queries, big insights.