ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 323 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 323
Topic #: 1
[All AWS Certified Database - Specialty Questions]

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.)

  • A. Set wal_level = logical.
  • B. Set wal_level = replica.
  • C. Set max_replication_slots to 1 or more, depending on the number of DMS tasks.
  • D. Set max_replication_slots to 0 to support dynamic allocation of slots.
  • E. Set wal_sender_timeout to 20,000 milliseconds.
  • F. Set wal_sender_timeout to 5,000 milliseconds.
Show Suggested Answer Hide Answer
Suggested Answer: ACE 🗳️
by TQM__9MD at July 14, 2023, 1:25 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
missipssamarsh
1 year, 1 month ago
Selected Answer: ACE
ACE https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Prerequisites.CDC
upvoted 2 times
...
Germaneli
1 year, 7 months ago
Selected Answer: ACE
Evidence: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Prerequisites.CDC
upvoted 1 times
...
kerl
1 year, 8 months ago
ACE, Answer below, cannot set wal_sender_timeout to 5000 coz it needs minimum 10,000 (10 seconds). https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html
upvoted 2 times
...
tonyro2
1 year, 9 months ago
When setting wal_sender_timeout to a non-zero value, DMS requires a minimum of 10000 milliseconds (10 seconds), and fails if the value is less than 10000. Keep the value less than 5 minutes to avoid causing a delay during a Multi-AZ failover of a DMS replication instance. ACE
upvoted 2 times
...
Windy
1 year, 10 months ago
The answer is ACE
upvoted 2 times
...
TQM__9MD
1 year, 10 months ago
Selected Answer: ACE
ACE ACE
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago