Exhibit:
Your company has two SQL Server 2005 computers named SQL1 and SQL2. A database named DB1 is located on SQL1. DB1 contains a table named Table1. Table1 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 Table1 in DB1Repl are very slow. You investigate and discover that only the clustered index of Table1 is replicated. All other indexes in DB1Repl are missing. You examine the Table1 article properties. The current Table1 article properties are shown in the exhibit.
You need to change the article properties so that all indexes of Table1 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