• Description:Microsoft® SQL Server 2005 - Implementation
• Passing Score:0%
• Practice Test - Number of questions:98 questions
• Simulation Test - Number of questions:98 questions
• Simulation Test Duration:120 minutes
• Has explanations:Yes

You work as the database administrator at IT department .com. The IT department .com network consists of a single Active Directory domain named IT department .com. All servers on the IT department .com network run Windows Server 2003 and all clients run Windows XP Professional. The IT department .com network contains a database server named IT department -DB01 that is running SQL Server 2005, Standard Edition. IT department -DB01 contains a database named CK_Sales which is used to store data for the Sales department. Members of the Sales department usually access CK_Sales at the start of the day. You want to improve performance of the CK_Sales database by implementing database snapshots. However, the Snapshot Agent is not available in SQL Server Management Studio. What should you do?

Answer(s)

1. Create the snapshot in Replication Monitor.
2. Install and start Replication services on IT department -DB01.
3. Upgrade IT department -DB01 to SQL Server 2005, Enterprise Edition.
4. Open a command prompt window on IT department -DB01 and run the snapshot.exeutility.

Upgrade IT department -DB01 to SQL Server 2005, Enterprise Edition.