Q91 — AWS DEA-C01 Ch.1

Question 91 of 100 | ← Chapter 1

A retail company stores data from a product lifecycle management (PLM) application in an on-premises MySQL database. The PLM Application frequently updates the database when transactions occur. The company wants to gather insights from the PLM application in near real time. The company wants to integrate the insights with other Business datasets and to analyze the combined dataset by using an Amazon Redshift data warehouse. The company has already established an AWS Direct Connect connection between the on-premises infrastructure and AWS. Which solution will meet these requirements with the LEAST development effort?

• A. Run a scheduled AWS Glue extract, transform, and load (ETL) job to get the MySQL database updates by using a Java Database Connectivity (JDBC) connection. Set Amazon Redshift as the destination for the ETL job.
• B. Run a full load plus CDC task in AWS Database Migration Service (AWS DMS) to continuously replicate the MySQL database changes. Set Amazon Redshift as the destination for the task. ✓
• C. Use the Amazon AppFlow SDK to build a custom connector for the MySQL database to continuously replicate the database changes. Set Amazon Redshift as the destination for the connector.
• D. Run scheduled AWS DataSync tasks to synchronize data from the MySQL database. Set Amazon Redshift as the destination for the Tasks.

Correct Answer: B. Run a full load plus CDC task in AWS Database Migration Service (AWS DMS) to continuously replicate the MySQL database changes. Set Amazon Redshift as the destination for the task.

Explanation

答案B是正确的。在这种情况下，AWSDatabaseMigrationService(AWSDMS)的全量加载加变更数据捕获（CDC）任务能够持续复制MySQL数据库的变化，并将其同步到AmazonRedshift中。与其他选项相比，AWSDMS无需大量的开发工作，能够较为便捷地满足公司近实时获取PLM应用数据洞察、与其他业务数据集集成及在AmazonRedshift中分析的需求。选项A中定时的AWSGlueETL作业可能无法满足近实时需求；选项C中使用SDK构建自定义连接器需要较大的开发工作；选项D中定时的AWSDataSync任务也不能实现持续的近实时数据复制。