A Database Specialist Must Create a Read Replica to Isolate

question 112

Multiple Choice

A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times. What could be causing these slow response times?

• A) New volumes created from snapshots load lazily in the background
• B) Long-running statements on the master
• C) Insufficient resources on the master
• D) Overload of a single replication thread by excessive writes on the master

---

Definitions:

Long-term Debt

Debt obligations with a maturity of more than one year, utilized to finance a company's operations or expansions over a longer period.

Capital Lease

A lease arrangement that transfers substantially all the risks and rewards of ownership of an asset to the lessee, essentially treated as a purchase.

Retained Earnings

The portion of net earnings not paid out as dividends but instead reinvested in the company or used to pay off debt.

Deferred Income Taxes

Taxes applicable on income that is recognized in financial statements in one period but is taxable in another period.