YOU ARE WORKING IN AN ORGANIZATION WHERE THERE ARE RETAIL SHOPS IN...

5. You are working in an organization where there are retail shops in several

locations. Each location is running a SQL Server database and the end of each

day there is a requirement to transfer a subset of data from all locations to the

main server at the head office. What technology can you use to implement this

scenario easily?

A. Linked Server

B. Service Broker

C. Transactional Replication

D. SQL Server Integration Services (SSIS)