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

A company is running a batch analysis every hour on their main transactional DB, running on an RDS MySQL instance, to populate their central Data Warehouse running on Redshift. During the execution of the batch, their transactional applications are very slow. When the batch completes they need to update the top management dashboard with the new data. The dashboard is produced by another system running on-premises that is currently started when a manually-sent email notifies that an update is required. The on-premises system cannot be modified because is managed by another team.
How would you optimize this scenario to solve performance issues and automate the process as much as possible?

  • A. Replace RDS with Redshift for the batch analysis and SNS to notify the on-premises system to update the dashboard
  • B. Replace RDS with Redshift for the oaten analysis and SQS to send a message to the on-premises system to update the dashboard
  • C. Create an RDS Read Replica for the batch analysis and SNS to notify me on-premises system to update the dashboard
  • D. Create an RDS Read Replica for the batch analysis and SQS to send a message to the on-premises system to update the dashboard.
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
cloudinvader
Highly Voted 3 years, 6 months ago
C is correct as "solve performance issues " by ReadReplica " and automate" SNS
upvoted 8 times
kaush
3 years, 6 months ago
Batch analysis is not the intended purpose for OLAP DB, That should be done by OLAP Database such as Redshift
upvoted 1 times
chigo17
3 years, 6 months ago
?? OLAP or OLAP.
upvoted 1 times
chigo17
3 years, 6 months ago
A should be the answer
upvoted 1 times
...
...
...
...
amministrazione
Most Recent 8 months, 3 weeks ago
C. Create an RDS Read Replica for the batch analysis and SNS to notify me on-premises system to update the dashboard
upvoted 1 times
...
SkyZeroZx
1 year, 10 months ago
Selected Answer: C
C is correct, since datawarehouse and traditional relational database is not the same thing. A data warehouse exists as a layer on top of another database or databases (usually OLTP databases). Addicionally not change database
upvoted 1 times
...
SkyZeroZx
1 year, 11 months ago
Selected Answer: C
C is correct as "solve performance issues " by ReadReplica " and automate" SNS
upvoted 1 times
...
hollie
2 years, 4 months ago
Selected Answer: A
Can batch analysis be served by read replicate? really doubt it...
upvoted 1 times
...
cldy
3 years, 4 months ago
C. Create an RDS Read Replica for the batch analysis and SNS to notify me on-premises system to update the dashboard
upvoted 1 times
...
01037
3 years, 6 months ago
Absolutely C
upvoted 1 times
...
cldy
3 years, 6 months ago
C. Read Replica for performance SNS for notification
upvoted 1 times
...
Gorha
3 years, 7 months ago
C is correct!
upvoted 2 times
...
amog
3 years, 7 months ago
Answer is C
upvoted 2 times
...
sorok7
3 years, 7 months ago
for the A
upvoted 3 times
...
DalianYifang
3 years, 7 months ago
never mind.
upvoted 1 times
...
DalianYifang
3 years, 7 months ago
Why not A?
upvoted 2 times
tan9
3 years, 7 months ago
C is correct, since datawarehouse and traditional relational database is not the same thing. A data warehouse exists as a layer on top of another database or databases (usually OLTP databases).
upvoted 6 times
user0001
2 years, 12 months ago
you dont want to change the database
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago