-
Mismatch between answer options & actual answer
updated 2 years ago
3 Members
·
4
Posts
-
2. QUESTION
Category: CSAA – Design High-Performing Architectures
A company has an on-premises MySQL database that needs to be replicated in Amazon S3 as CSV files. Once data has been fully copied, ongoing changes to the database should be continually streamed into the S3 bucket. The company wants a solution that can be implemented with little management overhead yet still highly secure.
Which ingestion pattern should a solutions architect take?
<ul data-question_id=”9850″ data-type=”single”>
- Use AWS Schema Conversion Tool (AWS SCT) to convert MySQL data to CSV files. Set up the AWS Server Migration Service (AWS MGN) to capture ongoing changes from the on-premises MySQL database and send them to Amazon S3.
- Use an AWS Snowball Edge cluster to migrate data to Amazon S3 and AWS DataSync to capture ongoing changes. Create your own custom AWS KMS envelope encryption key for the associated AWS Snowball Edge job.
- Create a full load and change data capture (CDC) replication task using AWS Database Migration Service (AWS DMS). Launch an AWS DMS endpoint with SSL using the AWS Network Firewall service.
- Set up a full load replication task using AWS Database Migration Service (AWS DMS). Add a new Certificate Authority (CA) certificate and create an AWS DMS endpoint with SSL.
The correct answer is marked as #3 yet in the explanation it is written out differently: <strong style=”font-family: inherit; font-size: inherit;”>Create a full load and change data capture (CDC) replication task using AWS Database Migration Service (AWS DMS). Add a new Certificate Authority (CA) certificate and create an AWS DMS endpoint with SSL.
<font face=”inherit”>This is a combination of options #3 and #4 of the actual question i.e. change data capture + CA certificate.</font>
<font face=”inherit”> Maybe there are some typos </font>that<font face=”inherit”> need fixing?</font>
-
Hello SabaLal,
Thanks for your feedback.
We have taken note of this mistake and will have it fixed.
Let me know if you have additional questions.
Regards,
Carlo @ Tutorials Dojo
-
Yes I noticed this as well and it added much confusion to an already confusing part of the data migration service.
The correct answer says:
“Set up a full load replication task using AWS Database Migration Service (AWS DMS). Add a new Certificate Authority (CA) certificate and create an AWS DMS endpoint with SSL.”
I would think that the correct answer would be:
“Set up a full load and change data capture (CDC) replication task using AWS Database Migration Service (AWS DMS). Add a new Certificate Authority (CA) certificate and create an AWS DMS endpoint with SSL.
Easy fix, just swap out those two intros for the answer in the two answers. Hope that helps a little more.
-
Hello Steve22,
Thanks for the feedback. I’ve already fixed the mismatched answers. The correct answer should be reflected after our admin has verified and approved the change.
Let me know if you have other concerns.
Regards,
Carlo @Tutorials DOjo
Log in to reply.