The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P162: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 110 Appendix Self Test Appendix Making either of these changes will not stop the activated stored procedures from continuing to process. These settings simply stop any new instances of the activated stored procedures from being started. If you attempt to change the PROCEDURE_NAME setting to an invalid procedure name the ALTER QUEUE command will fail with an error message because only valid procedure names can be used. 16. You are creating new Service Broker objects for a new SQL Service Broker application. The IT department coding standards require that when contracts are defined you must specify the message type used for the source and destination. You are creating your new services and are defining your message types. Which code block is the correct code block to use A. CREATE CONTRACT YourContract AUTHORIZATION dbo SourceMessageType SENT BY ANY DestinationMessageType SENT BY ANY B. CREATE CONTRACT YourContract AUTHORIZATION dbo SourceMessageType SENT BY INITIATOR DestinationMessageType SENT BY ANY C. CREATE CONTRACT YourContract AUTHORIZATION dbo SourceMessageType SENT BY INITIATOR DestinationMessageType SEND BY TARGET Answer C is the correct solution. Although answers A and B will correctly create the contract those two code samples do not meet the IT department coding standards which require that contracts are defined with specific definitions so that the message type can be used by only one side of the application. 17. You are seeing performance problems on your SQL Server Service Broker application. Messages are taking too long to be processed by the activated stored procedure. The stored procedure itself is already fully optimized. What can you do in order to decrease the amount of time it takes to process messages with the least amount of effort A. Increase the number of parallel processes that are run automatically by changing the MAX_QUEUE_READERS value via the ALTER QUEUE command. B. Increase the number of parallel processes that are run automatically .
