tailieunhanh - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P114

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P114: 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. | Service Broker Chapter 12 547 Exam Objectives Frequently Asked Questions Q What is the difference between asynchronous and synchronous processing A Synchronous processing is when the client is waiting for a response asynchronous processing is done after the client has stopped waiting for a response. An example of a synchronous process would be when a client application executes a normal stored procedure. Q Are routes required when using SQL SERVICE BROKER A No. Routes are needed only when you are sending SQL SERVICE BROKER messages from one database to another. They are not required if the source and final destinations are in the same database. Q How can I add another Message Type to a contract A There is no direct way to add a Message Type to a contract. You have to remove the contract and re-create it which requires removing the contract from all services to which it is bound and then binding the new contract to the services before you can begin sending messages against the new Message Type. Q What is the easiest VALIDATION setting to use in the Message Type definition A The VALIDATION setting NONE is the easiest to use since there are no requirements for the body of the message. Q In what data type is the message body sent A Message data is sent in the varbinary max data type. You can use the CAST function to convert the data back to the expected data type. Q Does each database have its own Endpoint A Endpoints are instance-wide not database-wide. Each instance can have only a single SQL SERVICE BROKER Endpoint. 548 Chapter 12 Service Broker Self Test 1. You are working with a developer to design a message processing system. SQL Server SERVICE BROKER has been selected as the Message Queuing system. You are tasked with designing a solution that will allow for the fastest processing of messages while impacting the system with the lowest possible impact. You are expecting only a few messages to be received per hour but these messages should be processed as quickly