You need to create a distributed partitioned view

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.)

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.



Leave a Reply 9

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


zzz

zzz

Same question 73.
According to it answer should be: ABCD

Mido

Mido

No the correct answers are
BCDF

Mido

Mido

Sorry it is
ABDF

Mido

Mido

Sorry it is BCDF

aeo

aeo

B,C,D are enough. We didn’t add SQL1 as linked server in SQL2.