Free Google Professional Cloud Database Engineer Actual Exam Questions - Question 5 Discussion
to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What
should you do? (Choose two.)
Option E seems like a solid choice since pglogical is critical for logical replication in DMS migrations. For the second pick, I’d go with B. Disabling foreign key constraints on the source database can help avoid issues with data consistency and ordering during the migration. C is important but usually more for change data capture scenarios, and shutting down the database (D) is definitely not needed for DMS since it supports online migrations. So E and B make the most sense to me given this context.
E imo, pglogical is usually needed for logical replication with DMS, so that one makes sense. But I’m not sure about the primary key requirement—C might be important because some tools need it for replication or change tracking? Also, the question doesn’t specify if this is a one-time migration or ongoing replication, which could change what’s required. Does anyone know if Cloud SQL supports migrations without shutting down the source DB? That would make D less likely.