What is the BEST backup strategy for a large database with data supporting online sales?
A.
Weekly full backup with daily incremental backup
B.
Daily full backup
C.
Clustered servers
D.
Mirrored hard disks
Explanation:
Weekly full backup and daily incremental backup is the best backup strategy; it ensures the ability to recover the database and yet reduces the daily backup time requirements. A full backup normally requires a couple of hours, and therefore it can beimpractical to conduct a full backup every day. Clustered servers provide a redundant processing capability, but are not a backup. Mirrored hard disks will not help in case of disaster.
A
Why not Mirrored Hard Disks? It gives synchronous back-up, better over Weekly back-ups
Weekly full backup and daily incremental backup will also not help in case of disaster if stored onsite and there is no indication of the location of backup in this question by the way stupid answer as nobody can afford even a single record lost now a days on ecommerce websites