PrepAway - Latest Free Exam Questions & Answers

Which two article properties should you change the article properties so that all indexes of Table1 in DB1 are

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 DB1 Repl, which is located on SQL2. Full-Text Search is not being used. Users report that the queries they run against Table1 in DB1 Repl are very slow. You investigate and discover that only the clustered index of Table1 is replicated. All other indexes in DB1 Repl are missing. You examine the Table1 article properties. The current Table1 article properties are shown in the exhibit. (Click the Exhibit button.)
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.)
Exhibit:

PrepAway - Latest Free Exam Questions & Answers

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