Question 31 : Which of the following makes data available for replication?
1. Article
2. Publisher
3. Distributor
4. Subscription
View Answer   Discuss with Members

Question 32 : Which of the following stored procedure provide replication support for AlwaysOn?
1. sp_validate_replica_publishers
2. sp_validate_hosts_as_publishers
3. sp_validate_replica_hosts_as_publishers
4. all of the mentioned
View Answer   Discuss with Members

Question 33 : Which of the following is disadvantage of replication?
1. Improved performance
2. To move data closer to the user
3. Easy maintenance
4. None of the mentioned
View Answer   Discuss with Members

Question 34 : Replication in SQL Server is used to overcome :
1. Performance problems
2. Availability problems
3. Maintenance problems
4. All of the mentioned
View Answer   Discuss with Members

Question 35 : How many types of replication is provided by SQL Server?
1. 2
2. 3
3. 4
4. 5
View Answer   Discuss with Members

Question 36 : Point out the correct statement :
1. Transactional replication is typically used in server-to-server
2. Transactional replication is typically used in client-to-server
3. Transactional replication is typically used in client-to-client
4. None of the mentioned
5.
View Answer   Discuss with Members

Question 37 : ___________ is a set of technologies for copying and distributing data and database objects from one database to another.
1. Replication
2. Database Mirroring
3. Log Shipping
4. None of the mentioned
View Answer   Discuss with Members

Question 38 : Which of the utility is used for reporting issue in Service Broker ?
1. diagnose
2. ssiagnose
3. ssbdiagnose
4. None of the mentioned
View Answer   Discuss with Members

Question 39 : Which of the following is a Service Broker Related Dynamic Management View ?
1. sys.dm_broker_activated
2. sys.dm_broker_activated_tasks
3. sys.dm_broker_tasks
4. dm_broker_activated_tasks
View Answer   Discuss with Members

Question 40 : Which of the following change was introduced in SQL Server 2012 related to Service Broker?
1. Less support for Service Broker
2. Queues do not expose the message enqueued time
3. Messages can be sent to multiple target services (multicast)
4. All of the mentioned
View Answer   Discuss with Members