Skillset can help you prepare! Sign up for your free Skillset account and take the first steps towards your certification.
Which of the following is the most effective backup plan for a large production database used for online sales?
Clustered servers
Daily full backup
Weekly full backup with daily incremental backup
Mirrored hard disks
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 be impractical 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. <== I disagree, the most efficient is definitely mirrored hard disks, for which there is no data loss. Especially if online sales are involved, losing some data is critical.
** But a mirror is not a backup. If a server crash or virus renders the data corrupt or lost, both, and or all copies are equally useless. That's when the distinction becomes absolutely clear.
Train with Skillset and pass your certification exam. Faster. Guaranteed.
Study thousands of practice questions that organized by skills and ranked by difficulty.
Create a tailored training plan based on the knowledge you already possess.
Know when you’re ready for the high-stakes exam. Have the confidence that you will pass on your first attempt.