ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 75 - DVA-C02 discussion

Report
Export

A developer has created an AWS Lambda function that makes queries to an Amazon Aurora MySQL DB instance. When the developer performs a test the OB instance shows an error for too many connections.

Which solution will meet these requirements with the LEAST operational effort?

A.
Create a read replica for the DB instance Query the replica DB instance instead of the primary DB instance.
Answers
A.
Create a read replica for the DB instance Query the replica DB instance instead of the primary DB instance.
B.
Migrate the data lo an Amazon DynamoDB database.
Answers
B.
Migrate the data lo an Amazon DynamoDB database.
C.
Configure the Amazon Aurora MySQL DB instance tor Multi-AZ deployment.
Answers
C.
Configure the Amazon Aurora MySQL DB instance tor Multi-AZ deployment.
D.
Create a proxy in Amazon RDS Proxy Query the proxy instead of the DB instance.
Answers
D.
Create a proxy in Amazon RDS Proxy Query the proxy instead of the DB instance.
Suggested answer: D

Explanation:

This solution will meet the requirements by using Amazon RDS Proxy, which is a fully managed, highly available database proxy for Amazon RDS that makes applications more scalable, more resilient to database failures, and more secure. The developer can create a proxy in Amazon RDS Proxy, which sits between the application and the DB instance and handles connection management, pooling, and routing. The developer can query the proxy instead of the DB instance, which reduces the number of open connections to the DB instance and avoids errors for too many connections.

Option A is not optimal because it will create a read replica for the DB instance, which may not solve the problem of too many connections as read replicas also have connection limits and may incur additional costs. Option B is not optimal because it will migrate the data to an Amazon DynamoDB database, which may introduce additional complexity and overhead for migrating and accessing data from a different database service. Option C is not optimal because it will configure the Amazon Aurora MySQL DB instance for Multi-AZ deployment, which may improve availability and durability of the DB instance but not reduce the number of connections.

Reference: [Amazon RDS Proxy], [Working with Amazon RDS Proxy]


asked 16/09/2024
Alexander Ferrer
46 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first