CompTIA DataSys+ (DS0-001)Database Management and MaintenanceEasy
A database administrator is setting up a new production database server. To ensure optimal performance and prevent I/O bottlenecks, they decide to store the database data files, transaction log files, and temporary files on separate physical disks. Which of the following database management practices are they primarily applying?
- AData Compression
- BDatabase File Separation
- CDatabase Sharding
- DDatabase Auditing
Show answer & explanationAnswer & explanation
Correct answer: B. Database File Separation
Storing different types of database files on separate physical disks is a common practice known as Database File Separation. This helps to distribute I/O operations across multiple spindles, reducing contention and improving overall performance by preventing bottlenecks.
Why the other options are wrong
- A. Data Compression reduces storage space and I/O volume, but it's not the primary practice described for separating file types.
- C. Database Sharding involves horizontally partitioning data across multiple database instances, which is a different scaling technique.
- D. Database Auditing involves tracking and recording database events for security and compliance, not I/O performance.
Database File Separation
The practice of storing different types of database files (e.g., data, transaction logs, temporary files) on separate physical disks or storage arrays.
- Reduces I/O contention
- Improves database performance
- Distributes workload across storage resources
Memory trick: Separate disks for separate tasks, keeps the database moving fast.