You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.

The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.

You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.

You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.

You want to enable the server in Sydney to connect to the mainframe. database. What should you do?

A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.

B．Modify the workflow in the DTS package so that the server in Sydney is included.

C．On the server in Sydney, install an OLE DB provider for the mainframe. database.

D．On the server in Sydney, delete and then re-create the DTS package.

[单选题]You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A． Data Transforma

[单选题]You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and ad

[单选题]You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.B．ecause you have had power interruptions in the past, you want to perfect the phy

[单选题]You are a systems administrator and you are about to assign static IP addresses to various servers on your network. For the network 192.168.20.24/29 the router is assigned to the first usable host address, while the last usable host address goes to y

[单选题]You are an administrator of the Ezonexam switched network and your goal is to reduce some of the administrative overhead on your network. You plan on achieving this by configuring a new VLAN for each department in the Ezonexam network.H．owever, you n

[单选题]You are the administrator of the homeoffice.local domain. You want to create a shared printer for the company's executives so that they do not have to wait for their documents to print when the default printer's queue contains a large number of doc

[单选题]You are the workstation administrator at Ezonexam. You administer a Windows 2000 Professional computer named VE1.VE1 has a shared color laser printer named Printer1. You need to print a document immediately. The print queue for Printer1 has ten jobs

[主观题]You are a database developer for a container manufacturing company. The containers produced by your company are a number of different sizes and shapes. The tables that store the container information are shown in the Size, Container, and Shape Tables

[单选题]You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.You need to create a new database named Inventory. Employees in your company will use the Inventory database to tr

[单选题]You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-L