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

Exam AWS Certified Solutions Architect - Professional SAP-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional SAP-C02 exam
Go to Exam

Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 201 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional SAP-C02
Question #: 201
Topic #: 1
[All AWS Certified Solutions Architect - Professional SAP-C02 Questions]

A solutions architect needs to improve an application that is hosted in the AWS Cloud. The application uses an Amazon Aurora MySQL DB instance that is experiencing overloaded connections. Most of the application’s operations insert records into the database. The application currently stores credentials in a text-based configuration file.

The solutions architect needs to implement a solution so that the application can handle the current connection load. The solution must keep the credentials secure and must provide the ability to rotate the credentials automatically on a regular basis.

Which solution will meet these requirements?

  • A. Deploy an Amazon RDS Proxy layer. In front of the DB instance. Store the connection credentials as a secret in AWS Secrets Manager.
  • B. Deploy an Amazon RDS Proxy layer in front of the DB instance. Store the connection credentials in AWS Systems Manager Parameter Store
  • C. Create an Aurora Replica. Store the connection credentials as a secret in AWS Secrets Manager
  • D. Create an Aurora Replica. Store the connection credentials in AWS Systems Manager Parameter Store.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Roontha at May 27, 2023, 1:37 a.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
Masonyeoh
Highly Voted 1 year, 11 months ago
Selected Answer: A
Using RDS Proxy, you can handle unpredictable surges in database traffic. Otherwise, these surges might cause issues due to oversubscribing connections or creating new connections at a fast rate. RDS Proxy establishes a database connection pool and reuses connections in this pool. This approach avoids the memory and CPU overhead of opening a new database connection each time. To protect the database against oversubscription, you can control the number of database connections that are created.
upvoted 6 times
...
85b5b55
Most Recent 2 months ago
Selected Answer: A
To handle the overloaded connections and keep the secrets in the Amazon Secret Manager.
upvoted 1 times
...
carpa_jo
1 year, 3 months ago
Selected Answer: A
Use replicas to scale read, this use-case is about writing so C & D are out. Secret manager offers rotation, parameter store doesn't. So its A.
upvoted 2 times
...
duriselvan
1 year, 4 months ago
D. Aurora Replica with Parameter Store: Pros: Improves database capacity and reduces load on the primary instance. Parameter Store provides centralized configuration management. Cons: Manually rotating credentials in Parameter Store poses security risks.
upvoted 1 times
helloworldabc
8 months, 1 week ago
just A
upvoted 1 times
...
...
career360guru
1 year, 5 months ago
Selected Answer: A
Option A
upvoted 2 times
...
joleneinthebackyard
1 year, 5 months ago
Selected Answer: A
straight A. love these questions 😂
upvoted 1 times
...
NikkyDicky
1 year, 9 months ago
Selected Answer: A
easy A
upvoted 1 times
...
pupsik
1 year, 10 months ago
Selected Answer: A
Agree with other explanations here.
upvoted 1 times
...
rbm2023
1 year, 11 months ago
Selected Answer: A
Agree with A Rotate the keys using Secrets Manager, Param store does not cover it. RDS Proxy is exactly to solve the issues with overloaded connection because is a connection pool component.
upvoted 3 times
...
Roontha
1 year, 11 months ago
Answer : A https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html
upvoted 4 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