Computer Hacking Forensic Investigator (CHFI v10) — Question 303

Your organization is implementing a new database system and has chosen MySQL due to its pluggable storage engine capability and ability to handle parallel write operations securely. You are responsible for selecting the best-suited storage engine for your company's needs, which predominantly involves transactional processing, crash recovery, and high data consistency requirements. What would be the most appropriate choice?

Answer options

• A. InnoDB storage engine, because it supports traditional ACID and crash recovery, and is used in online transaction processing systems
• B. Memory storage engine, because it offers in-memory tables and implements a hashing mechanism for faster data retrieval
• C. MyISAM storage engine, because it offers unlimited data storage and high-speed data loads
• D. BDB storage engine, because it provides an alternative to InnoDB and supports additional transaction methods such as COMMIT and ROLLBACK

Correct answer: A

Explanation

The InnoDB storage engine is the best choice because it adheres to ACID principles, ensuring reliable transactions and effective crash recovery, which are essential for transactional processing. The Memory storage engine is not suitable as it does not support persistent storage. MyISAM, while fast, lacks the required support for transactions and crash recovery. BDB does offer some transaction capabilities, but InnoDB is the more robust and widely adopted option for high data consistency.