Base de datos

Solo disponible en BuenasTareas
  • Páginas : 2 (491 palabras )
  • Descarga(s) : 0
  • Publicado : 5 de diciembre de 2011
Leer documento completo
Vista previa del texto
Module 1.- Overview of the Service Broker
1.- Which Service Broker object stores the messages that are sent?
Queue
2.- What data type is used to store the messages within a queue?Varbinary(max).
3.- Which type of security architecture provides a secure, authenticated connection between two servers?
Transport Security.
Module 2.- Create a Service Broker Solution
1.- You are adatabase developer for Adventure Works. You are defining message types within a Service Broker solution. You want to ensure that the message that are sent conform to an XML schema. Which validationparameter should you use
VALID_XML
2.- You are a database developer for Adventure Works. You are defining a contract within a Service Broker solution. You want to ensure that the message can be sentby the initiator and the target. Which SENT BY clause should you use?
SENT BY ANY.
3.- You are creating a Service Broker solution. You want to ensure that a maximum of 5 concurrent processes arerunning when processing messages within a queue. Which clause should you define in the CREATE QUEUE statement?
MAX_QUEUE_READER.
Module 3.- Using a Service Broker Solution
1.- When sending andreceiving messages in a Service Broker solution, the @dialog_handle variable is used to identify the conversationID. True or False?
True
2.- How do you limit the number of messages that are processwhen using the RECEIVE clause?
By using the TOP n Clause.

Español
Módulo 1.-visión general de la corredora de servicio
1.- ¿Qué objeto de Service Broker almacena los mensajes que se envían?
Cola2.- ¿Qué tipo de datos se utiliza para almacenar los mensajes en una cola?
Varbinary (Max).
3.- ¿Qué tipo de arquitectura de seguridad proporciona una conexión segura entre dos servidoresautenticada?
Seguridad de transporte.
Módulo 2.-crear una solución de Service Broker
1.- Usted es un desarrollador de base de datos de Adventure Works. Definir los tipos de mensajes dentro de una solución...
tracking img