Exam Associate Cloud Engineer topic 1 question 217 discussion

Another duplicate question

as already answered in question 188, the answer is CLoud SQL.

Cloud SQL is very similar to postgreSQL

Cloud SQL (supports PostgreSQL), so it should require minimal code changes. Answer: C. Cloud SQL

So what about this another question? Your company has an internal application for managing transactional orders. The application is used exclusively by employees in a single physical location. The application requires strong consistency, fast queries, and ACID guarantees for multi-table transactional updates. The first version of the application is implemented in PostgreSQL, and you want to deploy it to the cloud with minimal code changes. Which database is most appropriate for this application? A. BigQuery B. Cloud SQL C. Cloud Spanner D. Cloud Datastore It should be Cloud Spanner or Cloud SQL ?

ACID and strong consistency are in C or D, but Firestore is for documents and in question we have "multi-table updates" so there left C

Cloud SQL is the most appropriate choice for deploying the application with the required characteristics while minimizing code changes and maintaining strong consistency, fast queries, and ACID guarantees for multi-table transactional updates.