You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all clients run Windows XP Professional.
The Domain.com network contains a database server named Certkiller -DB01 that is running SQL Server 2005, Standard Edition. Certkiller -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?
A.
Create the snapshot in Replication Monitor.
B.
Install and start Replication services on Certkiller -DB01.
C.
Upgrade Certkiller -DB01 to SQL Server 2005, Enterprise Edition.
D.
Open a command prompt window on Certkiller -DB01 and run the snapshot.exe utility.
Explanation:
You cannot create snapshots in SQL Server 2005, Standard Edition as this edition does not ship with the Snapshot Agent and does not support snapshots. Only SQL Server 2005, Enterprise Edition and SQL Server 2005, Developer Edition supports snapshots.
Incorrect Answers:
A, D: You can use Replication Monitor and the snapshot.exe command-line utility to create a snapshot in SQL Server 2005, Enterprise Edition and SQL Server 2005, Developer Edition. However, SQL Server 2005, Standard Edition does not ship with the Snapshot Agent and does not support snapshots.
B: You cannot create snapshots in SQL Server 2005, Standard Edition as this edition does not ship with the Snapshot Agent and does not support snapshots.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: features [SQL Server]