Topic 1 Question 76
You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?
Export the data from the existing database, and load the data into a new Cloud SQL database.
Use Migrate for Compute Engine to complete the migration.
Use Datastream to complete the migration.
Use Database Migration Service to complete the migration.
ユーザの投票
コメント(3)
- 正解だと思う選択肢: D
Database Migration Service should hadle this.
👍 6chelbsik2022/12/25 A: Export the data from the existing database, and load the data into a new Cloud SQL database. For a standard export from Cloud SQL, the export is run while the database is online. When the data being exported is smaller, the impact is likely to be minimal. However, when there are large databases, or large objects, such as BLOBs in the database, there's the possibility that the export might degrade database performance. This might impact the time it takes to perform database queries and operations against the database. After you start an export, it's not possible to stop it if your database starts to respond slowly. There are three main approaches to database migration: big bang data migration, trickle data migration, and zero downtime migration.
👍 1pk3492022/12/24D. The key is minimal downtime. That eliminates A. Migrate for Compute Engine operates at the VM level. That eliminates B. Migrating from a GCE VM to Cloud SQL is a classic use case for the Database Migration Service. D is the best answer.
👍 1dynamic_dba2023/03/13
シャッフルモード