nerdexam
Amazon

DBS-C01 · Question #205

An application reads and writes data to an Amazon RDS for MySQL DB instance. A new reporting dashboard needs read-only access to the database. When the application and reports are both under heavy loa

The correct answer is A. Create a read replica of the DB instance. Configure the reports to connect to the replication. Take off only reports from the primary to read replica. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

Submitted by rania.sa· Mar 6, 2026Workload-Specific Database Design

Question

An application reads and writes data to an Amazon RDS for MySQL DB instance. A new reporting dashboard needs read-only access to the database. When the application and reports are both under heavy load, the database experiences performance degradation. A database specialist needs to improve the database performance. What should the database specialist do to meet these requirements?

Options

  • ACreate a read replica of the DB instance. Configure the reports to connect to the replication
  • BCreate a read replica of the DB instance. Configure the application and reports to connect to the
  • CEnable Multi-AZ deployment. Configure the reports to connect to the standby replica.
  • DEnable Multi-AZ deployment. Configure the application and reports to connect to the cluster

How the community answered

(46 responses)
  • A
    83% (38)
  • B
    9% (4)
  • C
    2% (1)
  • D
    7% (3)

Explanation

Take off only reports from the primary to read replica. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

Topics

#RDS MySQL#Read replicas#Performance optimization#Workload separation

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DBS-C01 Practice