|
Related Questions |
View Answer |
|
When discussing image support in Report Builder, which of the following is the most accurate statement?
|
View Answer
|
|
True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
|
View Answer
|
|
If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?
|
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
|
|
True or false, Report Builder supports user defined run time parameters?
|
View Answer
|
|
Which of the following statements best describes the filter capabilities of Report Builder?
|
View Answer
|
|
What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005?
|
View Answer
|
|
How can SQL Server Agent Mail send messages in SQL Server 2005?
|
View Answer
|
|
You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries. It was recommended that you drop the indexes on the table before the load and then rebuild them after the load is complete. Is this something you would do?
|
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
|
|
What does the max full-text crawl range option 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
|
|
You have an old database that needs to run in compatibility mode 65 on your SQL Server 2005 server. Which framework would you use to manage this database programmatically?
|
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
|
|
What is the cost threshhold for parallelism in SQL Server 2005?
|
View Answer
|
|
You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?
|
View Answer
|
|
What does a @@fetch_status of -2 mean in SQL Server 2005?
|
View Answer
|
|
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?
|
View Answer
|
|
What does the Log Reader agent in SQL Server 2005 replication do?
|
View Answer
|