You are a professional level SQL Sever 2008 Database Administrator. A SQL Server 2008 instance at the New York central site is managed by you, and it is called Ins01. There is a sales team in your company, and their task is to finish purchase orders for customer requests. The sales team updates data regularly in a local database by utilizing their portable computers. When the central site is connected by portable computers, a database named Sales will be synchronized with the local database. A duplication model will be created to duplicate the local database to the Sales database. The requirements listed below should be satisfied by the duplication model:

First, when the same data is updated by multiple users independently,

there should be no data conflicts.

Secondly, sensitive data such as product price cannot be updated by

the sales team.

Thirdly, the data should be synchronized by the sales team not only

at scheduled times but also on demand. The best model should be identified to have data duplicated, and you should be reduced the development efforts to the least. Which action will you perform?

Question

You are a professional level SQL Sever 2008 Database Administrator. A SQL Server 2008 instance at the New York central site is managed by you, and it is called Ins01. There is a sales team in your company, and their task is to finish purchase orders for customer requests. The sales team updates data regularly in a local database by utilizing their portable computers. When the central site is connected by portable computers, a database named Sales will be synchronized with the local database. A duplication model will be created to duplicate the local database to the Sales database. The requirements listed below should be satisfied by the duplication model:

First, when the same data is updated by multiple users independently,

there should be no data conflicts.

Secondly, sensitive data such as product price cannot be updated by

the sales team.

Thirdly, the data should be synchronized by the sales team not only

at scheduled times but also on demand. The best model should be identified to have data duplicated, and you should be reduced the development efforts to the least. Which action will you perform?

Accepted Answer

C. You should utilize merge duplication along with each portable computer that is set up as a

Answer

A. You should utilize snapshot duplication along with each portable computer that is set up as

Answer

B. You should utilize transactional duplication along with each portable computer that is set up

Answer

D. You should utilize SQL Server Integration Services (SSIS) to promote the date modification

You are a professional level SQL Sever 2008 Database Administrator. A SQL Server 2008 instance at the New York central site is managed by you, and it is called Ins01. There is a sales team in your…

Question

Options

How the community answered

Explanation

Topics

Community Discussion