General Datawarehousing Question: Download Questions PDF
What are the advantages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs?
Answer:
Transaction logs write sequentially and don't need to be read at all. The ideal is to have each on RAID 1/0 because it has much better write performance than RAID 5.
RAID 1 is also better for TX logs and costs less than 1/0 to implement. It has a tad less reliability and performance is a little worse generally speaking.
RAID 5 is best for data generally because of cost and the fact it provides great read capability.
RAID 1 is also better for TX logs and costs less than 1/0 to implement. It has a tad less reliability and performance is a little worse generally speaking.
RAID 5 is best for data generally because of cost and the fact it provides great read capability.
Download General Datawarehousing Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain What type of Indexing mechanism do we need to use for a typical datawarehouse? | What are modeling tools available in the Market? |