单选题server’s msdb database in an e-mail message to the administrator of another SQL Server computer.You create a job that contains the following steps:--Detach the msdb database--Send the database to the administrator in an e-mail message--Reattach the msdb databaseYou test the job, and it fails on the first step. You need to ensure that the msdb database is mailed to the administrator every night.What should you do?
单选题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?
单选题You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.What should you do?
单选题Ezonexam has 50 offices. The employees in these offices have limited knowledge of Windows 2000. Each office has a network of between five and 20 client computers. The office networks are connected to each other. The company is buying 50 identical computers to run Windows 2000 Server in these offices. The server must be installed to the company's standard configuration. You use Setup Manager to create a network shared distribution folder and a Unattend.txt file that specifies the company's standard configuration.You want to automate the installation process as much as possible, in the least possible amount of time.What should you do?
单选题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?