Set - 4

Question 1 :

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
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.


Question 2 :

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

Answer :

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


Question 3 :

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.
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.


Question 4 :

When creating a full-text index on a BLOB column (image, binary or varbinary) where a file is stored, what happens if an incorrect file prefix is stored in the type column? (For instance: if a word document is stored in the image or a varbinary(MAX) column and the value of the type column is '.pdf'.

Answer :

The row is not full-text indexed and an error message is written to the SQL Server Error Log
The answer is the row is not full-text indexed and an error message is written to the SQL Server Error Log. No columns in the row are full-text indexed and an error message is written to the SQL Server Error Log.


Question 5 :

In SQL Server 2005 Full-Text Search, you set up a replacement set like this:


SS2K5
SQL Server 2005
SQL Server 2K5


A search for "SS2K5" doesn't return results with fields that you know contain "SS2K5". What is wrong?

Answer :

The replacement set does not return results with the search terms, only the specified replacements.