If Performance Testing Shows That Queries Based on Frequently Accessed

question 39

Multiple Choice

If performance testing shows that queries based on frequently accessed fields are taking a long time to complete, what can the DBA do that might improve performance?

• A) increase the number of columns
• B) delete foreign keys
• C) add indexes
• D) add alternate keys

---

Definitions:

Annual Cash Inflow

The total amount of money received by a business or project within a year from all sources.

Equipment

Tools or machinery used for specific tasks, particularly in industries and manufacturing.

Financially Attractive

Describes an investment or project that is expected to deliver a favorable financial return or profit.

Salvage Value

The estimated residual value of an asset at the end of its useful life, reflecting the amount for which it could be sold or disposed.