1. [单选题]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.
2. [单选题]You need to install Windows 2000 Professional on 30 new computers. You also need to deploy a Windows 2000 Professional service pack during the installation.First, you create a network distribution folder named InstallFiles. You copy the i386 folder from the Windows 2000 Professional CD to the InstallFiles folder.
A. What should you do?
B. Copy the service pack files to the InstallFiles\Misc folder.
C. Copy the service pack files to the InstallFiles\$OEM$ folder.
D. From an existing client computer, run theUpdate -ucommand from the service pack to the InstallFiles folder.
E. From an existing client computer, run theUpdate -s:InstallFilescommand from the service pack to the InstallFiles folder.
3. [单选题]You copy the contents of the Windows 2000 Professional CD to a shared network folder named \\Server1\Win2000p. You use the shared folder to perform. over-the-network installations of Windows 2000 Professional on new computers purchased by your company.You receive a Windows 2000 Service Pack CD. You apply the Service Pack to Server1 and to the \\Server1\Win2000p folder.
A. You discover that the Service Pack contains several files that are incompatible with the new computers.
B. You want to make sure that the Service Pack files are not installed on any new computers until the problem has been corrected. What can you do?
C. Use Update.exe from the Service Pack CD on server1.
D. Select the Uninstall option.
E. Copy the contents of the Windows 2000 Professional CD to \\Server1\Win2000p again, allowing the operating system to overwrite newer files while copying.
F. Run\\Server1\Win2000p\WinNT32.exe/uon the new computer.
G. RunUpdate.exe/s:\\Server1\Win2000p/ufrom the Service Pack CD on Server1.
4. [单选题]You plan to install Windows 2000 Server on 10 new computers. These servers will provide file and print services in branch offices of Ezonexam.com. The company wants each branch office to purchase its own copy of Windows 2000 Server, and the installation in each branch office should use the serial number associated with the branch office's own copy.You want to install, configure, and test Windows 2000 Server on these computers at the main office before shipping the computers to the branch offices. You want users in the branch office to enter the computer names and serial numbers when they receive the computers.
A. What should you do?
B. Install Windows 2000 Server on the computers by using an unattend.txt file, and then use the registry editor to remove the computer name and license details.
C. Start the installation process from an MS-DOS boot disk. Install Windows 2000 Server on the computers from an existing server by running the Winnt command with the PreInst switch.
D. Install Windows 2000 Server on the computers, and then use Setup Manager to create a sysprep.inf file for sysprep.exe. Place the sysprep.inf file on the computers and run the sysprep-nosidgen command.
E. Create an unattend.txt file by using Setup Manager. Include the following line in the unattend.txt file. emPrenistall=YES. Use this file to perform. the installation.
5. [单选题]You configure a Group Policy Object for the Marketing organizational unit (OU) to prevent users from accessing My Network Places and from running System in Control Panel. You want the Managers domain local group to be able to access My Network Places, but you still want to prevent them from running System in Control Panel.What should you do?
A. Add the managers group to the access control list of the GPO. Disable the permission of the managers group to read and apply the group policy.
B. Add the managers group to the access control list of the GPO. Deny the permission of the managers group to read and apply the group policy.
C. Create a second GPO in the OU. Add the managers group to the access control list. Allow the managers group to apply the group policy. Deny the authenticated users group permission to read and apply group policy. Configure the new GPO to deny the ability to run System in Control Panel. Give the original GPO a higher priority than the new GPO.
D. Create a second GPO in the OU. Add the managers group to the access control list. Allow the managers group to read and apply the group policy. Disable the permission of the authenticated user group to read and apply the group policy. Configure the new GPO to allow access to My Network Places. Give the new GPO a higher priority than the original GPO.
6. [单选题]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.
7. [单选题]You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.The customer service representatives in your company add and edit the information in the complaints table. They work with this table by using a number of client applications, including a web-based application and a Microsoft Windows 32-bit application.
A. The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.
B. You need to notify the customer service manager whenever a complaint is marked as closed. You do not want to make any changes to the client applications.
C. What should you do?
D. Create an UPDATE trigger that sends an e-mail message.
E. Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
F. Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
G. Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
8. [单选题]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.
9. [多选题]You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)
A. Apply a bulk update lock to the table.
B. Use separate client connections to load the files into the table simultaneously.
C. Create a clustered index on the table.
D. Specify the Full Recovery model for the database.
E. Specify the Bulk-Logged Recovery model for the database.
10. [单选题]You need to install Windows 2000 Professional on a new computer in your network. You use the setup manager wizard to configure a fully automated installation script. file. You begin an unattended installation and leave the office.When you return, the installation has reached the GUI-mode setup and you see the following error message "Unattended setup is unable to continue because a setup parameter specified by your system administrator or computer manufacturer is missing or invalid."
A. You need to complete the installation. What must you do?
B. In the unattended section of the answer file, set theOemPreinstallproperty to Yes.
C. In the NetBinding section of the answer file, specify theEnablevariable.
D. In the UserData section of the answer file, specify theProductIDvariable
E. In the GUIUnattended section of the answer file set theOemSkipWelcomeproperty to 1.
