SQL Server Architecture Question:

Download Job Interview Questions and Answers PDF

Do you know what is RAID and what are different types of RAID configurations?

MS SQL Server Architecture Interview Question
MS SQL Server Architecture Interview Question

Answer:

RAID stands for Redundant Array of Independent Disks. RAID defines data storage schemes to divide and replicate data among various disks so that data reliability and I/O performance can be increased.

The basic configurations of RAID are:

LEVEL 0 : Striped set without parity/Non-Redundant Array
LEVEL 1 : Mirrored set without parity
LEVEL 2 : Redundancy through Hamming code
LEVEL 3 : Striped set with dedicated parity/Bit interleaved parity
LEVEL 4 : Block level parity
LEVEL 5 : Striped set with distributed parity
LEVEL 6 : Striped set with dual distributed Parity

Download MS SQL Server Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What are Page Splits?What is database architecture?