1. [单选题]You are the network administrator for Ezonexam.Your Windows 2000 Server computer named Ezonexam1 contains two 36-GB hard disks. Disk 0 and Disk 1. Each disk is configured as a basic disc and has a single 36-GB NTFS partition. Both partitions are backed up to a tape each night. The partition on Disk 1 stores user data. Most users at Ezonexam encrypt their files. Disk 1 fails. You replace it with a new hard disk and create a single NTFS partition.
A. You need to recover the data as quickly as possible while maintaining the security of the files on Disk 1.
B. What should you do?
C. Restore the contents of Disk 1 from the most recent tape backup to a second file server. Instruct users to copy their files from the second file server to the new partition.
D. Restore the contents of Disk 1 from the most recent tape backup to a second file server. Log on to Ezonexam1 console as a recovery agent. Copy the files from the second file server to the new partition.
E. Restore the contents of Disk 1 from the most recent tape backup to the new partition on Ezonexam1. Instruct the users to verify the integrity of their files.
F. Restore the contents of Disk 1 from the most recent tape backup to the new partition on Ezonexam1. Run the cipher command to decrypt the files.
2. [单选题]You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which your company has placed bids.Company policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead.
A. What should you do?
B. Create a Data Transformation Services (DTS) package to remove bids that have a closing data older than one year.
C. Create a trigger to delete any bids that have a closing data older than one year. Bind the trigger to the bids table for all INSERT, UPDATE, and DELETE events.
D. Create a stored procedure to delete any bids that have a closing data order than one year. Use SQL server agent to schedule the stored procedure to run every night.
E. Create a view that contains a WHERE clause to exclude bids that have a closing date older than one year.
3. [多选题]The network consists of a single domain named Ezonexam.com that includes 20 Windows NT workstation 4.0 client computers. All other client computers are Windows 2000 Professional computers. You install Terminal Services on one of the Windows Server computers and Terminal Services Client on the 20 Windows NT Workstation 4.0 client computers. You create a system policy on the server that is configured as the terminal server. This system policy denies access to Network Neighborhood. You find that the users of the terminal server can still browse the network when they open My Network Places from Windows 2000 Professional computer or when they open Network Neighborhood from Windows NT Workstation 4.0 computers.You want to prevent all users from browsing the network.
A. What should you do? (Each correct answer presents a complete solution. Choose two.)
B. Create a Windows Group Policy that denies user access to My Network Places.
C. Copy the Windows NT policy file to the 20 Windows NT Workstation 4.0 computers.
D. Create a Windows NT 4.0 default user policy on the Windows 2000 Server computer that is configured as the PDC emulator.
E. Modify the Windows NT policy template file so that you can restrict access to both My Network Places and Network Neighborhood. Save the policy file on the terminal server.
F. Configure the terminal server to use Application server mode. Select the Permissions compatible with Terminal Server 4.0 Users option.
4. [单选题]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.
5. [单选题]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.
6. [多选题]You want to upgrade a Windows NT Server 4.0 computer named Server34 to Windows 2000 Server. Server34 is a member server in a Windows 2000 domain named marketing.fabrikam.local. The domain runs in native mode.You want to change the role of Server34 from a member server to a domain controller in the same domain. What should you do? (Choose Two)
A. Reinstall Windows NT Server 4.0 on Server34 in the same WINNT folder, and make Server34 a B
B. D
C. in the marketing domain.
D. Use Server Manager on Server34 and promote Server34 to a PDC for the marketing domain.
7. [单选题]You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.
A. You want to ensure that the journalists can query the database. What should you do?
B. Create a new full-text catalog for the Articles database
C. Rebuild the full-text catalog for the Articles database
D. Create a new full-text index on the table that holds the text for the articles
E. Repopulate the full-text index on the table that holds the text for the articles
8. [单选题]You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?
A. Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.
B. Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.
C. Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.
D. Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.
9. [单选题]You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.
A. How should you configure the database?
B. Configure the database on the two servers as a SQL Server 2000 cluster.
C. Configure the database on one server, and then configure a standby database on the second server.
D. Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.
E. Configure the database as a federated database, and then partition half the data on each server.
10. [单选题]You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.
A. While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.
B. You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do?
C. Configure SQLAgentMail to use a valid MAPI profile
D. Configure SQL Mail to use a mailbox that delegates permissions to the operator
E. Use the net send notification method to send the operator e-mail messages
F. Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts
