exam questions

Exam AWS Certified Solutions Architect - Professional All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional exam

Exam AWS Certified Solutions Architect - Professional topic 1 question 759 discussion

A company wants to migrate 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 and 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 data 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 these requirements?

  • A. Set up an Amazon Aurora MySQL database as a replication target for the on-premises database. 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 a Network Load Balancer (NLB), and use Amazon RDS Proxy to write to the Aurora MySQL database. When the databases are synced, disable the replication job and restart the Aurora Replica as the primary instance. Point the collector DNS record to the NLB.
  • B. 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. Move the aggregation jobs to run against the Aurora MySQL database. Set up collection endpoints behind an Application Load Balancer (ALB) as Amazon EC2 instances in an Auto Scaling group. 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.
  • C. 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.
  • D. Set up an Amazon Aurora MySQL database. 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 an Amazon Kinesis data stream. Use Amazon Kinesis Data Firehose to replicate the data to the Aurora MySQL database. When the databases are synced, disable the replication job and restart the Aurora Replica as the primary instance. Point the collector DNS record to the Kinesis data stream.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
Jupi
Highly Voted 3 years, 1 month ago
A - Incorrect - Network Load Balancers do not support the lambda target type. Application Load Balancers are the only load balancers that support the lambda target type B - InCorrect - This will not solve problem of load jobs fail, while the aggregate job runs C- Correct - Aurora Replica for aggregates job and RDS proxy for better RDS performance D- Incorrect - Kinesis Firehose ca not replicate data to aurora directly
upvoted 22 times
...
mericov
Highly Voted 3 years, 2 months ago
C - Migrate the database with DMS -> Create a read replica - aggregation jobs will read data from RR -> Endpoints with Lambda behind an ALB -> use Proxy to write to master DB. Once synchronized, stop the task and point collectors to ALB. For B, is too complicated to configure the apps as EC2 instances. Instead Lambda is suitable. A, Lambda cannot run behind NLB.
upvoted 10 times
...
evargasbrz
Most Recent 1 year, 11 months ago
Selected Answer: C
I'll go with C
upvoted 1 times
...
aandc
2 years, 5 months ago
Selected Answer: C
C adds read replica to solve aggregation jobs issue
upvoted 1 times
...
AzureDP900
2 years, 12 months ago
I will go with C
upvoted 3 times
...
cldy
2 years, 12 months ago
C. 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.
upvoted 2 times
...
backfringe
3 years ago
I'd go with C
upvoted 2 times
...
acloudguru
3 years ago
Selected Answer: C
B - InCorrect - This will not solve problem of load jobs fail, while the aggregate job runs
upvoted 3 times
...
andylogan
3 years, 1 month ago
It''s C - 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%
upvoted 3 times
...
tgv
3 years, 1 month ago
CCC ---
upvoted 2 times
...
blackgamer
3 years, 1 month ago
C for sure.
upvoted 1 times
...
Cotter
3 years, 1 month ago
I think C.
upvoted 2 times
...
zolthar_z
3 years, 1 month ago
Answer is C, even B works did not fix the reading issue from the aggregation task
upvoted 4 times
...
Abhiju2019
3 years, 1 month ago
it should be B
upvoted 1 times
...
pablobairat
3 years, 2 months ago
C it is
upvoted 4 times
...
pkboy78
3 years, 2 months ago
I think it is B
upvoted 1 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
Loading ...