Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Amazon Discussions

Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 381 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03
Question #: 381
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

A company hosts a three-tier web application that includes a PostgreSQL database. The database stores the metadata from documents. The company searches the metadata for key terms to retrieve documents that the company reviews in a report each month. The documents are stored in Amazon S3. The documents are usually written only once, but they are updated frequently.

The reporting process takes a few hours with the use of relational queries. The reporting process must not prevent any document modifications or the addition of new documents. A solutions architect needs to implement a solution to speed up the reporting process.

Which solution will meet these requirements with the LEAST amount of change to the application code?

  • A. Set up a new Amazon DocumentDB (with MongoDB compatibility) cluster that includes a read replica. Scale the read replica to generate the reports.
  • B. Set up a new Amazon Aurora PostgreSQL DB cluster that includes an Aurora Replica. Issue queries to the Aurora Replica to generate the reports.
  • C. Set up a new Amazon RDS for PostgreSQL Multi-AZ DB instance. Configure the reporting module to query the secondary RDS node so that the reporting module does not affect the primary node.
  • D. Set up a new Amazon DynamoDB table to store the documents. Use a fixed write capacity to support new document entries. Automatically scale the read capacity to support the reports.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by [deleted] at March 10, 2023, 3:09 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Guru4Cloud
Highly Voted 9 months, 2 weeks ago
Selected Answer: B
The key reasons are: Aurora PostgreSQL provides native PostgreSQL compatibility, so minimal code changes would be required. Using an Aurora Replica separates the reporting workload from the main workload, preventing any slowdown of document updates/inserts. Aurora can auto-scale read replicas to handle the reporting load. This allows leveraging the existing PostgreSQL database without major changes. DynamoDB would require more significant rewrite of data access code. RDS Multi-AZ alone would not fully separate the workloads, as the secondary is for HA/failover more than scaling read workloads.
upvoted 10 times
...
TariqKipkemei
Highly Voted 1 year, 1 month ago
Selected Answer: B
Load balancing = Read replica High availability = Multi AZ
upvoted 6 times
BillaRanga
4 months, 4 weeks ago
No Modifications allowerd = Read Replica
upvoted 2 times
...
...
TruthWS
Most Recent 3 months, 1 week ago
B is correct
upvoted 1 times
...
ExamGuru727
3 months, 1 week ago
Selected Answer: B
We also have a requirement for the Least amount of change to the code. Since our DB is PostgreSQL, A & D are immediately out. Multi-AZ won't help with offloading read requests, hence the answer is B ;)
upvoted 3 times
...
Buck12345
4 months, 2 weeks ago
It is B
upvoted 1 times
...
Cyberkayu
6 months, 3 weeks ago
Selected Answer: C
D. Reporting process Must not prevent = allow modification and addition of new document. all read replica were wrong.
upvoted 1 times
pentium75
6 months, 1 week ago
How would 'issuing queries to the read replica' prevent modifications or updates?
upvoted 1 times
...
...
KMohsoe
1 year, 1 month ago
Selected Answer: A
Why not A? :(
upvoted 1 times
wRhlH
1 year ago
"The reporting process takes a few hours with the use of RELATIONAL queries."
upvoted 3 times
Murtadhaceit
7 months ago
DocumentDB (For MongoDB) is no SQL. DynamoDB is also No SQL. Therefore, options A and D are out.
upvoted 4 times
...
...
...
lexotan
1 year, 2 months ago
Selected Answer: B
B is the right one. why admin does not correct these wrong answers?
upvoted 3 times
...
imvb88
1 year, 2 months ago
Selected Answer: B
The reporting process queries the metadata (not the documents) and use relational queries-> A, D out C: wrong since secondary RDS node in MultiAZ setup is in standby mode, not available for querying B: reporting using a Replica is a design pattern. Using Aurora is an exam pattern.
upvoted 4 times
...
WherecanIstart
1 year, 3 months ago
Selected Answer: B
B is right..
upvoted 1 times
...
Maximus007
1 year, 3 months ago
Selected Answer: B
While both B&D seems to be a relevant, ChatGPT suggest B as a correct one
upvoted 1 times
...
cegama543
1 year, 3 months ago
Selected Answer: B
Option B (Set up a new Amazon Aurora PostgreSQL DB cluster that includes an Aurora Replica. Issue queries to the Aurora Replica to generate the reports) is the best option for speeding up the reporting process for a three-tier web application that includes a PostgreSQL database storing metadata from documents, while not impacting document modifications or additions, with the least amount of change to the application code.
upvoted 2 times
...
UnluckyDucky
1 year, 3 months ago
Selected Answer: B
"LEAST amount of change to the application code" Aurora is a relational database, it supports PostgreSQL and with the help of read replicas we can issue the reporting proccess that take several hours to the replica, therefore not affecting the primary node which can handle new writes or document modifications.
upvoted 1 times
...
Ashukaushal619
1 year, 3 months ago
its D only ,recorrected
upvoted 1 times
Murtadhaceit
7 months ago
DynamoDB is no SQL. A and D are out!
upvoted 1 times
...
...
Ashukaushal619
1 year, 3 months ago
Selected Answer: B
bbbbbbbb
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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
ex Want to SAVE BIG on Certification Exam Prep?
close
ex Unlock All Exams with ExamTopics Pro 75% Off
  • arrow Choose From 1000+ Exams
  • arrow Access to 10 Exams per Month
  • arrow PDF Format Available
  • arrow Inline Discussions
  • arrow No Captcha/Robot Checks
Limited Time Offer
Ends in

Claim Offer Now
286 people claimed it in the last 6 hours