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 th

题目

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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You are the network administrator for Tailspin Toys. The company has a main office and two branch offices. The network in the main office contains 10 servers and 100 client computers. Each branch office contains 5 servers and 50 client computers. Each branch office is connected to the main office by a direct T1 line.   The network design requires that company IP addresses must be assigned from a single classful private IP address range. The network is assigned a class C private IP address range to allocate IP addresses for servers and client computers.  Tailspin Toys acquires a company named Wingtip Toys. The acquisition will increase the number of servers to 20 and the number of client computers to 200 in the main office. The acquisition is expected to increase the number of servers to 20 and the number of client computers to 200 in the branch offices. The acquisition will also add 10 more branch offices. After the acquisition, all branch offices will be the same size. Each branch office will be connected to the main office by a direct T1 line. The new company will follow the Tailspin Toys network design requirements.   You need to plan the IP addressing for the new company. You need to comply with the network design requirement.   What should you do?  ()

  • A、 Assign the main office and each branch office a new class A private IP address range.
  • B、 Assign the main office and each branch office a new class B private IP address range.
  • C、 Assign the main office and each branch office a subnet from a new class B private IP address range.
  • D、 Assign the main office and each branch office a subnet from the current class C private IP address range.

正确答案:C

第2题:

You are designing a DHCP strategy to meet the business and technical requirements.  What should you do?()

  • A、 Install one DHCP server in each branch office and one DHCP server in Los Angeles.
  • B、 Install one DHCP server in each branch office and two DHCP servers in Los Angeles.
  • C、 Install two DHCP servers in each branch office and one DHCP server in Los Angeles.
  • D、 Install two DHCP servers in each branch office and two DHCP servers in Los Angeles.

正确答案:D

第3题:

You are the network administrator for The company contains of a main office and five branch offices. Network servers are installed in each office. All servers run 2003The technical support stuff is located in the main office. Users in the branch office do not have the "Log on locally" right on local servers.Servers in the branch office collect auditing information.You need the ability to review the ability to review the auditing information located on each branch office server while you are working at the main office. You also need to save the auditing information on each branch office server on the local hard drive.Which two actions should you perform?() (Each correct answer presents part of the solution. Choose two.)

A. From the Security Configuration and Analysis snap-in save the appropriate .inf file on the local hard drive.

B. Solicit Remote Assistance from each branch office server.

C. From Computer Management open Event Viewer, save the appropriate .evt file on the local hard drive

D. Run secedit.exe, specify the appropriate parameter

E. Establish a Remote Desktop client session with each branch office server


参考答案:C, E

第4题:

You are a network administrator for your company. The network consists of a single Active Directory forest that contains three domains. The functional level of the forest and of all three domains is Window Server 2003. The company has a main office and 30 branch offices. Each branch office is connected to the main office by a 56-Kbps WAN connection. You configure the main office and each branch office as a separate Active Directory site. You deploy a Windows Server 2003 domain controller at the main office and at each branch office. Each domain controller is configured as a DNS server.   You can log on to the network from client computers in the branch offices at any time. However, users in the branch offices report that they cannot log on to the network during peak hours.   You need to allow users to log on to the network from branch office computers. You do not want to affect the performance of the branch office domain controllers. You need to minimize Active Directory replication traffic across the WAN connections.   What should you do? ()

  • A、 Use Active Directory Sites and Services to enable universal group membership caching for each branch office site.
  • B、 Use the DNS console to configure the branch office DNS servers to forward requests to a DNS server in the main office.
  • C、 Use Active Directory Sites and Services to configure each branch office domain controller as a global catalog server.
  • D、 Use the DNS console to configure the branch office DNS servers to use an Active Directory-integrated zone.

正确答案:A

第5题:

You are the desktop administrator for one of your company's branch offices. The network in the branch office consists of a single network segment, which contains a domain controller, a DHCP server, 10 Windows 2000 Server computers, and 50 Windows 2000 Professional computers. All servers and client computers are members of the company's Active Directory domain. You purchase 50 new client computers for the branch office. Each new client computer contains a built-in PXE-compliant network adapter. You install and configure RIS on one of the Windows 2000 Server computers that is on the network in the branch office. You create a Windows XP Professional RIS image on the Windows 2000 Server computer. You connect the new client computers to the network in the office, and you turn on each computer. Each computer displays a message stating that it cannot contact a PXE boot server. You verify that the RIS server is connected to the network. You need to ensure that the new client computers can connect to the RIS server and can begin installing Windows XP Professional. What should you do?()

  • A、Ask a domain administrator to authorize the RIS server. 
  • B、Grant the Everyone group Allow - Read NTFS permission on the RIS image.
  • C、Install RIS on the domain controller. Copy the RIS image to the domain controller.
  • D、Add a reservation for the RIS server to the DHCP server. 

正确答案:A

第6题:

Your company uses DHCP to lease IPv4 addresses to computers at the main office. A WAN link connects the main office to a branch office. All computers in the branch office are configured with static IP addresses. The branch office does not use DHCP and uses a different subnet. You need to ensure that the portable computers can connect to network resources at the main office and the branch office. How should you configure each portable computer?()

  • A、Use a static IPv4 address in the range used at the branch office.
  • B、Use an alternate configureation that contains a static IP address in the range used at the main office
  • C、Use the address that was assigned by DHCP as a static IP address
  • D、Use an alternate configuration that contains a static Ip address in the range used at the branch office.

正确答案:D

第7题:

Your company has a single Active Directory domain.The company has a main office and three branch offices. The domain controller in the main office runs Windows Server 2008 R2 and provides DNS for the main office and all of the branch offices. Each branch office contains a file server that runs Windows Server 2008 R2.Users in the branch offices report that it takes a long time to access network resources. You confirm that there are no problems with WAN connectivity or bandwidth.You need to ensure that users in the branch offices are able to access network resources as quickly as possible.Which two actions should you perform?()

  • A、Configure a standard primary zone in each of the branch offices.
  • B、Configure forwarders that point to the DNS server in the main office.
  • C、Configure a secondary zone in each of the branch offices that uses the main office DNS server as a master.
  • D、Install DNS servers in each of the branch offices.

正确答案:C,D

第8题:

our company has a single Active Directory domain.The company has a main office and three branch offices. The domain controller in the main office runs Windows Server 2008 and provides DNS for the main office and all of the branch offices. Each branch office contains a file server that runs Windows Server 2008.Users in the branch offices report that it takes a long time to access network resources. You confirm that there are no problems with WAN connectivity or bandwidth.You need to ensure that users in the branch offices are able to access network resources as quickly as possible.Which two actions should you perform? ()

  • A、Configure a standard primary zone in each of the branch offices.
  • B、Configure forwarders that point to the DNS server in the main office.
  • C、Configure a secondary zone in each of the branch offices that uses the main office DNS server as a master.
  • D、Install DNS servers in each of the branch offices.

正确答案:C,D

第9题:

You are the network administrator for The company contains of a main office and five branch offices. Network servers are installed in each office. All servers run 2003 The technical support stuff is located in the main office. Users in the branch office do not have the "Log on locally" right on local servers. Servers in the branch office collect auditing information. You need the ability to review the ability to review the auditing information located on each branch office server while you are working at the main office. You also need to save the auditing information on each branch office server on the local hard drive. Which two actions should you perform?() (Each correct answer presents part of the solution. Choose two.)

  • A、From the Security Configuration and Analysis snap-in save the appropriate .inf file on the local hard drive.
  • B、Solicit Remote Assistance from each branch office server.
  • C、From Computer Management open Event Viewer, save the appropriate .evt file on the local hard drive
  • D、Run secedit.exe, specify the appropriate parameter
  • E、Establish a Remote Desktop client session with each branch office server

正确答案:C,E

第10题:

Your company has a main office and 50 branch offices. Each office is configured as an Active Directory site. Each branch office site contains a domain controller.  The main office site contains all the global catalog servers in the forest. Each branch office contains a WAN link that connects to the main office.  You need to plan the deployment of new Mailbox servers to meet the following requirements: .Ensure that users in the branch offices can access their mailboxes if their local domain controller fails .Deploy the minimum number of Exchange servers What should you include in the plan?()

  • A、One Mailbox server in each office and global catalog servers in each branch office
  • B、One Mailbox server in each office and Universal Group Membership Caching in each branch office
  • C、One Mailbox server in each branch office only
  • D、Multiple Mailbox servers in the main office only

正确答案:D

更多相关问题