You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You administer a SQL Server 2005 computer named SQL01. Two user databases are contained in SQL01. The publisher database is also contained in SQL01 for a transactional replication publication. A full backup is made of all databases nightly. For both user databases, transaction log backups are made twice each day. The company has configured SQL01 to use SQL Server and Windows authentication. Client applications use SQL Server login accounts to connect. Since a complete failure occurs on the disk subsystem on SQL01, you replace the failed hardware; reinstall Microsoft Windows Server 2003 and SQL Server 2005. The company requires that SQL01 is operating normally as quickly as possible and with a minimum loss of data. Hence you have to make sure of this. Your must make client applications be able to access the user databases as soon as those databases are restored. What action should you perform first?

• A. First only the two user databases should be restored.
• B. First the transactional replication publication should be re-created.
• C. First all of the system databases should be restored.
• D. First only the publisher database should be restored.

A most proper archiving strategy for the SalesData.Orders table in the Sales database should be identified. The archiving strategy should be implemented with the least amount of effect on performance. Which action should be performed?

• A. First, the Sales database should be backed up to tape every three months, and then a DELETE statement should be utilized to migrate archived data from the SalesData.Orders table.
• B. First, a database snapshot of the Sales database should be created every three months, and then a DELETE statement should be utilized to remove archived data from the SalesData.Orders table.
• C. First, a table named ArchivedData.Orders should be created. Second, the SalesData.Orders table and its indexes should be partitioned. At last, MERGE, SPLIT, and SWITCH functions should be utilized every three months to remove old order data into ArchivedData.Orders.
• D. First, a table named ArchivedData.Orders should be created. Second, an INSERT statement will be utilized to copy data from the SalesData.Orders table into ArchivedData.Orders every three months. At last a DELETE statement should be utilized to remove archived data from SalesData.Orders.

DRAG DROP
According to the company requirement, the backup schedule should be designed for the customer database.
Which action should be performed to achieve the goal? (Drag the proper backup type to the right location in the answer area.)

According to the company requirements, the list of expected services for SQLCLUST should be reviews and any nonessential services should be disabled. From the following two services, which one should be disabled? (Choose more than one)

• A. Cluster service should be disabled.
• B. Server service should be disabled.
• C. Messenger service should be disabled.
• D. SQL Server Agent service should be disabled.
• E. World Wide Web Publishing service should be disabled.