nerdexam
CompTIA

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.

Storage Implementation

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)
  • A
    4% (1)
  • B
    13% (3)
  • C
    78% (18)
  • D
    4% (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.

A0

Zero volumes would mean no storage is allocated, which is not possible for any operational database application.

B1

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.

C2Correct

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.

D3

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

#Database storage#RAID volumes#Storage provisioning best practices

Community Discussion

No community discussion yet for this question.

Full SG0-001 Practice