1. [多选题]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.
2. [多选题]You are the network administrator for Ezonexam.com. Your network has 210 Windows 2000 Professional computers and eleven Windows 2000 Server computers. Users on the network save their work files in home folders on a network server. The NTFS partition that contains the home folders has Encrypting File System (EFS) enabled. A user named Sandra leaves Ezonexam.com. You decrypt the files for her manager. When the manager attempts to open any of the files, he receives the following error message: "Access is denied."You want the manager to be able to access the files.
A. What should do? (Each correct answer presents a complete solution. Choose two.)
B. Move the files from Sandra's folder to the manager's folder.
C. Grant the manager NTFSFull Controlpermission to the files.
D. Run theciphercommand to create a new file encryption key for the manager.
E. Run theciphercommand to generate an EFS recovery agent key and certificate.
F. Grant the manager NTFSList Folder Contentspermissions to the folder containing Sandra's files.
