【名词&注释】
正确答案:F。A.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. B.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. C.You want to enable the server in Sydney to connect to the mainframe. database. What should you do? D.Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database. E.Modify the workflow in the DTS package so that the server in Sydney is included. F.On the server in Sydney, install an OLE DB provider for the mainframe. database. G.On the server in Sydney, delete and then re-create the DTS package. 更多微软认证的考试资料下载及答案解析请访问不凡考网计算机类考试考试频道。
[单选题]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.
A. 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.
B. 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.
C. You want to enable the server in Sydney to connect to the mainframe. database. What should you do?
D. Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.
E. Modify the workflow in the DTS package so that the server in Sydney is included.
F. On the server in Sydney, install an OLE DB provider for the mainframe. database.
G. On the server in Sydney, delete and then re-create the DTS package.
查看答案&解析
点击获取本科目所有试题
举一反三：
[单选题]You are configuring 5 computers to use both Windows NT workstation 4.0 and Windows 2000 Professional. Each computer has an 8GB hard disk. You configure that hard disk on each computer to have two 4GB partitions. Windows NT workstation is installed on drive C. Windows 2000 Professional is installed on drive D. In Windows 2000 Professional you configure a disk quota on drive D to prevent users from saving work files on the disk. You restart the computer and load Windows NT workstation.You notice that users can still save files to drive D.
A. You want to prevent users from saving files to drive D in either operating system. You also want to ensure that users can access both drives using either operating system. What should you do on each computer?
B. Use Windows 2000 Professional to configure drive D as a dynamic volume.
C. Use Windows 2000 Professional to enable Encrypting File System (EFS) on drive D．
D. Use Windows NT workstation to configure NTFS permission on drive D to deny the users write permission.
E. Reinstall Windows NT workstation after configuring the disk code task.
[单选题]You are the administrator of a 12 SQL Server 2000 computers. These servers are located in company offices throughout the world.You configure a multiserver job on the server in your company's New York City office. You configure this server as a master server, and designate the remaining 11 servers as target servers.
A. After the job completes successfully, you decide to set up a new SQL Server 2000 computer as the master server. The new server will be named JobMaster and the other 12 servers will be target servers.
B. You need to make the New York City server a target server instead of a master server. What should you do?
C. On the New York City server, defect all 11 target servers. On the JobMaster server, enlist the 12 servers as target servers.
D. On the JobMaster server, enlist all other servers as target servers.
E. On the New York City server enlist the JobMaster server as a target server. Transfer the multiserver jobs from the New York City server to the JobMaster server.
F. On the JobMaster server, enlist the New York City server as a target server. On the JobMaster server, enlist the other 11 servers as target servers. On the JobMaster server, defect the New York City server.
[单选题]You are the administrator of Ezonexam.com's Windows 2000 network.Your computer is configured to use both Windows 2000 Professional and Windows NT Workstation 4.0 Service Pack 3. Your computer has three hard disks: Disk 0, Disk1, and Disk2. Windows NT Workstation 4.0 is installed on Disk 0. Windows 2000 Professional is installed on Disk1. You want to store your project files on Disk2. You configure Disk2 as a basic volume and format the volume as NTFS in Windows 2000 Professional. You then start Windows NT Workstation 4.0. You find that you cannot access your project files.
A. You want to be able to access your project files when using either of the operating systems.
B. What should you do?
C. Upgrade Windows NT Workstation 4.0 to Service Pack 4 or later.
D. Configure Disk 2 as a dynamic volume then format as an NTFS partition.
E. Configure Disk 2 to use Encrypting File System (EFS).
F. Configure Disk 2 as a basic volume and format the volume as FAT32.
[单选题]Ezonexam.com's network contains two domain controllers and approximately 500 client computers. The domain controllers run Windows 2000 Server. The client computers run Windows 2000 Professional. The majority of users have mobile computers. Users in Ezonexam often travel with their mobile computer for extended periods of time and do not have remote access to Ezonexam.com's network.You want to configure the domain controllers so that DNS only contains entries for computers that are active on the network. You also want to ensure that when users return you do not have to manually create or delete DNS entries.
A. How should you configure the DNS servers?
B. Configure both domain controllers with Active Directory integrated primary zones for the domain and enable secure dynamic updates for the zone.
C. Configure both domain controllers with Active Directory integrated primary zones for the domain and the secure cache against pollution option for the zone.
D. Configure both domain controllers with Active Directory integrated primary zones for the domain and enable scavenging and dynamic updates for the zone.
E. Configure both domain controllers with standard primary zones for the domain and enable scavenging for the zone.
F. Configure one server with a standard primary zone for the domain, and configure at least one server with an Active Directory integrated primary zone.
[单选题]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 added to the database. You currently use the following BULK INSERT statement to add the account information:BULK INSERT finance.dbo.customers
A. FROM ‘di\bulk\accts143_10141000.txt’
B. WITH DATAFILETYPE = ‘char’,
C. FIELD/TERMINATOR = ‘\t’,
D. ROWTERMINATOR = ‘\n,’
E. TABLOCK
F. You want to ensure that response times do not slow when new account information is added to the database. What should you do?
G. Drop the indexes for the customers table before the data load, and then re-create the indexes after the data load is complete.
H. Remove the TABLOCK option from the BULK INSERT statement.
I. Add the BATCHSIZE option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
J. Add the ROWS_PER_BATCH option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
[单选题]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.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.
A. What should you do?
B. Enable the torn page detection database option for each database.
C. Disable write caching on all disk controllers.
D. Ensure that write caching disk controllers have battery backups.
E. Create a database maintenance plan to check database integrity and make repairs each night.
本文链接：https://www.zhukaozhuanjia.com/download/6l8ow4.html
