DBS-C01 · Question #332
A company uses an Amazon RDS for PostgreSQL database in the us-east-2 Region. The company wants to have a copy of the database available in the us-west-2 Region as part of a new disaster recovery…
The correct answer is A. Set wal_level = logical. C. Set max_replication_slots to 1 or more, depending on the number of DMS tasks. E. Set wal_sender_timeout to 20,000 milliseconds. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html
Question
A company uses an Amazon RDS for PostgreSQL database in the us-east-2 Region. The company wants to have a copy of the database available in the us-west-2 Region as part of a new disaster recovery strategy. A database architect needs to create the new database. There can be little to no downtime to the source database. The database architect has decided to use AWS Database Migration Service (AWS DMS) to replicate the database across Regions. The database architect will use full load mode and then will switch to change data capture (CDC) mode. Which parameters must the database architect configure to support CDC mode for the RDS for PostgreSQL database? (Choose three.)
Options
- ASet wal_level = logical.
- BSet wal_level = replica.
- CSet max_replication_slots to 1 or more, depending on the number of DMS tasks.
- DSet max_replication_slots to 0 to support dynamic allocation of slots.
- ESet wal_sender_timeout to 20,000 milliseconds.
- FSet wal_sender_timeout to 5,000 milliseconds.
How the community answered
(24 responses)- A92% (22)
- D4% (1)
- F4% (1)
Explanation
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html
Topics
Community Discussion
No community discussion yet for this question.