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?
Click on the arrows to vote for the correct answer
A. B. C. D.A.
The best recommendation for the frequent problems encountered due to the growing size of the order tables during a database audit is to develop an archiving approach, option A.
Explanation: Database performance can be affected by many factors, one of which is the size of tables. Large tables can cause slow response times, inefficient queries, and degraded database performance. Therefore, it is important to manage table size to ensure database performance and availability.
Option A, "Develop an archiving approach," is the best recommendation for managing table size. Archiving involves moving infrequently accessed data to a separate location while keeping the original data intact. This approach can help to reduce table size and improve database performance. The archived data can be stored in a separate database or file system, or it can be compressed and stored in the same database.
Option B, "Periodically delete completed orders," is not a good recommendation because it may result in data loss. Completed orders may contain important historical data that may be required for analysis or reporting purposes. Deleting them may also violate regulatory or legal requirements.
Option C, "Build more table indices," may help to improve query performance, but it will not directly address the issue of table size. Moreover, building too many indices can have a negative impact on database performance and may increase storage requirements.
Option D, "Migrate to a different database management system," is not a good recommendation unless the current database management system is not capable of handling the data volume or is causing significant performance issues. Migrating to a different system can be time-consuming, expensive, and may require significant changes to the existing applications and infrastructure.
In summary, developing an archiving approach is the best recommendation for managing table size and improving database performance.