Which of the following RAID configurations provides the BEST performance for database files while still providing redundancy?

The correct answer is D. RAID 5. RAID 5 provides the best balance of performance and redundancy for database files among the given options by distributing both data and parity across all disks.

Server hardware installation and management

Question

Options

ARAID 0
BRAID 1
CRAID 3
DRAID 5

How the community answered

(61 responses)

A
2% (1)
B
2% (1)
C
3% (2)
D
93% (57)

Why each option

RAID 5 provides the best balance of performance and redundancy for database files among the given options by distributing both data and parity across all disks.

ARAID 0

RAID 0 provides excellent performance but offers no redundancy, meaning data is lost if any disk fails, making it unsuitable for critical database files.

BRAID 1

CRAID 3

DRAID 5Correct

RAID 5 offers good read performance and reasonable write performance for database files by striping data and parity across all disks, allowing for efficient use of disk space and single disk fault tolerance. It strikes a good balance between performance, capacity, and redundancy, making it a common choice for general database storage.

Concept tested: RAID levels, performance, and redundancy

Source: https://learn.microsoft.com/en-us/windows-server/storage/disk-management/understanding-raid

Topics

#RAID 5#database performance#data redundancy#RAID levels

Community Discussion

No community discussion yet for this question.

Full SK0-003 Practice