|
Question |
Rating |
View Answer |
|
Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report? |
|
View Answer |
|
You have noticed in both your SQL Server 2000 and 2005 instances that when a database grows in SQL Server, there is a delay in the database response. Why is that? |
|
View Answer |
|
Out of the box Report Builder supports two report level fields that can be shown on a report. Which has those two options? |
|
View Answer |
|
What algorithm is used to encrypt the Database Master Key when it is created? |
|
View Answer |
|
You are setting up a native XML web service on your SQL Server 2005 to respond to inventory requests. How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided? |
|
View Answer |
|
What does the DEALLOCATE statement do in SQL Server 2005? |
|
View Answer |
|
Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control? |
|
View Answer |
|
Setting the TRUSTWORTHY database property to ON allows you to execute the which context of the database? |
|
View Answer |
|
What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005? |
|
View Answer |
|
In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean? |
|
View Answer |
|
Before a user can build reports using Report Builder in Reporting Services 2005, what steps must be done first? |
|
View Answer |
|
What does the CREATE SERVICE statement do in SQL Server 2005? |
|
View Answer |
|
In Reporting Services 2005, how is Report Builder typically deployed to end users? |
|
View Answer |
|
If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher? |
|
View Answer |
|
In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set? |
|
View Answer |
|
Where are Notification Services event messages logged in SQL Server 2005? |
|
View Answer |
|
What does a report model provide in SQL Server 2005 Reporting Services? |
|
View Answer |
|
How can you determine which Service Broker ports are being used on your server? |
|
View Answer |
|
Can you call Notification Services APIs from unmanaged code? |
|
View Answer |
|
For configuring event logging for your SQL Server 2005 Notification Services instance. Where would you make this change? |
|
View Answer |