Question 127 of 139
Choose 2You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)
ADrop or disable all users except database administration users.
BDisable all foreign key constraints on the source PostgreSQL database.
✓CEnsure that all PostgreSQL tables have a primary key.
DShut down the database before the Data Migration Service task is started.
✓EEnsure that pglogical is installed on the source PostgreSQL database.
✓
Correct Answer: C, E
Ensure that all PostgreSQL tables have a primary key.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.