GoogleGoogle
PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #7
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #7: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
Planning and Implementing Database Migration
Question
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.)
Options
- 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.
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Database Migration Service (DMS)#PostgreSQL Migration#Cloud SQL#Logical Replication