(Continued from previous part...)

In Full-Text Search, what is word breaking?

Answer
Determining word boundaries.
Explanation
Word breaking involves finding the boundaries of a word. This is different for different languages and SQL Server 2005 includes word breakers for 23 languanges.

Can you call Notification Services APIs from unmanaged code?

Answer
Yes, but only for simple subscriptions.
Explanation
Notification Services can be called from unmanaged code through a COM interface for simple subscriptions only. Condition based subscriptions are not supported through COM interop.

Which of the following is true about the Raw File Source in SQL Server 2005 Integration Services?

Answer
It does not support an error output.
Explanation
The raw file source has only one output and does not support an error output. It also reads faster than other data sources becuase it has no parsing or translation and does not use a conneciton manager.

You wish to configure event logging for your SQL Server 2005 Notification Services instance. Where would you make this change?

Answer
Edit the nsservice.exe.config file in the C:\Program Files\Microsoft SQL Server\90\NotificationServices\n.n.nnn\bin folder.
Explanation
Event logging and most Notification Services configuration require editing an XML file. In this case, the NSservice.exe.config file is edited to set the appropriate editing level.

Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?

Answer
It supports BLOB object data.
Explanation
The Raw File Destination connection does not use a connection manager, supports NULL data, and only has one input. It also does not support BLOB data or have an error output.

(Continued on next part...)