ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 891 - SAA-C03 discussion

Report
Export

A company hosts a database that runs on an Amazon RDS instance deployed to multiple Availability Zones. A periodic script negatively affects a critical application by querying the database. How can application performance be improved with minimal costs?

A.

Add functionality to the script to identify the instance with the fewest active connections and query that instance.

Answers
A.

Add functionality to the script to identify the instance with the fewest active connections and query that instance.

B.

Create a read replica of the database. Configure the script to query only the read replica.

Answers
B.

Create a read replica of the database. Configure the script to query only the read replica.

C.

Instruct the development team to manually export new entries at the end of the day.

Answers
C.

Instruct the development team to manually export new entries at the end of the day.

D.

Use Amazon ElastiCache to cache the common queries the script runs.

Answers
D.

Use Amazon ElastiCache to cache the common queries the script runs.

Suggested answer: B

Explanation:

Option A introduces complexity and does not scale well.

Option B creates a read replica, offloading read traffic from the primary RDS instance without impacting the critical application.

Option C is manual and inefficient.

Option D might help for caching frequently queried data but is not ideal for ad-hoc reporting.

Therefore, Option B is the best choice.

asked 29/11/2024
Chien Fang
40 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first