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 51 discussion

A customer has a 10 GB AWS Direct Connect connection to an AWS region where they have a web application hosted on Amazon Elastic Computer Cloud (EC2).
The application has dependencies on an on-premises mainframe database that uses a BASE (Basic Available, Soft state, Eventual consistency) rather than an
ACID (Atomicity, Consistency, Isolation, Durability) consistency model. The application is exhibiting undesirable behavior because the database is not able to handle the volume of writes.
How can you reduce the load on your on-premises database resources in the most cost-effective way?

  • A. Use an Amazon Elastic Map Reduce (EMR) S3DistCp as a synchronization mechanism between the on-premises database and a Hadoop cluster on AWS.
  • B. Modify the application to write to an Amazon SQS queue and develop a worker process to flush the queue to the on-premises database.
  • C. Modify the application to use DynamoDB to feed an EMR cluster which uses a map function to write to the on-premises database.
  • D. Provision an RDS read-replica database on AWS to handle the writes and synchronize the two databases using Data Pipeline.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
piotr
Highly Voted 3 years, 9 months ago
A is wrong - S3DistCp is used between HDFS and S3, not a database. I would go with B (SQS to flaten write request rate to DB).
upvoted 20 times
...
Moon
Highly Voted 3 years, 9 months ago
I agree...answer is B: http://jayendrapatil.com/aws-sqs-simple-queue-service/#targetText=A%20customer%20has%20a%2010,Elastic%20Computer%20Cloud%20(EC2).&targetText=The%20application%20is%20exhibiting%20undesirable,handle%20the%20volume%20of%20writes.
upvoted 18 times
manoj101
3 years, 9 months ago
Cost effective solution is another reason to go with B
upvoted 4 times
...
...
thanhpolimi
Most Recent 9 months, 2 weeks ago
Answer is B. A is totally wrong
upvoted 1 times
...
amministrazione
10 months, 2 weeks ago
B. Modify the application to write to an Amazon SQS queue and develop a worker process to flush the queue to the on-premises database.
upvoted 1 times
...
SkyZeroZx
2 years ago
Selected Answer: B
B because database is some legacy and when handle intesive write operations fail then i need reduce writes SQS is a classic option .
upvoted 1 times
...
rtguru
2 years, 1 month ago
because eventual consistency is required , B is best fit for the scenario
upvoted 1 times
...
CertNerd1234
2 years, 5 months ago
As it is explicitly stated that the on-prem database is BASE and not ACID using an SQS queue to buffer writes seems like the obvious thing to do.
upvoted 1 times
...
TigerInTheCloud
2 years, 6 months ago
Selected Answer: B
There is no right answer. If there are peaks of high-volume writing then B makes sense. Others do not make any sense at all.
upvoted 1 times
...
Ni_yot
2 years, 10 months ago
B for me. Eventual consistency = SQS
upvoted 2 times
...
kangtamo
3 years ago
Selected Answer: B
Go with B
upvoted 1 times
...
johnnsmith
3 years, 4 months ago
C is correct. Eventual consistency implys multiple nodes. Map function writes to all nodes in parallel.
upvoted 1 times
...
Akhil254
3 years, 7 months ago
B Correct
upvoted 1 times
...
01037
3 years, 8 months ago
Has to be B
upvoted 1 times
...
cldy
3 years, 8 months ago
B. SQS good to absorb writes + also cost effective
upvoted 1 times
...
MHKyaw
3 years, 8 months ago
I go with B
upvoted 1 times
...
newme
3 years, 8 months ago
Answer is B
upvoted 1 times
...
fullaws
3 years, 8 months ago
B is correct
upvoted 3 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 ...