What should you do?
You 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.)
A . Drop or disable all users except database administration users.
B . Disable all foreign key constraints on the source PostgreSQL database.
C . Ensure that all PostgreSQL tables have a primary key.
D . Shut down the database before the Data Migration Service task is started.
E . Ensure that pglogical is installed on the source PostgreSQL database.
Answer: C, E
Explanation:
https://cloud.google.com/database-migration/docs/postgres/faq
Latest Professional Cloud Database Engineer Dumps Valid Version with 120 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments