CompTIA DataSys+ (DS0-001)Database DeploymentHard
A database administrator is planning to expand the storage capacity of an existing database server. The current storage is running out of space, and the database requires continuous operation without downtime during the expansion. Which storage expansion method is MOST suitable for this requirement?
- AOffline storage migration to a larger array
- BReplacing existing disks with larger ones one by one, with downtime
- CCreating a new storage volume and manually moving data
- DAdding new disks to an existing RAID array with online expansion capabilities
Show answer & explanationAnswer & explanation
Correct answer: D. Adding new disks to an existing RAID array with online expansion capabilities
Adding new disks to an existing RAID array that supports online expansion allows the storage capacity to be increased without taking the database server offline, ensuring continuous operation.
Why the other options are wrong
- A. Offline storage migration requires significant downtime to move all data, which violates the continuous operation requirement.
- B. Replacing disks one by one, especially if involving downtime per disk, is a lengthy process and explicitly states 'with downtime', which is unacceptable.
- C. Creating a new volume and manually moving data would likely involve downtime for application configuration changes and data transfer, or at least complex synchronization.
Online Storage Expansion
The process of increasing the storage capacity of a database system while the database and its applications remain fully operational, without requiring downtime.
- Typically achieved with RAID controllers or storage arrays supporting online expansion.
- Allows adding disks, replacing smaller disks with larger ones, or expanding logical volumes.
- Minimizes disruption to critical applications.
Memory trick: Online expansion keeps your data flowing.