Question 10
A legacy application issues PostgreSQL transactions, uses relational constraints and SQL joins, and requires its database engine without a self-managed database VM. Which Google Cloud service is the closest fit?
Explanation
Correct Answer
Cloud SQL supplies a fully managed PostgreSQL-compatible relational engine, preserving the application’s PostgreSQL transactions, constraints, and SQL joins without requiring the team to administer a database VM.
Incorrect Answers
BigQuery is designed for analytics rather than serving as a drop-in PostgreSQL transactional engine with the application’s existing SQL semantics.
Cloud Storage stores objects and does not implement PostgreSQL transactions, constraints, or relational SQL joins required by the application.
Firestore is a document database and does not provide transparent PostgreSQL compatibility or arbitrary relational join behavior.