(Continued from previous part...)

What does the CREATE SERVICE statement do in SQL Server 2005?

Answer
This statement is used to setup new tasks for Service Broker queues.
Explanation
This statement is ue to create a new Service Broker service that is a set of tasks that are run on messages.

You have a SQL Server 2005 sales database experiencing performance problems because of heavy I/O activity. You decide to create a snapshot of this database every hour, stored on a separate physical disk array and use that for reporting queries. However the queries still seem slow immediately after snapshot creation. Why?

Answer
The snapshot still queries the original database.
Explanation
The snapshot of the production database will only reduce I/O for changed pages. Any data that has not been changed will be read from the source database, which is in this case is experiencing heavy I/O itself.

In Reporting Services 2005, how is Report Builder typically deployed to end users?

Answer
One click deployment launched from a menu on the Report Manager home page
Explanation
One click deployment is fast and easy, users click the menu on the Report Manager page. It is not a web application, but rather a .Net Winform application.

If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?

Native Web Services require what type of endpoint in SQL Server 2005?

Answer
HTTP endpoints
Explanation
Native XML Web Services in SQL Server 2005 require HTTP endpoints to communicate with clients.

If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?

Answer
It is still sent to the distributor and executed on the subscriber.
Explanation
A transaction that fails in the publication database is still sent to the distributor and subscriber. YUou can trap the error, but you would need to trap it on the subscriber as well.

(Continued on next part...)