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.)

Question

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.)

Accepted Answer

A. Place the database in single-user mode before deploying the changes. C. Specify the full recovery model for the database.

Answer

B. Specify the simple recovery model for the database.

Answer

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

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…

Question

Options

How the community answered

Community Discussion