1. [单选题]Exhibit:UPDATE EzonexamConsolidated
A. SET District = ‘Mexico’
B. WHERE RtvID = 45
C. You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.
D. When users run the query in the exhibit above the receive the following error message:
E. Server: Mrh3612, Level 16, Stats 1, Line 1
F. View or function ‘EzonexamConsolidated’ is not updateable because it
G. contains aggregates:
H. How should you enable the query to run?
I. Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.
J. The appropriate users should be granted UPDATE permissions on each base table.
K. To enable updates on the composite tables create an INSTEAD OF trigger on the view.
L. On each base table add a cascading update trigger.
2. [单选题]You need to install Windows 2000 Professional on 300 computers for a customer company called Ezonexam. The computers have different manufacturers and different hardware abstraction layers (HALs). You plan to use a Windows 2000 Server computer running Remote Installation Services (RIS) to perform. the installation.After the installation is complete for the first 25 computers, users of those computers report problems. You discover that the latest Windows 2000 service pack resolves those problems.
A. You want to apply the service pack to the remaining 275 computers during the installation. What should you do?
B. Install the service pack on a reference Windows 2000 Professional computer, and then run the Riprep command on that computer. Use the resulting image for RIS.
C. Install the service pack on the RIS server, and then run the Riprep command on that server. Use the resulting image for RIS.
D. Copy the service pack to the CD-based image shared folder used by RIS.
E. Slipstream the service pack into a new i386 distribution shared folder, and then run the Risetup command to create a new CD-based image for the RIS server.
3. [单选题]Your company network includes 6,000 Windows 2000 Professional client computers and 35 Windows 2000 Server computers in a single domain.Your company has a print device that is used to print payroll checks. The print device is physically attached to the parallel port of one of the client computers. This print device's tray is loaded with checks at all times. You have shared this printer on the network as ChkPrinter and retained the default permissions.
A. A payroll application runs on a server named HRserv. Every Wednesday at 5:00P.M, the application prints paychecks from employees on this printer. The payroll application runs as a Windows 2000 service on HRserv.
B. You need to configure ChkPrinter so that only the payroll application will be able to use the printer.
C. What should you do?
D. Configure the share name for ChkPrinter to be ChkPrinter$. Configure the payroll application to print to this new share name.
E. Configure ChkPrinter so that it is available only from5:00 P.Mto5:30 P.M
F. Configure ChkPrinter to allow the HRserv domain account print permissions for ChkPrinter. Remove print permissions for the Everyone group.
G. Configure ChkPrinter to allow all HRserv domain accounts Print permissions for ChkPrinter. Change the permissions to deny print on ChkPrinter for the Everyone group.
4. [单选题]You are the administrator of a Windows 2000 Professional computer that has a shared printer. Several departments in your company use the shared printer.The Sales department frequently prints multiple-page presentation graphics, which take a long time to print. Users in other departments who have short messages to print must wait an unnecessarily long time for their jobs to print.
A. You want to improve the efficiency of printing for all users who use the shared printer. You want to accomplish this with the least amount of administrative effort.
B. What should you do?
C. Configure the priority of the printer to 50. Add a new printer, and set the priority to 1. For the new printer, deny print permission for users in the Sales department.
D. Configure the priority of the printer to 50. Add a new printer, and set the priority to 99. For the new printer, deny print permissions for users in the Sales department.
E. Monitor the print queue and raise the priority of all print jobs that are sent by users who are not members of the Sales department.
F. Delete the old printer. Add a new printer, and set the priority to a higher value. Pause the print queue only when graphic intensive print jobs are printing.
5. [多选题]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.
6. [单选题]You are the network administrator for Ezonexam. You are planning to upgrade 35 Windows NT Server 4.0 computers to Windows 2000 Server. You want to accomplish the upgrades by using a distribution server. The Windows NT Server 4.0 computers support a tight production schedule that requires them to be online from 8:00
A. M. to midnight, seven days a week. You schedule the upgrade to run during non-business hours. Because of the limited amount of time the upgrades must be performed as quickly as possible.You want to complete the upgrades before production begins in the morning.
B. What should you do?
C. Perform. an unattended installation by running the winnt32 command and the /cmdcons switch.
D. Perform. an unattended installation by running the winnt32 command and specify the use of a .txt file and a uniqueness database file.
E. Perform. an unattended installation by running the winnt command and specify the use of a .txt file and a uniqueness database file.
F. Perform. an unattended installation by using a Winnt.sif file with a commands section that initiates the Update.exe command in quiet mode.
7. [单选题]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.
8. [多选题]You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers.Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month.
A. You want to minimize the workload on the Publisher/Distributor. Which two actions should you take to configure snapshot replication? (Each correct answer presents part of the solution. Choose two)
B. Store the snapshot in the default folder on the Publisher/Distributor.
C. Store the snapshot in an alternative folder on the Publisher/Distributor.
D. Store the snapshot in a shared folder on a file server.
E. Create pull subscriptions.
F. Create push subscriptions.
9. [多选题]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.
10. [单选题]A folder on your Windows 2000 Professional computer contains bitmap files that have been compressed from 2MB to 1MB. You want to copy one of the compressed bitmap files from the hard disk to 1.4-MB floppy disk.When you attempt to copy, you receive the following error message 'Destination drive is Full'.
A. What should to do?
B. Move, rather than copy, the compressed bitmap file to the floppy disk.
C. Reformat the floppy disk. Then copy the compressed bitmap file to the floppy disk.
D. Use another program to compress the bitmap file before copying it to the floppy disk.
E. Copy an empty compressed folder to the floppy disk. Then copy the compressed bitmap file to the folder on the floppy disk.
