nerdexam
CompTIA

SG0-001 · Question #358

Which of the following RAID levels will provide the BEST performance for Database Log Drive without jeopardizing the redundancy?

The correct answer is B. RAID 1+0. For database log drives that demand both high write performance and robust data redundancy, RAID 1+0 offers the optimal solution.

Storage Functionality

Question

Which of the following RAID levels will provide the BEST performance for Database Log Drive without jeopardizing the redundancy?

Options

  • ARAID 0
  • BRAID 1+0
  • CRAID 1
  • DRAID 6

How the community answered

(17 responses)
  • A
    6% (1)
  • B
    88% (15)
  • C
    6% (1)

Why each option

For database log drives that demand both high write performance and robust data redundancy, RAID 1+0 offers the optimal solution.

ARAID 0

RAID 0 provides excellent performance but offers no data redundancy, meaning a single disk failure results in complete data loss, which is unacceptable for a database log drive.

BRAID 1+0Correct

RAID 1+0 (or RAID 10) combines disk striping (RAID 0) for performance with disk mirroring (RAID 1) for redundancy. This configuration provides excellent write performance, which is crucial for database log files due to their sequential write-heavy nature, while ensuring data protection against single disk failures in each mirrored pair.

CRAID 1
DRAID 6

Concept tested: RAID levels for database log performance

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

Topics

#RAID levels#RAID 1+0#database performance#redundancy

Community Discussion

No community discussion yet for this question.

Full SG0-001 Practice