Home » Microsoft » 70-518 » 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.)
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.
Correct Answer: AC
Explanation/Reference:
In a complete database restore, the goal is to restore the whole database. The whole database is offline for the duration of the restore. Before any part of the database can come online, all data is recovered to a consistent point in which all parts of the database are at the same point in time and no uncommitted transactions exist.
Book Pag. 242:
single-user mode:
SINGLE-USER
Besides security, you might also run into multiuser conflicts when updating an existing database.
For example, if your database update script adds a column to a table and another user currently has a row locked for updating, your deployment script will not be able to continue.
You can work around this problem by disconnecting other users during the upgrade process and switching the database to single-user mode.
Restricted user mode:
RESTRICTED_USER provides for only members of the db_owner fixed database role, dbcreator and sysadmin fixed server roles to connect to the database in one or more connections: