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?
D
Reference:
https://cloud.google.com/terms/services
Answer: D --> Q? states transactional SQL, so its Spanner
Google BigQuery does not support transactions and does not allow updating of existing records. On the other hand, Google Cloud Spanner supports OLTP along with scalability and high availability.
Hello, Can A -> Big Query be an option also, since you can fire SQL queries at scale?
Yes, but for analytic queries and not transactional queries
BigQuery - as the main objective is to query against historical data
True, but not for transactional queries rather analytic queries. BigQuery is a columnar database and is not fit for transactional queries,
Exactly, BigQuery is for OLAP (online analytical processing), while Spanner is meant for OLTP (online transactional processing)
Cloud Spanner is a globally distributed, horizontally scalable, and strongly consistent relational database service provided by Google Cloud. Cloud Spanner is well-suited for transactional workloads with strong consistency requirements across multiple regions. If your focus is more on performing transactional SQL queries against historical data, ensuring strong consistency, and managing relational database workloads, Cloud Spanner would be a suitable choice.
D. transactional SQL queries
Cloud Spanner is a globally distributed, strongly consistent, and horizontally scalable database service on Google Cloud. It's designed for high availability, scalability, and transactional consistency, making it a great choice for applications that require both transactional and analytical capabilities.
Spanner is transaccional & scalable
Cloud Spanner is the right answer
Spanner
CLoud Spanner
A. BigQuery
Wrong. BigQuery is OLAP while the question asks you for OLTP. So the answer is D.
Correct Answer is A Big query
D is correct
D is correct
Go for D
A, analyze HISTORICAL data, not real time DB processing data. Its BQ. They want to analyze data mgt. It's not Spanner.