Associate Cloud Engineer · Free Practice Question Medium
Question 12
The CFO of your company wants to improve an existing data warehouse by migrating it to Google Cloud. They want to minimize operational overhead while ensuring existing SQL tools can be used with the migrated data warehouse. What GCP service would you recommend?
- A Bigtable
- B Cloud SQL
- C Cloud Spanner
- D BigQuery
Reveal correct answer
Correct answer: D
Explanation
BigQuery is a managed, petabyte scale data warehouse, which uses SQL. Bigtable does not support SQL. Cloud SQL and Cloud Spanner support SQL but are designed for transaction processing, not analytical applications like data warehouses. For more information, see https://cloud.google.com/bigquery/docs/how-to.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
