CA_Technologies
CAT-380 · Question #42
CAT-380 Question #42: Real Exam Question with Answer & Explanation
Sign in or unlock CAT-380 to reveal the answer and full explanation for question #42. The question stem and answer options stay visible for context.
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.
Unlock CAT-380 to see the answer
You've previewed enough free CAT-380 questions. Unlock CAT-380 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.