CA_Technologies
CAT-380 · Question #19
If your SQL Server database activity is high for a large database using the simple recovery model, what is the recommended backup strategy?
The correct answer is A. Full backups once a week and differential backups twice a day. See the full explanation below for the reasoning.
Question
If your SQL Server database activity is high for a large database using the simple recovery model, what is the recommended backup strategy?
Options
- AFull backups once a week and differential backups twice a day
- BFull backups once a week, differential backups once a day, and transaction log backups every
- CFull backups twice per week, differential backups twice a day, and transaction log backups
- DFull backups once a week, differential backups once a day, and transaction log backups every
How the community answered
(48 responses)- A83% (40)
- B2% (1)
- C10% (5)
- D4% (2)
Community Discussion
No community discussion yet for this question.