MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
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 |
| Answer» C. sys.dm_broker_tasks | |
| 2. |
Which_of_the_utility_is_used_for_reporting_issue_in_Service_Broker_?$ |
| A. | diagnose |
| B. | ssiagnose |
| C. | ssbdiagnose |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 3. |
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 |
| Answer» D. All of the mentioned | |
| 4. |
(SSBS) is a new architecture which allows you to write ____________ message based application. |
| A. | asynchronous |
| B. | decoupled |
| C. | distributed |
| D. | all of the mentioned |
| Answer» E. | |
| 5. |
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 |
| Answer» D. All of the mentioned | |
| 6. |
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 |
| Answer» B. Service definition | |
| 7. |
There are _________ components of the Service broker in SQL Server. |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» C. 4 | |
| 8. |
Service broker was added to SQL Server ___________ |
| A. | 2000 |
| B. | 2005 |
| C. | 2008 |
| D. | 2012 |
| Answer» C. 2008 | |