nerdexam
Google

CLOUD-DIGITAL-LEADER · Question #319

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.

The correct answer is D. Cloud Spanner. Cloud Spanner is a fully managed, globally distributed relational database that supports ACID-compliant transactional SQL queries and scales dynamically (both up and down) to handle large workloads. BigQuery (A) is optimized for analytical queries, not transactional workloads. Cl

Choosing Google Cloud Data Management Solutions

Question

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?

Options

  • ABigQuery
  • BCloud Bigtable
  • CPub/Sub
  • DCloud Spanner

How the community answered

(24 responses)
  • A
    13% (3)
  • B
    4% (1)
  • C
    4% (1)
  • D
    79% (19)

Explanation

Cloud Spanner is a fully managed, globally distributed relational database that supports ACID-compliant transactional SQL queries and scales dynamically (both up and down) to handle large workloads. BigQuery (A) is optimized for analytical queries, not transactional workloads. Cloud Bigtable (B) is a NoSQL wide-column store, not a SQL transactional database. Pub/Sub (C) is a messaging service, not a database.

Topics

#Google Cloud Databases#Cloud Spanner#Transactional SQL#Scalability

Community Discussion

No community discussion yet for this question.

Full CLOUD-DIGITAL-LEADER Practice