1. [单选题]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.
2. [单选题]You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?
A. Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.
B. Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.
C. Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account
D. Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
3. [多选题]You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change.You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package.
A. Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two)
B. Enable the Always read properties from UDL file option in the Connection Properties dialog box.
C. Disable the Always read properties from UDL file option in the Connection Properties dialog box.
D. Delete the .udl files and store connection details in the registry by using system data source names.
E. Delete the .udl files, and store connection details in the registry by using user data source names.
F. Make the .udl files available on a network share.
4. [单选题]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.
5. [单选题]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.
6. [单选题]You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.
A. You cancel the SQL Server upgrade wizard.
B. You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?
C. Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.
D. Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.
E. Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.
F. Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.
7. [单选题]You are the administrator of a Windows 2000 Active Directory network. The network consists of a single domain. The domain includes 20 Windows NT Workstation 4.0 client computers. All other client computers are Windows 2000 Professional computers.You create a Windows NT 4.0 default user policy on the Windows 2000 Server computer that is configured as the PDC emulator. This default user policy denies access to Network Neighborhood. You then install Terminal Services on one of the servers and Terminal Services Client on the 20 Windows NT Workstation client computers.
A. You find that the users of the Terminal Server can still browse the network when they open My Network Places. You want to prevent all users from browsing the network.
B. What should you do?
C. 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.
D. Copy the Windows NT policy file to the 20 Windows NT Workstation computers.
E. Create a Windows 2000 Group Policy that denies user access to My Network Places.
F. Edit the local registry on the Windows NT Workstation computers to deny access to Entire Network in Network Neighborhood.
8. [单选题]You are the network administrator for Ezonexam.com. Your computer has a CD-ROM drive attached to a SCSI adapter. You plan to upgrade your computer from Windows NT Workstation 4.0 to Windows 2000 Professional. You determine that the SCSI adapter is not included on the current Hardware Compatibility List (HCL) and that the original SCSI drivers that you used for Windows NT are not compatible with Windows 2000 Professional.You want to upgrade your computer to Windows 2000 Professional.
A. What should you do?
B. Replace the SCSI adapter card with a Windows 2000 Professional compatible SCSI adapter. Start the installation from the Windows 2000 Professional CD-ROM. Add the new adapter card drivers when you are prompted.
C. Obtain Windows 2000 drivers from the SCSI adapter manufacturer. Copy the drivers to C:\Winnt folder. Start the installation from the Windows 2000 Professional CD-ROM.
D. Obtain Windows 2000 drivers from the SCSI adapter manufacturer. Start the installation by using the Windows 2000 Professional CD-ROM. Add the new adapter card drivers when you are prompted.
E. Modify Config.sys to use your existing SCSI adapter and existing CD-ROM drive. Using Windows NT 4.0, start the installation by running Winnt32.exe from the I386 folder on the Windows 2000 Professional CD-ROM.
9. [多选题]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.
10. [单选题]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.
