You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. CK_Prod database does execute the logged operations.
You have received instructions to ensure that the database can be recovered to a specific point in time.
What should you do?
A.
You should consider ensuring that CK_Prod uses the full recovery model.
B.
You should consider ensuring that CK_Prod uses the half recovery model.
C.
You should consider ensuring that CK_Prod uses the Transactions Log.
D.
You should consider ensuring that CK_Prod uses the store procedure.