Which two article properties should you change?

Exhibit:

TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. A database named DB1 is located on SQL1. DB1 contains a table named TestKing4. TestKing4 is replicated to a database named DB1Repl, which is located on SQL2. Full-Text Search is not being used. Users report that the queries they run against TestKing4 in DB1Repl are very slow. You investigate and discover that only the clustered index of TestKing4 is replicated. All other indexes in DB1Repl are missing. You examine the TestKing4 article properties. The current TestKing4 article properties are shown in the exhibit.

You need to change the article properties so that all indexes of TestKing4 in DB1 are replicated when the subscription is reinitialized. Which two article properties should you change? (Each correct answer presents part of the solution. Choose two.)

Leading the way in IT testing and certification tools, www.testking.com

Exhibit:

TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. A database named DB1 is located on SQL1. DB1 contains a table named TestKing4. TestKing4 is replicated to a database named DB1Repl, which is located on SQL2. Full-Text Search is not being used. Users report that the queries they run against TestKing4 in DB1Repl are very slow. You investigate and discover that only the clustered index of TestKing4 is replicated. All other indexes in DB1Repl are missing. You examine the TestKing4 article properties. The current TestKing4 article properties are shown in the exhibit.

You need to change the article properties so that all indexes of TestKing4 in DB1 are replicated when the subscription is reinitialized. Which two article properties should you change? (Each correct answer presents part of the solution. Choose two.)

A.
Copy clustered index

B.
Copy nonclustered indexes

C.
Copy extended properties

D.
Copy unique key constraints

E.
Copy index partitioning schemes

F.
Copy XML indexes



Leave a Reply 0

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