|
Question |
Rating |
View Answer |
|
How does a differential backup know which extents have changed so that it can be very quickly run? |
|
View Answer |
|
What does the Queue Reader Agent do in SQL Server 2005 replication? |
|
View Answer |
|
What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL? |
|
View Answer |
|
The Sort component in SQL Server 2005 Integration Services is what type of component? |
|
View Answer |
|
If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean? |
|
View Answer |
|
Where does Profiler store its temporary data in SQL Server 2005? |
|
View Answer |
|
What is the Service Broker Identifier ? |
|
View Answer |
|
What does the Log Reader agent in SQL Server 2005 replication do? |
|
View Answer |
|
What does a @@fetch_status of -2 mean in SQL Server 2005? |
|
View Answer |
|
What is the cost threshhold for parallelism in SQL Server 2005? |
|
View Answer |
|
You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do? |
|
View Answer |
|
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? |
|
View Answer |
|
Which of the following is not an allocation unit in SQL Server 2005? |
|
View Answer |
|
Which of the following is the best use for a Scalable Shared Database in SQL Server 2005? |
|
View Answer |
|
How can SQL Server Agent Mail send messages in SQL Server 2005? |
|
View Answer |
|
Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report? |
|
View Answer |
|
What is image support in Report Builder? |
|
View Answer |
|
What is the formatting options for Boolean columns on report builder? |
|
View Answer |
|
What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting? |
|
View Answer |
|
What choices show the three report formats supported by Report Builder ? |
|
View Answer |