nerdexam
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)
  • A
    83% (40)
  • B
    2% (1)
  • C
    10% (5)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full CAT-380 Practice