Service Broker Questions and Answers

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Service Broker”.

1. Service broker was added to SQL Server ___________
a) 2000
b) 2005
c) 2008
d) 2012
View Answer

Answer: b
Explanation: Service Broker in Microsoft SQL Server 2005 is a new technology that provides messaging and queuing functions between instances.

2. Point out the correct statement.
a) Loosely coupled applications are supported by the Service broker
b) Each Service Broker conversation is considered to be a dialog where only participants are involved
c) Service broker find applications when a single SQL server instance is used
d) None of the mentioned
View Answer

Answer: a
Explanation: Programs that exchange messages independently) are supported by the Service broker.

3. There are _________ components of the Service broker in SQL Server.
a) 2
b) 3
c) 4
d) 5
View Answer

Answer: b
Explanation: The three components of the Service broker are as follows: conversation components, service definition components and networking and security components.

4. Which of the following service broker component defines the infrastructure used for exchanging messages between instances?
a) Conversation
b) Service definition
c) Security
d) All of the mentioned
View Answer

Answer: a
Explanation: Networking and security components defines the infrastructure used for exchanging messages between instances.

5. Point out the wrong statement.
a) The developers can design applications from independent components known as “services”
b) The maintenance of the Service Broker is difficult
c) Maintenance of Service Broker is a part of the routine database
d) None of the mentioned
View Answer

Answer: b
Explanation: The maintenance of Service Broker is easy because it forms a part of the Database Engine.

Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

6. Service Broker also provides security by preventing __________ access from networks and by message encryption.
a) Authorized
b) Read
c) Unauthorized
d) All of the mentioned
View Answer

Answer: c
Explanation: Service broker is essential component for security of database.

7. (SSBS) is a new architecture which allows you to write ____________ message based application.
a) asynchronous
b) decoupled
c) distributed
d) all of the mentioned
View Answer

Answer: d
Explanation: SQL Server Service Broker (SSBS), introduced with SQL Server 2005 allows you to write queuing/message based applications within the database itself.

8. Which of the following change was introduced in SQL Server 2012 related to Service Broker?
a) Less support for Service Broker
b) Queues do not expose the message enqueued time
c) Messages can be sent to multiple target services (multicast)
d) All of the mentioned
View Answer

Answer: c
Explanation: Queues have a new column, message_enqueue_time, that shows how long a message has been in the queue.

9. Which of the following is a Service Broker Related Dynamic Management View?
a) sys.dm_broker_activated
b) sys.dm_broker_activated_tasks
c) sys.dm_broker_tasks
d) dm_broker_activated_tasks
View Answer

Answer: b
Explanation: sys.dm_broker_activated_tasks returns a row for each stored procedure activated by Service Broker.

10. Which of the utility is used for reporting the issue in Service Broker?
a) diagnose
b) ssiagnose
c) ssbdiagnose
d) none of the mentioned
View Answer

Answer: c
Explanation: The ssbdiagnose utility reports issues in Service Broker conversations or the configuration of Service Broker services.

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.

« Prev - SQL Server Questions and Answers – LINQ – 2

» Next - SQL Server Questions and Answers – Replication

Related Posts:

Recommended Articles: