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.

Spanner decouples compute resources from data storage, which makes it possible to transparently scale in and out processing resources. Each additional compute capacity can process both reads and writes, providing effortless horizontal scalability. Spanner optimizes performance by automatically handling the sharding, replication, and transaction processing.

BigQuery for scalable, serverless, and cost-effective SQL-based analytics.

"transactional SQL queries against HISTORICAL data at scale" sounds more like data analytics on historical data than OLTP, I'm leaning towards BigQuery (A)

It's definitely BigQuery. Do not get carried away by the word 'Transactional'. It simply means running simple SQL queries. The keyword to look for is historical data. You wouldn't use Spanner for storing historical data. It's always BigQuery.

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