CISA Certified Information Systems Auditor – Question0244

During a database audit, an IS auditor noted frequent problems due to the growing size of the order tables. Which of the following is the BEST recommendation in this situation?

A.
Develop an archiving approach.
B. Periodically delete completed orders.
C. Build more table indices.
D. Migrate to a different database management system.

Correct Answer: A