Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_Sales. The database contains a Sales table.
You have developed a Merge Replication topology and a Publication that is configured to keep
data for 25 days. This configuration allows for the Sales table to be replicated to remote SQL
Server instances.
You have received a report from a ABC.com user, named Mia Hamm, regarding ABC_Sales not
including the latest information. Mia Hamm has informed you that she has been on holiday for
more than 25 days.
You are required to make sure that Mia Hamm has the latest information in her database as soon
as possible. Your solution should also allow for further modifications to the database information to
be replicated properly.

Which of the following actions should you take? (Choose all that apply.)

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_Sales. The database contains a Sales table.
You have developed a Merge Replication topology and a Publication that is configured to keep
data for 25 days. This configuration allows for the Sales table to be replicated to remote SQL
Server instances.
You have received a report from a ABC.com user, named Mia Hamm, regarding ABC_Sales not
including the latest information. Mia Hamm has informed you that she has been on holiday for
more than 25 days.
You are required to make sure that Mia Hamm has the latest information in her database as soon
as possible. Your solution should also allow for further modifications to the database information to
be replicated properly.

Which of the following actions should you take? (Choose all that apply.)

A.
You should consider developing a new Merge Replication topology

B.
You should consider resetting the publication.

C.
You should consider creating a new snapshot at once.

D.
You should consider creating a new incremental backup.

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


yuri

yuri

.. does resetting mean or include reinitialize ?