Question 11 :
How is Thesaurus data configured in SQL Server 2005 Full-Text Search?
An XML file in the file system named tsxxx.xml where xxx is a code.
The thesaurus file for SQL Server 2005 is an XML file containing data and stored in SQL_Server_install_path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\ directory. There is one for each language and it is named tsxxx_.xml, where xxx is the three letter language code.
Question 12 :
What does a report model provide in SQL Server 2005 Reporting Services?
A report model provides familiar business names for database tables and fields
A Report model provides business names and terms for database fields and tables. It allows for predefined relationships between tables as well as grouping items together logically.
Question 13 :
What can tracer tokens measure in SQL Server 2005 transactional replication?
1 and 3
Tracer tokens measure two things. One is the amount of time elapsed between a command being committed on the publisher and being written to the distribution database. The other is from the writing to the distribution database and being committed to a subscriber. This allows you to determine the latencies for transactions moving through your replication topology.
Question 14 :
You want to script the execution of an Integration Services package from the command line for use from a Unix scheduler. What utility would you use?
The dtexec.exe utility is used to configure and execute Integration Services packages from the command line.
Question 15 :
What does the sqlwb utility do?
Opens SQL Server 2005 Management Studio.
sqlwb.exe actually opens Management Studio and can be configured to optionally open a solution, project, or script file when it starts.