Question 590
A database team repairs this problem: A PostgreSQL migration job creates tables but fails on an unsupported extension used by the source. Which measured outcome validates the correction?
Explanation
Correct Answer
Migrated application queries pass on supported target features. The result directly checks whether the remedy worked: Inventory extension dependencies and adapt or replace unsupported behavior before migrating schema. The cause was the source extension and target engine capability were never compared.
Incorrect Answers
Even if this observation were recorded, it would support a case where a Database Migration Service job for MySQL cannot begin CDC even though the source database responds to test SQL queries. It would not verify that migrated application queries pass on supported target features.
This finding belongs with a situation in which developers keep changing table definitions during a production continuous migration and the target schema drifts from the source. The required acceptance finding here is that migrated application queries pass on supported target features.
Even if this observation were recorded, it would support a case where a legacy database trigger calculates billing tax, but the new environment inserts rows without the corresponding update. It would not verify that migrated application queries pass on supported target features.