Exam Cloud Digital Leader topic 1 question 27 discussion

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.

Specifically says transations which means Spanner.

Bigquery all the way. Spanner is HUGE for big companies like Google so it's overkill

The answer is A; hint being transactional as oppose to unstructured

I challenge the votes - it is Bigquery IMHO as it only ask "to run transactional SQL queries against historical data", Spanner would be quite expensive for this purpose.

BQ for Analytics and ML, Spanner for OLTP

A, analyze HISTORICAL data, not real time DB processing data. Its BQ. They want to analyze data mgt. It's not Spanner.

Go for D

D is correct

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.

D is correct

Correct Answer is A Big query

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.

A. BigQuery

CLoud Spanner

D. transactional SQL queries