Microsoft
70-450 · Question #19
70-450 Question #19: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 instance named Instance1 at the New York central site. Your company has a sales team to fulfill purchase orders for customer requests. The sales team uses portable computers to update data frequently in a local database. When the portable computers connect to the central site, the local database must be synchronized with a database named Sales. You plan to create a replication model to replicate the local database to the Sales database. The replication model must meet the following requirements: - Data conflicts are handled when multiple users update the same data independently. - The sales team cannot update sensitive data such as product price. - The sales team can synchronize data at scheduled times and on demand also. You need to identify the best model to replicate data by using minimum development efforts. What should you do?
Options
- AUse merge replication along with each portable computer that is set up as a subscriber.
- BUse snapshot replication along with each portable computer that is set up as a subscriber.
- CUse transactional replication along with each portable computer that is set up as a publisher.
- DUse SQL Server Integration Services (SSIS) to push data changes and pull updates to the
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.