|
Question |
Rating |
View Answer |
|
What is not true about the Raw File Destination connection in SQL Server 2005 Integration Services? |
|
View Answer |
|
What message types exist in SQL Server 2005 Service Broker? |
|
View Answer |
|
What does the CEILING() function do? |
|
View Answer |
|
What is a dialog conversation in the SQL Server 2005 Service Broker? |
|
View Answer |
|
What is row versioning in SQL Server 2005? |
|
View Answer |
|
Which columns can be indexed with SQL Server 2005 Full-Text Search? |
|
View Answer |
|
When starting SQL Server 2005 from the command line, what does the -h switch do? |
|
View Answer |
|
What does the ERROR_PROCEDURE() function return? |
|
View Answer |
|
Credentials in SQL Server 2005 are used to access what? |
|
View Answer |
|
What does @@options return? |
|
View Answer |
|
To recover an instance of Notification Services in 2005 on another server, what information would you need? |
|
View Answer |
|
What type of connectivity does the readpipe/makepipe utility test? |
|
View Answer |
|
You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this? |
|
View Answer |
|
What is the scope of the control permission in SQL Server 2005? |
|
View Answer |
|
In SSIS, what is the difference between output columns and external columns? |
|
View Answer |
|
In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use? |
|
View Answer |
|
You are designing a new server that will hold 2 instances of SQL Server 2005 in a consolidation project. One of the existing servers has 4GB of RAM and the other has 2GB. You do not want either instance to feel memory pressure, so you specify a new server with 8GB of RAM. What else should you configure on these instances? |
|
View Answer |
|
Which of the following services is instance-aware? |
|
View Answer |
|
What does the term ACID refer to? |
|
View Answer |
|
In building a PDF report in Reporting Services 2005, images that are originally stored in jpg format are rendered in jpg format. What format are images rendered in if they were stored originally in another format? |
|
View Answer |