SG0-001 · Question #373
A storage administrator is allocating storage for a new database application. Based on disk provisioning best practices, which of the following is the MINIMUM number of RAID array volumes from a SAN-a
The correct answer is C. 2. For a new database application, disk provisioning best practices recommend a minimum of two RAID array volumes from a SAN-attached storage system to separate the operating system/binaries from the database data and log files.
Question
A storage administrator is allocating storage for a new database application. Based on disk provisioning best practices, which of the following is the MINIMUM number of RAID array volumes from a SAN-attached storage system that is needed?
Options
- A0
- B1
- C2
- D3
How the community answered
(23 responses)- A4% (1)
- B13% (3)
- C78% (18)
- D4% (1)
Why each option
For a new database application, disk provisioning best practices recommend a minimum of two RAID array volumes from a SAN-attached storage system to separate the operating system/binaries from the database data and log files.
Zero volumes would mean no storage is allocated, which is not possible for any operational database application.
While technically a database could run on a single volume, this setup is highly discouraged for production environments due to poor I/O performance, increased contention, and complex management for critical database components.
A minimum of two RAID array volumes is considered a best practice for database provisioning. One volume should be dedicated to the operating system and application binaries, while a separate, distinct volume should be used for the database data files and transaction logs to optimize I/O performance and facilitate independent backup/recovery operations.
Three volumes (e.g., OS, data, logs) is often a better practice for larger or more critical databases, but two volumes represent the absolute minimum for basic separation and performance benefits.
Concept tested: Database storage provisioning best practices
Topics
Community Discussion
No community discussion yet for this question.