Step2Study
Professional Cloud ArchitectManage implementationEasy

A large retail company is migrating its on-premises data warehouse to Google Cloud. The existing data warehouse uses complex SQL queries and stored procedures that are critical for daily business intelligence reports. The company requires a fully managed, petabyte-scale data warehouse solution that can seamlessly handle these existing SQL workloads with minimal refactoring. Which Google Cloud service should you recommend?

  1. ACloud Storage
  2. BCloud Spanner
  3. CBigQuery
  4. DCloud SQL
Show answer & explanation

Correct answer: C. BigQuery

BigQuery is Google Cloud’s fully managed, serverless, and highly scalable data warehouse designed for analytics at petabyte scale. It natively supports standard SQL, making it ideal for migrating existing SQL-based data warehouses with minimal refactoring.

Why the other options are wrong

  • A. Cloud Storage is an object storage service, suitable for storing large amounts of data, but it is not a data warehouse service itself and does not provide SQL query capabilities directly.
  • B. Cloud Spanner is a globally distributed, strongly consistent relational database, not primarily a data warehouse solution for petabyte-scale analytics and BI workloads.
  • D. Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server, suitable for transactional workloads, but not designed for petabyte-scale analytical data warehousing.

BigQuery

BigQuery is a fully managed, serverless, and highly scalable enterprise data warehouse on Google Cloud designed for analytics at petabyte scale.

  • Serverless and fully managed.
  • Petabyte-scale data warehousing.
  • Supports standard SQL for analytics.
  • Separates compute and storage.

Memory trick: BigQuery is the BIG BRAIN for cloud data analytics.

Practice this question Study as flashcard All questions
Previous question

More Manage implementation questions