SAP-C02 · Question #152
A company wants to nitrate its data analytics environment from on premises to AWS. The environment consists of two simple Node.js applications. One of the applications collects sensor data ard loads…
The correct answer is C. Set up an Amazon Aurora MySQL database. Set up an Amazon Aurora MySQL database. Use AWS Database Migration Service (AWS DMS) to perform continuous data replication from the on-premises database to Aurora. Create an Aurora Replica for the Aurora MySQL database, and move the aggregation jobs to run against the Aurora…
Question
A company wants to nitrate its data analytics environment from on premises to AWS. The environment consists of two simple Node.js applications. One of the applications collects sensor data ard loads it into a MySQL database. The other application aggregates the data into reports. When the aggregation jobs run. Some of the load jobs fail to run correctly. The company must resolve the cala loading issue. The company also needs the migration to occur without interruptions or changes for the company's customers. What should a solutions architect do to meet those requirements?
Options
- ASet up an Amazon Aurora MySQL database as a replication target for the on-premises database.
- BSet up an Amazon Aurora MySQL database.
- CSet up an Amazon Aurora MySQL database.
- DSet up an Amazon Aurora MySQL database.
How the community answered
(47 responses)- A15% (7)
- B4% (2)
- C72% (34)
- D9% (4)
Explanation
Set up an Amazon Aurora MySQL database. Use AWS Database Migration Service (AWS DMS) to perform continuous data replication from the on-premises database to Aurora. Create an Aurora Replica for the Aurora MySQL database, and move the aggregation jobs to run against the Aurora Replica. Set up collection endpoints as AWS Lambda functions behind an Application Load Balancer (ALB), and use Amazon RDS Proxy to write to the Aurora MySQL database. When the databases are synced, point the collector DNS record to the ALB. Disable the AWS DMS sync task after the cutover from on premises to AWS. Amazon RDS Proxy allows applications to pool and share connections established with the database, improving database efficiency and application scalability. With RDS Proxy, failover times for Aurora and RDS databases are reduced by up to 66%.
Community Discussion
No community discussion yet for this question.