Google Cloud Digital Leader — Question 29

Your organization wants to migrate its data management solutions to Google Cloud because it needs to dynamically scale up or down and to run transactional
SQL queries against historical data at scale. Which Google Cloud product or service should your organization use?

Answer options

• A. BigQuery
• B. Cloud Bigtable
• C. Pub/Sub
• D. Cloud Spanner

Correct answer: D

Explanation

Cloud Spanner is the correct choice because it is designed for transactional SQL queries and can scale dynamically to handle large amounts of data. BigQuery excels at analytics on large datasets but does not support transactional SQL. Cloud Bigtable is optimized for NoSQL workloads and Pub/Sub is for messaging, neither of which fit the need for transactional SQL capabilities.