|
Related Questions |
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
|
|
What does this return? select (1324 & 1024)
|
View Answer
|
|
How are modified extents tracked in SQL Server 2005 (which internal structures)?
|
View Answer
|
|
You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
|
View Answer
|
|
What is the Service Broker Identifier ?
|
View Answer
|