What are the advantages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs?
Submitted by: AdministratorTransaction 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online General Datawarehousing Job Interview Questions And Answers
Top General Datawarehousing Questions
| ☺ | What is SCD1 , SCD2 , SCD3? |
| ☺ | What is ODS? |
| ☺ | Explain piconet? |
| ☺ | Explain the Difference between OLTP and OLAP? |
| ☺ | Explain What are the Different methods of loading Dimension tables? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
