|
Related Questions |
View Answer |
|
What does a report model provide in SQL Server 2005 Reporting Services?
|
View Answer
|
|
Where are Notification Services event messages logged in SQL Server 2005?
|
View Answer
|
|
In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?
|
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 Reporting Services 2005, how is Report Builder typically deployed to end users?
|
View Answer
|
|
What does the CREATE SERVICE statement do in SQL Server 2005?
|
View Answer
|
|
Before a user can build reports using Report Builder in Reporting Services 2005, what steps must be done first?
|
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
|
|
What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?
|
View Answer
|
|
Setting the TRUSTWORTHY database property to ON allows you to execute the which context of the database?
|
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
|
|
What does the DEALLOCATE statement do in SQL Server 2005?
|
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 algorithm is used to encrypt the Database Master Key when it is created?
|
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
|
|
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
|
|
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
|
|
What choices show the three report formats supported by 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 is the formatting options for Boolean columns on report builder?
|
View Answer
|