|
Related Questions |
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
|
|
What is image support in Report Builder?
|
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
|
|
How can SQL Server Agent Mail send messages 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
|
|
Which of the following is not an allocation unit in SQL Server 2005?
|
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
|
|
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
|