Which two actions should you recommend?

You are designing updates to an existing Windows Presentation Foundation (WPF)
application that connects to a Microsoft SQL Server 2008 database. The application
updates will require updates to the database. You have the following requirements: Prevent
data loss. Recover the database if the database update fails. You need to recommend a
database deployment strategy. Which two actions should you recommend? (Each correct
answer presents part of the solution. Choose two.)

You are designing updates to an existing Windows Presentation Foundation (WPF)
application that connects to a Microsoft SQL Server 2008 database. The application
updates will require updates to the database. You have the following requirements: Prevent
data loss. Recover the database if the database update fails. You need to recommend a
database deployment strategy. Which two actions should you recommend? (Each correct
answer presents part of the solution. Choose two.)

A.
Place the database in single-user mode before deploying the changes.

B.
Specify the simple recovery model for the database.

C.
Specify the full recovery model for the database.

D.
Place the database in restricted user mode before deploying the changes.



Leave a Reply 0

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