Exam AWS Certified Database - Specialty topic 1 question 279 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 279
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company's database specialist is migrating a production Amazon RDS for MySQL database to Amazon Aurora MySQL. The source database is configured for Multi-AZ. The company's production team wants to validate the target database before switching the associated application over to use the new database endpoint. The database specialist plans to use AWS Database Migration Service (AWS DMS) for the migration.

Which steps should the database specialist perform to meet the production team's requirement? (Choose three.)

A. Enable automatic backups on the source database
B. Disable automatic backups on the source database
C. Enable binary logging. Set the binlog format parameter to ROW on the source database.
D. Enable binary logging. Set the binlog_format parameter to MIXED on the source database
E. Use the source primary database as the source endpoint for the DMS task. Configure the task as full load plus change data capture(CDC) to complete the migration
F. Use the source secondary database as the source endpoint for the DMS task. Configure the task as full load plus change data capture (CDC) to complete the migration

Show Suggested Answer

Suggested Answer: ACE 🗳️

by DBA_MJF at Nov. 30, 2022, 6:11 p.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

Submit Cancel

DBA_MJF

Highly Voted 2 years, 7 months ago

Selected Answer: ACE

I think the answer is ACE. However, C should be binlog_format (not binlog format(. The information below is from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html#CHAP_Source.MySQL.Homogeneous. When using an AWS-managed MySQL-compatible database as a source for AWS DMS, make sure that you have the following prerequisites for CDC: To enable binary logs for RDS for MySQL and for RDS for MariaDB, enable automatic backups at the instance level. Set the binlog_format parameter to "ROW".

upvoted 6 times

...