CA_Technologies
CAT-380 · Question #42
You are configuring a SQL Server database restore job. You want the restore operation to roll back any uncommitted transactions. Which Recovery Completion State option should you use?
The correct answer is C. Leave database operational. No additional transaction logs can be restored. See the full explanation below for the reasoning.
Question
You are configuring a SQL Server database restore job. You want the restore operation to roll back any uncommitted transactions. Which Recovery Completion State option should you use?
Options
- ALeave torn page repairs offline.
- BLeave database read-only and able to restore additional transaction logs.
- CLeave database operational. No additional transaction logs can be restored.
- DLeave database non-operational, but able to restore additional transaction logs.
How the community answered
(28 responses)- A7% (2)
- B14% (4)
- C75% (21)
- D4% (1)
Community Discussion
No community discussion yet for this question.