You are the administrator of a 12 SQL Server 2000 computers.

【名词&注释】

布丁学网发布"You are the administrator of a 12 SQL Server 2000 computers."考试试题下载及答案，更多微软认证的考试试题下载及答案考试题库请访问布丁学网计算机类考试频道。

[单选题]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 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 administrator of your company's network. An employee named Mark is leaving the company. A new employee named Eric has been hired to replace him.Mark has a local user account on a Windows 2000 Professional computer. Mark has rights to multiple files and folders on the computer.

A. You want Eric to have the same rights and permissions that Mark has. You want to ensure that Mark will no longer have access to the files and folders. You want to accomplish this with least administrative effort.
B. What should you do?
C. Rename Mark's user account to Eric and change the account password.
D. Create Eric's account by copying Mark's profile to Eric's account. Delete Mark's account.
E. Create Eric's account by copying Marks account. Delete Mark's account.
F. Delete Mark's account. Add Eric's account. Add Eric to the same groups to which Mark belonged. Grant Eric to all the individual user rights and permissions that Mark had.

本文链接：https://www.51ksbd.net/show/ewdz40.html