Answers in C#

Generator GS1 - 12 in C# Answers

1. Correct Answer: C A. Incorrect: All databases need to be readable and writable, which is not pos sible with Database Mirroring. B. Incorrect: Transactional replication in a central publisher configuration has all writes going to a single machine, which does not meet capacity requirements. C. Correct: Peer-to-peer replication enables all servers to be readable and writ able if desired, meets the uptime requirements, and enables more than two servers to participate in sending changes between them. D. Incorrect: The queued updating subscriber configuration does enable all changes to be batched at a subscriber, but the potentially high latency and the fact that all servers have to replicate their data with each other rules out this option for the specific business requirements stated.

1. Correct Answer: F A. Incorrect: See explanation for correct choice. B. Incorrect: See explanation for correct choice. C. Incorrect: See explanation for correct choice. D. Incorrect: See explanation for correct choice. E. Incorrect: See explanation for correct choice. F. Correct: The central office owns the portion of the data related to the deliv ery order and should always have the master copy of the data. The messen gers are delivering the packages, so any information related to receipt/ delivery is owned by each messenger. There are conflicting requirements for data ownership between the portions of data, so you need at least two publications because conflict detection cannot be dynamically chosen for each synchronization cycle. The publications should all be created at the central office for management. Because the central office owns the delivery order information, the central office should always win in a conflict. Because the messenger owns the delivery/receipt information, the messen ger should always win in a conflict. Therefore, this configuration meets all these requirements.

1. Correct Answer: D A. Incorrect: If transactional replication were configured with the Immediate Updating Subscriber option, changes could not be issued unless the pub lisher were available. B. Incorrect: Transactional replication in a bi-directional configuration does not work if data conflicts can occur. C. Incorrect: Transactional replication with queued updating subscribers could enable messengers to continue processing changes, but they would not be able to receive new delivery orders if a failover to the subscriber were to occur. D. Correct: Merge replication enables messengers to continue processing receipt/delivery information while disconnected from the central office. With merge replication, the messengers can take advantage of the alternate publisher option and continue receiving new delivery orders from a differ ent server that is also participating in merge replication. 2. Correct Answers: B and C A. Incorrect: Because transactional replication with queued updating sub scribers has been configured, the identity property will already exist on the appropriate columns in tables on the subscriber. B. Correct: You must verify that all appropriate permissions are set. C. Correct: You must verify that the current version of all objects exists in the subscriber as well as ensure that any instance-level objects needed by the application have been created. D. Incorrect: SQL Server does not need to be restarted, but you do need to change the connection string for the application and then reconnect.

A. Incorrect: Although transactional replication with queued updating sub scribers enables changes to be made at both locations and can arbitrate data conflicts, it does not provide the flexibility that merge replication can. B. Incorrect: Log shipping does not allow changes to be made at both the pri mary and secondary. C. Correct: Merge replication enables changes at both the publisher and sub scriber while also allowing advanced conflict resolution that will enable the conflicting changes to the order quantity to be averaged allowing a better reflection of the actual inventory on hand. D. Incorrect: Database Mirroring does not allow changes to occur on the mir ror database. 2. Correct Answer: A A. Correct: Log shipping requires the least amount of effort because it just uses the backups that are already being executed against the database. It also leaves the database inaccessible on the secondary. B. Incorrect: Replication would have to be configured in this environment, which would take more effort than just reusing the backups that are already being executed. However, replication does not transfer all the objects within the database by default. Transactional replication would need to be either custom-coded to have the identity property already on columns or would require the creation of scripts to reintroduce the identity property making (which would require much more effort than log shipping). C. Incorrect: Replication would have to be configured in this environment, which would take more effort than just reusing the backups that are already being executed. However, replication does not transfer all the objects within the database by default. Changes could be made at the sub scriber and sent back to the publisher, which would violate business requirements. D. Incorrect: Replication would have to be configured in this environment, which would take more effort than just reusing the backups that are already being executed. However, replication does not transfer all the objects within the database by default. Changes could be made at the sub scriber and sent back to the publisher, which would violate business requirements. 3. Correct Answer: D