Set - 2

Question 6 :

You have two Service Broker instances running. One is on SQL1 with the default collation and the other is on SQL2 setup for French collation. Which collation is used for Service Broker messages sent between the instances?

Answer :

Service Broker does not consider the collation, using byte-by-byte matching for names.
Neither collation is used. Service Broker operates in a collation independent method that removes collation information from the messages.

Question 7 :

What does the max full-text crawl range option do?

Answer :

Determines the number of partitions used in an index crawl.
This option helps optimize the full-text indexing process by specifying the number of partitions the SQL Server uses during index crawls.

Question 8 :

Which of the following is not an allocation unit in SQL Server 2005?

Answer :

The three types of allocation units are: IN_ROW_DATA, LOB_DATA, and ROW_OVERFLOW_DATA. Each heap or index has IN_ROW_DATA which holds part of the data. LOB_DATA is used for large object data types and ROW_OVERFLOW_DATA is used for varible length data that causes a row to exceed the 8060 byte limit.

Question 9 :

Which of the following is the best use for a Scalable Shared Database in SQL Server 2005?

Answer :

A reporting database server
A scalable shared database is a feature that allows you to setup read-only database on a separate server for reporting purposes. This database provides an identicle view of your data from another server.

Question 10 :

You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries. It was recommended that you drop the indexes on the table before the load and then rebuild them after the load is complete. Is this something you would do?

Answer :

This does not make sense.
For such a small number of rows, it is unlikely that dropping the indexes will improve the performance of your load. If this were 100,000 rows, then it might make sense.