Question about replication

You are the administrator of a SQL Server 2000 computer at your company's
warehouse. All product orders are shipped from this warehouse. Orders are
received at 30 sales offices. Each sales office offers a range of products
specific to its region.
Each sales office contains one SQL Server 2000 computer. These servers
connect to the warehouse through dial- up connections as needed, typically
once a day. Each sales office needs data pertaining only to its region. You
need to replicate inventory data from the server at the warehouse to the
servers at the sales offices. You want to minimize the amount of time needed
to replicate the data. Which three actions should you take? (Each correct
answer represents part of the solution. Choose three.)
A. Create one publication for each Subscriber.
B. Create one publication for all Subscribers.
C. Enable horizontal filtering.
D.Enable vertical filtering.
E. Use pull subscriptions.
F. Use push subscriptions.
pls. help.
I would create one pub for all subscribers, do horizontal filtering ( so
only the data a subscriber needs would be sent.), and go with pull
subscriptions ( because the work would be done at the subscriber, not at the
publisher)..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:069B5539-A863-446C-9D04-C6879CA20E5B@.microsoft.com...
> You are the administrator of a SQL Server 2000 computer at your company's
> warehouse. All product orders are shipped from this warehouse. Orders are
> received at 30 sales offices. Each sales office offers a range of products
> specific to its region.
> Each sales office contains one SQL Server 2000 computer. These servers
> connect to the warehouse through dial- up connections as needed, typically
> once a day. Each sales office needs data pertaining only to its region.
You
> need to replicate inventory data from the server at the warehouse to the
> servers at the sales offices. You want to minimize the amount of time
needed
> to replicate the data. Which three actions should you take? (Each correct
> answer represents part of the solution. Choose three.)
> A. Create one publication for each Subscriber.
> B. Create one publication for all Subscribers.
> C. Enable horizontal filtering.
> D.Enable vertical filtering.
> E. Use pull subscriptions.
> F. Use push subscriptions.
> pls. help.