Set - 4

Question 11 :

How is Thesaurus data configured in SQL Server 2005 Full-Text Search?

Answer :

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?

Answer :

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?

Answer :

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?

Answer :

dtexec.exe
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?

Answer :

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.