Set - 1

Question 21 :

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.
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.

Question 22 :

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

Answer :

Differential Change Map and Bulk Change Map
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).

Question 23 :

What does this return?

Answer :

select (1324 & 1024)

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.

Question 24 :

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.
This agent is tasked with reading the transaction log in transactional replication and moving those transactions that need to be replicated to the distributor.

Question 25 :

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
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.