(Continued from previous part...)

What is the Service Broker Identifier

Answer
A GUID that identifies the database on which Service Broker is running.

Explanation
Each database has a Service Broker identifier. This is a GUID in the service_broker_GUID column that identifies the databases on which Service Broker is running. It ensure that messages are delivered to the right database.

You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?

Answer
Use the select * from OPENROWSET(BULK...) command.
Explanation
SQL Server 2005 includes a new option with the OPENROWSET command for getting large amounts of data from an OLEDB data source. It is the BULK option and works similar to the BULK INSERT command.

How are modified extents tracked in SQL Server 2005 (which internal structures)?

Answer
Differential Change Map and Bulk Change Map

Explanation
There are two internal structures that track extents modified by bulk copy operations or that have changed since the last full backup. They are the Differential Changed Map (DCM) and the Bulk Changed Map (BCM).

What does this return?
select (1324 & 1024)

Answer
1024

Explanation
This performs a bitwise AND operation between the two integers and sets the result to this. Since 1024 is a single set bit in it's value, if the corresponding bit is set to 1, then in the result the bit is set to 1. In this case, since no other bits would generate two 1s, the result is equivalevt to the mask, or 1024.

What does the Log Reader agent in SQL Server 2005 replication do?

Answer
This agent reads the publisher log for transactions to send to the distributor.

Explanation
This agent is tasked with reading the transaction log in transactional replication and moving those transactions that need to be replicated to the distributor.

You are performing an update of your Scalable Shared Database and receive note that two reports run at the same time received different results. These reports were both run during your update. What type of update did you perform?

Answer
A rolling update

Explanation
When performing a rolling update, doing the detach and attach on each server as opposed to detaching from all then attaching to all, it is possible that different reporting servers will display different results.

What does a @@fetch_status of -2 mean in SQL Server 2005?

Answer
The row being fetched is missing.

Explanation
This means that the row that was being fetched from the cursor is missing.

(Continued on next part...)