问题：Your Windows 2000 Server computer has a 10-GB hard disk with two partitions: Drive C and drive D. Windows 2000 Server is installed on Drive D. Both partitions are formatted as NTFS. Your office experiences a power failure that causes your Windows 2000 Server computer to restart.When the computer is restarting, you receive the following error message "NTLDR is missing. Press any key to restart".What should you do?A．Start the computer by using Windows 2000 Server computer CD-ROM and choose to repair the installation. Select the Recovery Console and copy the NTLDR file on the CD-ROM to the root of the system partition.B．Start the computer in debugging mode. Copy the NTLDR file on the CD-ROM to the root of the system partition.C．Start the computer by using the Windows 2000 bootable floppy disk. From a command prompt, run the sfc/scanboot command.D．Start the computer by using a Windows 2000 bootable floppy disk. Run the File Signature Verification utility.
查看答案
问题：You are the network administrator for Ezonexam.You are planning to upgrade Windows NT Server 4.0 computers to Windows 2000 Server. You want to perform. the upgrades by means of a distribution folder. You need to install a custom application as part of the upgrade.You need to include the commands necessary so that the custom application is installed as part of the upgrade process.What should you do? (Each correct answer presents part of the solution. Choose two)A．Create a command file named Unattend.txt to install the application.B．Create a command file named Cmdlines.txt to install the application.C．Copy the command file to the \$OEM\$C\ subfolder under the i386 folder.D．Copy the command file to the subfolder named \$OEM$ under the i386 folder.E．Copy the command file to the subfolder named \$OEM$\textmode under the i386 folder.
问题：You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.You want to enable the server in Sydney to connect to the mainframe. database. What should you do?A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.B．Modify the workflow in the DTS package so that the server in Sydney is included.C．On the server in Sydney, install an OLE DB provider for the mainframe. database.D．On the server in Sydney, delete and then re-create the DTS package.
问题：You are the network administrator for Ezonexam.com.You need to upgrade a computer from Windows NT Server 4.0 to Windows 2000 server. The server has dual processors, 2 GB of RAM, a RAID controller with five SCSI hard disks in an array, and a generic 10/100-MB network adapter. You begin the installation of the Windows 2000 Server operating system.During the text portion of the installation, you receive the following error message:"Stop 0x00000078 Inaccessible_boot_device."You want to successfully upgrade the computer.What should you do? (Each answer presents part of the solution. Choose two)A．Start the computer by using a DOS disk and run FDISK.B．Update the firmware on the RAID controller.C．Restart the installation. During the text-mode setup-mode setup, press F6.D．Restart the installation. During the text-mode setup, create a new partition.E．Insert a floppy disk containing the OEM SCSI driver and specify the additional driver.
问题：You are the administrator of SQL server 2000 computer. The server contains a database named MedicalRecords. Users access medical records by using the PatientID field. This field is the clustered primary key for the Patients table. When users try to access medical records, the database responds slowly. You examine the database options as shown in the exhibit.You want to accelerate query response time and minimize administrative overhead. How should you reconfigure the database?A．Create a SQL Server Agent job to execute the UPDATE STATISTICS statement, and schedule the job to run weekly.B．Select the Auto Update Statistics check box.C．Run the database maintenance plan wizard, and accept the default settings.D．Rebuild the primary key as a nonclustered primary key.E．Clear the Auto Create Statistics check box.
问题：You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.However, the existing SQL server computers in your office are configured to use theSQL_Latin1_General_CP1_CI_AS collation.You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.What should you do?A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.
问题：You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.How should you configure SQL1?A．Use the ALTER DATABASE statement to change the collation of the databases on SQL1.B．Add SQL2 as remote server.C．Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.D．Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.
问题：Your network includes Windows 2000 Professional client computers, Windows NT Workstation 4.0 client computers, Windows 95 client computers and UNIX client computers. Users of the Windows operating systems send print jobs to shared printers on a Windows 2000 Server computer named PrintServ. The UNIX client computers support the LPR printing protocol.You want to make the shared printers on PrintServ available to the UNIX computers. What should you do?A．Configure each of the printers to use an LPR port.B．Install Microsoft Print Services for UNIX on PrintServ.C．Configure each of the printers to support TCP/IP printing.D．Use the SRVANY utility from the Windows NT Resource Kit to run the LPR program as a service.
问题：You want to upgrade a Windows NT Server 4.0 computer to Windows 2000 Server. The system partition uses the FAT file system.You start the Setup program by starting the computer from the Windows 2000 Server CD-ROM.However, you receive the following error message, "You chose to install Windows 2000 on a partition that contains another operating system. Installing Windows 2000 on this partition might cause the operating system to function improperly".You are unable to perform. the upgrade. What should you do to resolve the problem?A．Convert the system partition to NTFS.B．Disable Advanced Configuration and Power Interface (ACPI) support for the computer.C．Restart the computer, and then run Winnt32.exe from the Windows NT Server 4.0 environment.D．Remove the Windows 2000 Server CD-ROM and restart the computer by using the setup floppy disks.
问题：Exhibit:UPDATE EzonexamConsolidatedSET District = ‘Mexico’WHERE RtvID = 45You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.When users run the query in the exhibit above the receive the following error message:Server: Mrh3612, Level 16, Stats 1, Line 1View or function ‘EzonexamConsolidated’ is not updateable because itcontains aggregates:How should you enable the query to run?A．Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.B．The appropriate users should be granted UPDATE permissions on each base table.C．To enable updates on the composite tables create an INSTEAD OF trigger on the view.D．On each base table add a cascading update trigger.
问题：You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.
问题：You need to install Windows 2000 Professional on 35 new computers on the company LAN.First, you create a distribution folder on the network server. Then you create a network boot disk to install Windows 2000 Professional from the distribution folder.Now you need to create a batch file, which the network boot disk will execute to start the installation. You must specify a source path and temporary drive for the installation files.You also need to install the accessibility options within the batch file. The batch file must execute a hardware-specific application to run after the GUI-mode Setup has completed.Which command must you specify in the batch file?A．Z:\i386\winnt /s:z:\i386 /t:d: /a /e:z:\hardware\setup.exeB．Z:\i386\winnt /s:z:\i386 /rwinnt.tmp /a /e:z:\hardware\setup.exeC．Z:\i386\winnt32 /s:z:\i386 /tempdrive:d /cmd:z\hardware\setup.exeD．Z:\i386\winnt32 /s:z:\i386 /cmdcons:z:\hardware\setup /makelocalsource
问题：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.The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.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.What should you do?A．Create an UPDATE trigger that sends an e-mail message.B．Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.C．Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.D．Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
问题：You are the network administrator for Ezonexam.com.You are planning to install 10 new Windows 2000 Server computers. Ezonexam has a tight production schedule that requires no changes be made to the Active Directory except during scheduled outages. You schedule the installations during an upcoming network outage which will occur betweenmidnight and 8:00 A.M.You want to complete the installations before production begins in the morning.What should you do?A．Perform. the installations by using four floppy disks create with the Makebt32.exe utility.B．Perform. the installations by using four floppy disks create with the Makeboot.exe utility.C．Perform. the installations by using the Windows 2000 Installation compact disc.D．Perform. the installations by using the Windows 2000 Installation compact disc and a floppy disk containing a Winnt.sif file.
问题：From your Windows 2000 Professional computer, you need to map drive G to the default administrative share on drive C of a server named AppSrv.What can you do to map the drive?A．Run thenet share C$=G:\command.B．Run thenet use G: \\AppSrv\C$command.C．Browse to AppSrv in Windows Explorer, and map drive G to the C$ share.D．Browse to AppSrv in My Network Places, and map drive G to the C$ share.
问题：You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.What should you do?A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.
问题：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.What should you do?A．Enable the torn page detection database option for each database.B．Disable write caching on all disk controllers.C．Ensure that write caching disk controllers have battery backups.D．Create a database maintenance plan to check database integrity and make repairs each night.
问题：You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.What should you do?A．Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.B．Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.C．Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.D．Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.
问题：You are the system administrator for an electronics manufacturing company. The accounting department uses Windows 98 computers. The department has purchased a third-party spreadsheet application that only runs on Windows 2000 Professional. You need to upgrade the computers to Windows 2000 Professional and install the new application. You choose an unattended installation method for both the operating system and the application.The Windows 2000 Professional installation files reside on a server named Ezonexamsrv in a shared folder named W2Ksource. You place the installation files for the spreadsheet application in \\Ezonexamsrv\W2Ksource\i386\$OEMS$. You create an answer file named Acctanswer.txt and place it in \\Ezonexamsrv\W2Ksource.You map drive letter H: to \\Ezonexamsrv\W2Ksource and begin the installation on a test computer by running the winnt32 /s:H:\i386 /u:H:\acctanswer.text command.Windows 2000 Professional is installed successfully. However, the spreadsheet application is not installed. You want to ensure that the spreadsheet application is installed during the unattended installation.What should you do?A．Run thewinnt /s:H:\i386 /u:H:\acctanswer.txtcommand instead of thewinnt32 /s:H:\i386 /u:H:\acctanswer.textcommand.B．Move the spreadsheet application installation files to \\Ezonexamsrv\W2Ksource\i386, and then run thewinnt/s:H:\i386 /u:H:\acctanswer.txtcommand.C．Edit the[Unattended]section of the answer file to contain the parameterOemPreinstall = Yes, and then run thewinnt32 /s:H:\i386/u:H:\acctanswer.txtcommand.D．Rename Acctanswer.txt to Unattend.txt, and then run thewinnt32 /s:H:\i386 /u:H:\unattend.txtcommand.
问题：As a Ezonexam employee you are the desktop administrator of a Windows 2000 Professional computer.The Windows 2000 Professional computer has 25 MB of free disk space drive C and 800 MB of free disks pace on drive E. You are unable to print large documents because if inadequate disk space on drive C.You want to be able to use the space on drive E to print large documents.What should you do?A．From the Printer Properties dialog box, change the location field to E:\Winnt\System32\Spool\Printers.B．From the Print Server Properties dialog box, change the location of the spool folder to any existing file path on drive E.C．Copy the C:\Winnt\System32\Spool\Printers folder to the E:\Winnt\System32\Spool\Printers folder.D．Mount drive C as a subdirectory on drive E.
