ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C03 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam
Go to Exam

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: B 🗳️
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 (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Guru4Cloud
Highly Voted 1 year, 3 months 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 11 times
...
TariqKipkemei
Highly Voted 1 year, 7 months ago
Selected Answer: B
Load balancing = Read replica High availability = Multi AZ
upvoted 8 times
BillaRanga
10 months, 2 weeks ago
No Modifications allowerd = Read Replica
upvoted 4 times
...
...
terminator69
Most Recent 4 months, 1 week ago
How in the bloody hell it's D?????
upvoted 1 times
...
TruthWS
9 months ago
B is correct
upvoted 2 times
...
ExamGuru727
9 months 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 5 times
...
Buck12345
10 months ago
It is B
upvoted 2 times
...
Cyberkayu
1 year 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
11 months, 4 weeks ago
How would 'issuing queries to the read replica' prevent modifications or updates?
upvoted 2 times
...
...
KMohsoe
1 year, 7 months ago
Selected Answer: A
Why not A? :(
upvoted 1 times
wRhlH
1 year, 6 months ago
"The reporting process takes a few hours with the use of RELATIONAL queries."
upvoted 4 times
Murtadhaceit
1 year ago
DocumentDB (For MongoDB) is no SQL. DynamoDB is also No SQL. Therefore, options A and D are out.
upvoted 5 times
...
...
...
lexotan
1 year, 8 months ago
Selected Answer: B
B is the right one. why admin does not correct these wrong answers?
upvoted 4 times
...
imvb88
1 year, 8 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 5 times
...
WherecanIstart
1 year, 9 months ago
Selected Answer: B
B is right..
upvoted 2 times
...
Maximus007
1 year, 9 months ago
Selected Answer: B
While both B&D seems to be a relevant, ChatGPT suggest B as a correct one
upvoted 2 times
...
cegama543
1 year, 9 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 3 times
...
UnluckyDucky
1 year, 9 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 2 times
...
Ashukaushal619
1 year, 9 months ago
its D only ,recorrected
upvoted 2 times
Murtadhaceit
1 year ago
DynamoDB is no SQL. A and D are out!
upvoted 2 times
...
...
Ashukaushal619
1 year, 9 months ago
Selected Answer: B
bbbbbbbb
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago