Topic 1 Question 115
You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
Migrate the existing database to Firestore.
Migrate the existing database to Cloud SQL for PostgreSQL.
Migrate the existing database to Cloud Spanner.
Migrate the existing database to PostgreSQL running on Compute Engine.
ユーザの投票
コメント(3)
- 正解だと思う選択肢: B
Migrate to CloudSQL
👍 2chelbsik2022/12/26 B: Migrate the existing database to Cloud SQL for PostgreSQL.
👍 1pk3492022/12/24B. Firestore is a NoSQL database. Eliminate A. You could migrate to Spanner leveraging the PostgreSQL dialect, but costs need to be minimized so that wouldn’t be the cheapest option. Especially since the load doesn’t justify Spanner. Again, you could migrate like-for-like to a GCE VM, but that defeats minimizing the migration effort. The cheapest and easiest way to migrate would be Database Migration Service to Cloud SQL for PostgreSQL.
👍 1dynamic_dba2023/03/16
シャッフルモード