单选题YouaretheadministratorofaSQLServer2000computer.TheservercontainsadatabasenamedInventory.Thedatabaseisconfiguredasshownintheexhibit.Usersfrequentlyneeddetailsaboutparts.Userssearchfordatabyusingthefollowingquery.SELECTParts.SKU,Locations.Description,Manufacturer.Name,PartsLocations.Qty,PartsLocations.LastInventoriedFROMPartsINNERJOINManufacturerONParts.ManufacturerID=Manufacturer.ManufacturerIDINNERJOINPartsLocationONParts.PartID=Parts.Location.PartsIDINNERJOINLocationsONParts.LocationID=Locations.LocationIDWHERESKU?Youneedtoacceleratequeryresponsetime.Whatshouldyoudo?
单选题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?
单选题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?
单选题YouaretheadministratorofaSQLServer2000computer.TheservercontainsadatabasenamedInventory.UsersreportthatseveralstoragelocationsintheUnitsStoredfieldcontainnegativenumbers.Youexaminethedatabase'stablestructure.Thetablepropertiesareconfiguredasshownintheexhibit.Youcorrectallthenegativenumbersinthetable.Youmustpreventthedatabasefromstoringnegativenumbers.YoualsowanttominimizeuseofserverresourcesandphysicalI/O.Whichtransact-SQLstatementshouldyouexecute?
单选题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.What should you do?
单选题You are the administrator responsible for security and user desktop settings on your network. You need to configure a custom registry entry for all users. You want to add the custom registry entry into a Group Policy object (GPO) with the least amount of administrative effort.What should you do?
单选题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?
单选题You are an administrator of Ezonexam.com's network. You want to perform routine upgrades on your Windows 2000 Server computer. You use your non-administrator user account in the domain to logon to the server.You want to upgrade all of the critical system files and patches on the server in the shortest possible time.What should you do?
单选题You are the administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur.-- A BULK INSERT job imports data at 10:00 P.M.-- Indexes are rebuilt at 10:15 P.M.-- Data integrity checks are performed at 10:30 P.M.-- A differential backup is performed at 10:45 P.M.-- A DBCC SHRINKDATABASE job runs at 11:00 P.M.You notice that the final job often fails and returns the following error message: "Server Msg 3140, Level 16, State 3. Could not adjust the space allocation for file 'inventory_data'."You need to ensure that the final job runs without errors. What should you do?
单选题YouaretheadministratorofaSQLserver2000computer.TheservercontainsadatabasenamedInventory.Developersatyourcompanyupgradeaninventorytrackingapplication.UsersreportthatwhentheyinsertnewinformationintheLocationstable,theupgradeapplicationreturnsthefollowingerrormessage‘stringorbinarydatawouldbetruncated.Thestatementhasbeenterminated.’WhenyouuseSQLprofilertotracetheactivityoftheapplication,youreceivetheresultsasshowninthetraceexhibit.Youexaminethedesignofthelocationstableasshowninthetabledesignexhibit.TableSchemaYouneedtoconfigurethedatabasetosupportbothversionsoftheapplicationwithoutaffectingserverperformance.Whatshouldyoudo?
单选题You are installing Windows 2000 Server on a multiprocessor computer. The manufacturer has provided a customized Hardware abstraction layer (HAL) to use with the computer. The customized HAL is on a floppy disk.You want to install the customized HAL designed for the computer. What should you do?
单选题You are the administrator of a Windows NT Server 4.0 computer names Ezonexam1.Ezonexam1 is a backup domain controller in Ezonexam.com's Windows 2000 Active Directory domain. Ezonexam1 contains five hard disks. Disks 0 and 1 are configured as a Windows NT 4.0 mirror set and contain the operating system files. There are 300 MB of disk space remaining on the Windows NT 4.0 mirror set. Disk 2, 3, and 4 are configured as a Windows NT 4.0 stripe set with parity and contain employee data files. The Windows NT 4.0 stripe set with parity has a maximum capacity of 140 GB and currently has 15 GB free. Ezonexam1 runs an application that is used by all of Ezonexam.com's employees.A new version of the application is available. The new version requires Windows 2000 Server. The application will not run on a domain controller.You need to install the new application on Ezonexam1 as quickly as possible.What should you do first?
单选题YouaretheadministratorofaSQLServer2000computer.TheservercontainsadatabasenamedInventory.ThedatabasehasaPartstablethathasafieldnamedInStock.Whenthepartshaveshipped,atablenamedPartsShippedisupdated.Whenthepartsarereceived,atablenamedPartsReceivedisupdated.Therelationshipofthesetablesisshownintheexhibit.YouwantthedatabasetoupdatetheInStockfieldautomatically.Whatshouldyoudo?
单选题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 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.You need to configure ChkPrinter so that only the payroll application will be able to use the printer.What should you do?
单选题You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?
单选题Your network uses TCP/IP as the only network protocol. Devices on the network are configured to use IP addresses from the private 10.0.0.0 range. All the client computers on the network use Windows 2000 Professional. The network includes Windows 2000 Servers and UNIX Servers.Users' print jobs are sent to shared printers on a Windows 2000 Server computer named PrintServ that directs the print jobs to the print devices attached directly to the network.You have a high-capacity print device that is attached to one of the UNIX Servers. The UNIX computer uses the LPR printing protocol, and its IP address is 10.1.1.99. The name of the printer queue is GIANT.You want users to be able to connect to this printer from their computers.What should you do?
单选题YouconfigureanHPJetDirectprintdeviceassownintheNetworkDiagramexhibit.YouwanttocreateandshareaprinteratSrv2.sales.justtogs.comthatisconnectedtotheTCP/IPportoftheprintdevice.However,whenyouentertheIPaddressofthedevice,youreceivethedialogboxshowninthePrinterPortWizardexhibit.PrinterPortWizardWhatshouldyoudo?
单选题You are the administrator of a Windows 2000 network. Your network includes 75 Windows NT Workstation 4.0 computers. You are adding 50 new PXE-compliant computers to the network. The hardware on each computer is configured identically.You are using a RIS image to deploy Windows 2000 Professional to the 50 computers. You successfully install Windows 2000 Professional on the first 10 computers. However, you cannot install Windows 2000 Professional on remaining 40 computers.What should you do?
单选题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?
单选题You are the administrator of a Windows 2000 Server computer at Blue sky Airlines. You onfigure a server named print10.marketing.blueskyairlines.local as a print server at the Los Angeles site. You create and share a variety of printers on the server for use by employees in the arketing.blueskyairlines.local domain.You want to review the configured properties of all the shared printers on the rint10.marketing.blueskyairlines.local server. You want to perform this review from a Windows 2000 Professional computer at theLondon site of Blue sky Airlines.What should you do?