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.
Same question 73.
According to it answer should be: ABCD
No the correct answers are
BCDF
Sorry it is
ABDF
Sorry it is BCDF
B-C-D
https://technet.microsoft.com/en-us/library/ms188299(v=sql.105).aspx
According to the link the view must be created in all servers. Answer should be B-C-D-F
This is correct. B-C-D-F.
I agree BCDF
B,C,D are enough. We didn’t add SQL1 as linked server in SQL2.