20+ practice questions focused on Migrate data solutions — one of the most tested topics on the Google Professional Cloud Database Engineer exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Migrate data solutions PracticeA team is migrating a PostgreSQL database to AlloyDB using DMS with continuous replication. The source database is configured with logical replication. After starting the migration job, the initial dump completes but CDC replication fails with a replication slot error. What is the most likely cause?
Explanation: The initial dump completes successfully because it uses a snapshot and does not require logical replication. However, for the CDC (change data capture) phase, DMS relies on logical replication slots to capture ongoing changes. This requires the source PostgreSQL database to have its wal_level parameter set to 'logical'. If it is set to 'replica' (the default), the write-ahead log does not contain the necessary information for logical replication, causing DMS to fail when trying to create or use the replication slot. Therefore, option A is correct.
A team is converting an Oracle stored procedure that uses PL/SQL with cursors to PostgreSQL PL/pgSQL. The procedure declares a cursor with parameters. Which conversion is correct for a parameterized cursor in PL/pgSQL?
Explanation: The correct conversion for a parameterized cursor in PL/pgSQL is to declare the cursor using the syntax 'CURSOR (param INT) FOR SELECT ...'. This is the direct equivalent of Oracle's parameterized cursor. While REFCURSOR can also be used, it is not the most direct conversion and does not declare the cursor with parameters in the same way.
An engineer is planning a migration from on-premises MySQL to Cloud SQL. They want to use Database Migration Service with continuous replication. What must be enabled on the source MySQL database before starting the migration job?
Explanation: Database Migration Service with continuous replication requires binary logging (binlog) on the source MySQL instance to capture and stream ongoing changes. Binary logs record all data modifications (INSERT, UPDATE, DELETE) in a format that Cloud SQL can replay, enabling near-real-time replication without downtime. Without binary logging enabled, only a one-time snapshot migration is possible, not continuous replication.
An organization needs to migrate a 2 TB Oracle database to Cloud SQL for PostgreSQL. The schema has many stored procedures using PL/SQL. Which tool should they use for schema conversion and what is a key consideration when converting PL/SQL?
Explanation: Ora2Pg is an open-source tool specifically designed to convert Oracle schemas (including PL/SQL stored procedures, functions, and triggers) to PostgreSQL-compatible PL/pgSQL. Since Oracle's PL/SQL and PostgreSQL's PL/pgSQL have significant syntactic and semantic differences (e.g., exception handling, cursor syntax, package handling), manual rewriting or tool-assisted conversion is required; Ora2Pg automates much of this conversion but still requires manual review and adjustment for complex logic.
A company is migrating their on-premises MySQL database to Cloud SQL using Database Migration Service (DMS). The source database is MySQL 5.7, and the target is a Cloud SQL MySQL 8.0 instance. The migration job is set to continuous, but after the full dump phase, the CDC phase keeps failing with the error 'binary log not found'. What is the most likely cause?
Explanation: DMS continuous migration requires binary logging enabled on the source with row-based format, and the binary log files must be retained until they are consumed. If the source binary logs are purged before DMS reads them, CDC fails.
+15 more Migrate data solutions questions available
Practice all Migrate data solutions questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Migrate data solutions. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Migrate data solutions questions on the PCDE frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Migrate data solutions is tested as part of the Google Professional Cloud Database Engineer blueprint. Practicing with targeted Migrate data solutions questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free PCDE practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Migrate data solutions is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Migrate data solutions practice session with instant scoring and detailed explanations.
Start Migrate data solutions Practice →