Your network contains a server named SQL1 that has SQL Server 2012 installed. SQL1
contains
a database name DB1 and a table named Customers.
You add an additional server named SQL2 that runs SQL Server 2012.
You need to create a distributed partitioned view. The solution must minimize the amount
ofnetwork traffic.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
A.
Add SQL2 as a Distributor.
B.
Add the Customers table to SQL2.
C.
Add SQL2 as a linked server.
D.
Create the view on SQL1.
E.
Remove the Customers table from SQL1.
F.
Create the view on SQL2.
Explanation:
The right answer is
B. Add the Customers table to SQL2.
C. Add SQL2 as a linked server.
D. Create the view on SQL1.
F. Create the view on SQL2.
See
– https://technet.microsoft.com/en-us/library/aa933141(v=sql.80).aspx
– https://technet.microsoft.com/en-us/library/ms188299(v=sql.105).aspx
agree
I think it’s still missing the “Add SQL1 as a linked server”
Add SQL2 as a linked server.
Add SQL1 as a linked server.
Add the Customers table to SQL2.
Create the view on SQL1.
Create the view on SQL2.