IBM
C2150-200 · Question #6
A customer wants to create daily backups but does not have a large amount of disk space available to maintain transaction logs. Which SQL recovery model should be configured?
The correct answer is B. Simple. See the full explanation below for the reasoning.
Question
A customer wants to create daily backups but does not have a large amount of disk space available to maintain transaction logs. Which SQL recovery model should be configured?
Options
- AFull
- BSimple
- CClosed
- DComplete
How the community answered
(42 responses)- A2% (1)
- B83% (35)
- C5% (2)
- D10% (4)
Community Discussion
No community discussion yet for this question.