CMS专题
单选题A customer needs a new database server. Their third-party application requires Microsoft SQL Server. They have 100 users who will login to the network and store their data files on the network server. They will also require the server to be an email
题目
SuSE Linux Enterprise 9
Red Hat Linux Advanced Server 3
Microsoft Windows 2003 Server Web Edition
Microsoft Windows 2003 Server Standard Edition
相似问题和答案
第1题：
A company needs additional storage for a block I/O based database application. The application has low I/O bandwidth requirements across the campus. The customer has a TCP/IP infrastructure and is interested in low-cost products that are compatible with its environment. Which technology is most appropriate for this customer?（）
- A、SAN
- B、FCoE
- C、FCIP
- D、iSCSI
正确答案:D
第2题：
A customer needs to add three JS22 blade servers. The customer currently has three HS21 Blade servers and one LS41 4-socket Blade Server. Based upon this information， what additional items does the customer need to purchase？ （）
- A、An IBM BladeCenter H chassis for the JS22 Blade servers
- B、A concurrent KVM daughter card
- C、A pair of IBM BladeCenter Power Supplies
- D、A second Management Module
正确答案:C
第3题：
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?
A．Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.
B．Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.
C．Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.
D．Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.
解析：Explanation:Detachingandattachingdatabasesissometimesausefultechniqueforquicklymovingadatabasefromonecomputertoanother.Tomoveadatabase,ordatabasefile,toanotherserverordiskthedatabasemustfirstbedetachedfromtheoriginalserverordisk;movedtotheotherserverordiskandthenattachedontheserverordisk.Inadditionthenewlocationofthemovedfile(s)mustbespecified.Thesp_detach_dbstoredprocedureisusedtodetachthedatabaseandcanrunUPDATESTATISTICSonalltablesbeforedetachingthedatabasewhilethesp_attach_dbstoredprocedureisusedtoattachthedatabaseinitsnewlocation.IncorrectAnswers:B:DTScanimportdatafromatextfileorfromanOLEDBdatasourcesuchasaMicrosoftAccess2000databaseintoSQLServer.ItcanalsoexportdatafromSQLServertoanOLEDBdatadestination.Itprovidesforhigh-speeddataloadingfromtextfilesintoSQLServertables.However,itisnotthefastestwaytomoveawholedatabasefromoneservertoanother.C:Beforeadatabasecanberestoredfromabackuptoanewlocation;thedatabasemustfirstberecreatedinthedestinationasthebackupholdsonlythedatafilesthatbelonginthevarioustables.Itdoesnotholdthetabledefinitions.Thisisnotthefastestmethodtomoveadatabase.D:TheDISKINITandDISKREFITcommandscannotbeusedtomoveadatabasefromoneservertoanother.Note:DISKINITandDISKREINITarefeaturesthatareusedinaSQLServer6.x.inSQLServer6.x,DISKINITisusedtocreatedatabaseortransactionlogdevicestostorethespecifieddatabaseortransactionlogwhenDISKINITfollowedeitheraCREATEDATABASEorALTERDATABASEstatementwhileDISKREINITisusedtorestoredeviceentriestoappropriatesystemtableswhenthedeviceentrywasmissingfromsysdevices.InSQLServer2000theCREATEDATABASEandALTERDATABASEstatementsallowforthecreationofseparatedataandlogfiles.BothCREATEDATABASEandALTERDATABASEcreateoperatingsystemfilesanddatabasesinasinglestep.ItisthusrecommendedthatallreferencestoDISKINITshouldberemovedinSQLServer2000andreplacedwithreferencestoeitherCREATEDATABASEorALTERDATABASE.
第4题：
A customer needs a new Microsoft Windows 2003 Server. They are running an application that requires substantial memory. They would like a rack mountable system， which will support four Xeon processors with 2MB of L3 cache. Which of the following is the minimum configuration to satisfy the customer’s requirements？（）
- A、x445 with four Xeon MP processors and 8GB of memory
- B、x445 with four Xeon MP processors and 16GB of memory in a single SMP module
- C、x445 with four Xeon DP processors and 16GB of memory in a single SMP module
- D、x445 with two SMP modules each containing two Xeon DP processors and 8GB of memory
正确答案:A
第5题：
A customer needs a new database server. Their third-party application requires Microsoft SQL Server. They have 100 users who will login to the network and store their data files on the network server. They will also require the server to be an email server and to deploy a central antivirus solution. Which of the following network operating systems would satisfy these requirements？（）
- A、SuSE Linux Enterprise 9
- B、Red Hat Linux Advanced Server 3
- C、Microsoft Windows 2003 Server Web Edition
- D、Microsoft Windows 2003 Server Standard Edition
正确答案:D
第6题：
A customer needs both a database and application server to communicate over a network. The new systems will be connected to the same network as the current IBM equipment with known IBM serial numbers. How could a pSeries technical specialist best determine which type of network card is appropriate， without making an additional call to the customer？（）
- A、Use an Inventory Services retrieval to show adapter features.
- B、Retrieve previous eConfig proposals to see what others had shown.
- C、Call the Account Executive to ask what the customer has used in the past.
- D、Query the Supportline problem record database for the customer and LAN keyword matches.
正确答案:A
第7题：
A customer has a combination of fifteen Windows file servers with direct attached storage and three Power Systems with AIX database servers SAN attached to a DS4700. They would like to upgrade and plan for 40 TB capacity. The customer needs to move to a more scalable storage system to include all servers.Which of the following would be most appropriate to ask first?（）
- A、What are the plans for Disaster Recovery?
- B、What are the plans for data migration?
- C、Would iSCSI meet your needs?
- D、How much space is available in the current storage systems?
正确答案:B
第8题：
A. disaster recovery strategy
B. the number of IOPS required
C. the capacity of each hard drive
D. how the database will be backed up
第9题：
A commercial customer will soon send out a Request For Pricing （RFP） for a new large database server. Why would a pSeries technical specialist try to influence the customer to base the requirements on performance （TPC-C， Ideas International Relativity， Oracle Applications Standard Benchmark， etc.） rather than on numbers of processors？（）
- A、IBM processor performance does not scale well over 16 ways.
- B、Competitors do not pay for TPC-C certification so results are not available.
- C、IBM servers consistently outperform some other servers on a "per CPU" basis.
- D、IBM prices are lower than competition when like numbers of processors are proposed.
正确答案:C
第10题：
A customer needs a new database server. The database application has a high memory overhead but does not benefit from 8-way processing. They would like a rack mountable system， which will support four Xeon processors with 512KB of L2 cache and 16GB of main system memory. Which of the following will satisfy the customer’s requirements？（）
- A、x445 with four Xeon DP processors and 16GB of memory in a single SMP module
- B、x445 with four Xeon MP processors and 16GB of memory in a single SMP module
- C、x445 with two SMP modules each containing two Xeon DP processors and 8GB of memory
- D、x445 with two SMP modules each containing two Xeon MP processors and 8GB of memory
正确答案:C