You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod1.
One of Domain.com policies is that the database should not be changed too often on business days.
Thus you have received instructions from management to
create a read-only copy of CK_Prod1 for reporting purposes at the start of each business day.
What should you do?
A.
You should consider using read-only limitations on the Transactions Log.
B.
You should consider using a stored procedure.
C.
You should consider using the database snapshots.
D.
You should consider using the schema-bound views and XML schema.