Professional Cloud Architect · Free Practice Question Medium
Question 20
Your organization is planning to migrate a large on-premise data warehouse to Google Cloud Platform. The data warehouse is currently hosted on a Hadoop cluster with Hive. The management decided to migrate to Google Cloud to use the managed services offered by Google. Which service should you choose?
-
A
Use Cloud Bigtable as it offers low latency access to large datasets.
-
B
Use Cloud Storage as it provides unified object storage.
-
C
Use Cloud Spanner as it provides strong transactional consistency.
-
D
Use BigQuery as it provides a highly scalable, serverless, and cost-effective multi-cloud data warehouse.
Reveal correct answer
Correct answer: D
A.
Cloud Bigtable is designed for high-throughput, low-latency workloads and is typically used as a NoSQL database for operational, not analytical, workloads.
B.
Cloud Storage is not a database or data warehouse service. It's an object storage service for storing and accessing data on Google Cloud Platform infrastructure.
C.
Cloud Spanner is a highly scalable, enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale. It is not designed for analytical workloads typical for a data warehouse.
D.
BigQuery is designed to handle data analysis on large datasets and would be a suitable replacement for a Hadoop/Hive-based data warehouse.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
