What should you do?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *