You are the database developer for an order-processing application. After a customer places an order, a confirmation message must be sent to the customer.
The following Transact-SQL batch has been run in the database:
ALTER DATABASE NORTHWIND SET ENABLE_BROKER;
CREATE MESSAGE TYPE EmailMessageVALIDATION = NONE;
CREATE CONTRACT EmailContract(EmailMessage SENT BY INITIATOR);
CREATE QUEUE EmailSendQueue;
CREATE QUEUE EMailReceiveQueue;
CREATE SERVICE EmailSendService ON QUEUE EmailSendQueue (EmailContract);
CREATE SERVICE EmailReceiveService ON QUEUE EmailReceiveQueue (EmailContract);
You need to place the message in the EmailSendQueue for the email system to process.
Which Transact-SQL batch should you use?
A. DECLARE@EmailDialog UNIQUEIDENTIFIER,@Message NVARCHAR(128);
BEGIN DIALOG CONVERSATION @EmailDialog
FROM SERVICE EmailSendService
TO SERVICE ‘EmailReceiveService’
ON CONTRACT EmailContractWITH ENCRYPTION = OFF;
SET @Message = N’Dear Sir/Madam. Your order has been received.’;
SEND ON CONVERSATION @EmailDialogMESSAGE TYPE EmailMessage (@Message);
GO
B. DECLARE@EmailDialog UNIQUEIDENTIFIER,@Message NVARCHAR(128);
BEGIN DIALOG @EmailDialog
FROM SERVICE EmailSendService
TO SERVICE ‘EmailReceiveService’
ON CONTRACT EmailContract;
SET @Message = N’Dear Sir/Madam. Your order has been received.’;
SEND ON CONVERSATION @EmailDialog (@Message);
C. DECLARE@EmailDialog UNIQUEIDENTIFIER,@Message NVARCHAR(128);
BEGIN DIALOG @EmailDialog
FROM SERVICE EmailSendService
TO SERVICE EmailReceiveService
ON CONTRACT EmailContract;
SET @Message = N’Dear Sir/Madam. Your order has been received.’;
SEND ON CONVERSATION @EmailDialog
MESSAGE TYPE EmailMessage (@Message);
GO
D. DECLARE@EmailDialog UNIQUEIDENTIFIER,@Message NVARCHAR(128);
BEGIN DIALOG @EmailDialog
FROM SERVICE EmailSendService
TO SERVICE ‘EmailReceiveService’
ON CONTRACT EmailContractWITH LIFETIME = 1000;
SET @Message = N’Dear Sir/Madam. Your order has been received.’;
SEND ON CONVERSATION @EmailDialog
MESSAGE TYPE EmailMessage (@Message);
GO
E. DECLARE@EmailDialog BIGINT,@Message NVARCHAR(128);
BEGIN DIALOG @EmailDialog
TO SERVICE ‘EmailReceiveService’
ON CONTRACT EmailContract;
SET @Message = N’Dear Sir/Madam. Your order has been received.’;
SEND ON CONVERSATION @EmailDialog
MESSAGE TYPE EmailMessage (@Message);
GO
F. DECLARE@EmailDialog BIGINT,@Message NVARCHAR(128);
BEGIN DIALOG @EmailDialog
TO SERVICE EmailReceiveService
FROM SERVICE ‘EmailSendService’
ON CONTRACT EmailContract;
SET @Message = N’Dear Sir/Madam. Your order has been received.’;
SEND ON CONVERSATION @EmailDialog
MESSAGE TYPE EmailMessage (@Message);
GO
G. DECLARE@EmailDialog BIGINT,@Message NVARCHAR(128);
BEGIN DIALOG @EmailDialog
FROM SERVICE EmailSendService
TO SERVICE ‘EmailReceiveService’
ON CONTRACT EmailContract;
SET @Message = N’Dear Sir/Madam. Your order has been received.’;
SEND ON CONVERSATION @EmailDialog
MESSAGE TYPE EmailMessage (@Message);
GO
H. DECLARE@EmailDialog BIGINT,@Message NVARCHAR(128);
BEGIN DIALOG @EmailDialog
TO SERVICE ‘EmailReceiveService’
FROM SERVICE EmailSendService
ON CONTRACT EmailContract;
SET @Message = N’Dear Sir/Madam. Your order has been received.’;
SEND ON CONVERSATION @EmailDialog
MESSAGE TYPE EmailMessage (@Message);
GO
