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

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 72 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 72
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.
Which of the following will resolve this issue?

  • A. Edit the my.cnf file for the DB cluster to increase max_connections
  • B. Increase the instance size of the DB cluster
  • C. Change the DB cluster to Multi-AZ
  • D. Increase the number of Aurora Replicas
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by BillyC at July 27, 2020, 2:48 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
novice_expert
Highly Voted 3 years ago
Selected Answer: B
B. Increase the instance size of the DB cluster we need more connections which depend on instance Max_connection is a formula in RDS parameter group: GREATEST({log(DBInstanceClassMemory/805306368)*45},{log(DBInstanceClassMemory/8187281408)*1000}) https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.html You can increase the maximum number of connections to your Aurora MySQL DB instance by scaling the instance up to a DB instance class with more memory, or by setting a larger value for the max_connections parameter in the DB parameter group for your instance, up to 16,000. You must change a larger value for the max_connections parameter in the DB parameter group, not edit my.cnf, it is not physical server hosting MySQL.
upvoted 6 times
...
Pranava_GCP
Most Recent 1 year, 9 months ago
Selected Answer: B
B. Increase the instance size of the DB cluster "You can increase the maximum number of connections to your Aurora MySQL DB instance by scaling the instance up to a DB instance class with more memory, or by setting a larger value for the max_connections parameter in the DB parameter group for your instance, up to 16,000." https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.html
upvoted 1 times
...
Shunpin
3 years, 5 months ago
Selected Answer: B
Max_connection is a formula in RDS parameter group: GREATEST({log(DBInstanceClassMemory/805306368)*45},{log(DBInstanceClassMemory/8187281408)*1000})
upvoted 3 times
...
guru_ji
3 years, 7 months ago
I got this Question in exam. Answer: B
upvoted 4 times
...
ChauPhan
3 years, 7 months ago
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.html You can increase the maximum number of connections to your Aurora MySQL DB instance by scaling the instance up to a DB instance class with more memory, or by setting a larger value for the max_connections parameter in the DB parameter group for your instance, up to 16,000. You must change a larger value for the max_connections parameter in the DB parameter group, not edit my.cnf, it is not physical server hosting MySQL.
upvoted 3 times
...
Dip11
3 years, 7 months ago
ANS B. RDS doesn't allow to change config files on host so A is ruled out.
upvoted 1 times
...
myutran
3 years, 7 months ago
Ans: B
upvoted 2 times
...
JobinAkaJoe
3 years, 8 months ago
B is the best answer
upvoted 2 times
...
Billhardy
3 years, 8 months ago
B is correct
upvoted 2 times
...
BillyMadison
3 years, 8 months ago
Agree with B because of https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.html "You can increase the maximum number of connections to your Aurora MySQL DB instance by scaling the instance up to a DB instance class with more memory, or by setting a larger value for the max_connections parameter, up to 16,000." Could be A as well, just haven't seen good enough documentation to choose it.
upvoted 4 times
ChauPhan
3 years, 7 months ago
You can change a larger value for the max_connections parameter in the DB parameter group, not edit my.cnf, so A is incorrect
upvoted 3 times
...
...
BillyC
3 years, 8 months ago
Ans B is correct
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