SK0-002
单选题Two new servers are purchased and need to be installed to allow sharing of a single external hard drive enclosure. One server is configured as a local file server， and the other as a database server for a different network. The onsite technician noti
题目
the server vendor’s FAQ website
the SCSI controller vendor’s user manual
the drive enclosure vendor’s user manual
the network operating system vendor’s website
相似问题和答案
第1题：
You are the administrator of a SQL Server 2000 computer. The server contains a database named Acct. You purge the Acct database of old records and perform. a full backup. The database now uses 4 GB of space. The database files are configured as shown in the Acct Properties exhibit.
The server has two hard disks that are configured as shown in the Server Configuration exhibit.
The 3 GB transaction log file for the Acct database is stored on drive C. You need to make room for a new database that has a 3 GB data file and a 1 GB transaction log file. You want to optimize database performance on both databases. You also want to minimize administrative overhead.
What should you do?
A．Shrink the empty data file on drive E. Place the new data file and the new log file on drive E.
B．Shrink the empty data file on drive E. Backup and shrink the log file on drive C to 2 GB. Place the new data file on drive E and the new log file on drive C.
C．Shrink the data file on drive D to 1 GB, and then shrink the data file on drive E to 2 GB. Place the new data file on drive D and the new log file on drive E.
D．Shrink and delete the data file on drive C, and then shrink the database files on drives D and E so that they are both 2 GB. Place the new data file and the new log file on drive C.
解析：Explanation: We must add a new 3GB database with a 1GB transaction log file. Currently we have database that is using 4GB for data and 3GB for the log file. We should place the log file and the data file on two different physical disks out of performance reasons.
The command DBCC SHRINKFILE with the EMPTYFILE option can be used to shrink a datafile to empty. The data will be migrated to the other files in the filegroup. We use this method to free 4.5 GB on Drive E. Then we backup the log file on C and reduce it to 2GB. Then we put the database data file on drive (3GB) and put the log file of the new database on drive C (1GB).
Incorrect answers:
A: It’s better to put the data file and the log file of the new database on two different physical disks out of performance reasons.
C: It’s better to put the data file and the log file of the new database on two different physical disks out of performance reasons.
D: It’s better to put the data file and the log file of the new database on two different physical disks out of performance reasons.
第2题：
Two new servers are purchased and need to be installed to allow sharing of a single external hard drive enclosure. One server is configured as a local file server， and the other as a database server for a different network. The onsite technician notices that when both servers are running at the same time， they each receive SCSI errors. When they are running individually， no errors are reported. Which of the following is the BEST source of information to use for troubleshooting this problem？（）
- A、 the server vendor’s FAQ website
- B、 the SCSI controller vendor’s user manual
- C、 the drive enclosure vendor’s user manual
- D、 the network operating system vendor’s website
正确答案: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题：
Which two statements regarding external authentication servers for firewall userauthentication are true？（）
- A、Up to three external authentication server types can be used simultaneously.
- B、Only one external authentication server type can be used simultaneously.
- C、If the local password database is not configured in the authentication order， and the configured authentication server is unreachable， authentication is not performed.
- D、If the local password database is not configured in the authentication order， and the configured authentication server rejects the authentication request， authentication is not performed
正确答案:B,D
第5题：
A customer has just purchased six x346 servers running Windows 2003 Web Edition.They are expecting to add six additional x346’s in three months.They have a requirement to automatically deploy the current server image upon the new servers. What TWO actions are required to complete this task？（）
- A、Ensure Director Agent is installed on the new servers.
- B、Ensure a DHCP Sever is installed and configured in the environment.
- C、Ensure Server Plus Pack option has been installed and configured.
- D、Ensure Software Distribution has been installed on the IBM Director Server and an image has been created.
- E、Ensure Remote Deployment Manager has been installed on the IBM Director Server and an image has been created.
正确答案:B,E
第6题：
You are the network administrator for The company contains of a main office and five branch offices. Network servers are installed in each office. All servers run 2003The technical support stuff is located in the main office. Users in the branch office do not have the "Log on locally" right on local servers.Servers in the branch office collect auditing information.You need the ability to review the ability to review the auditing information located on each branch office server while you are working at the main office. You also need to save the auditing information on each branch office server on the local hard drive.Which two actions should you perform?（） (Each correct answer presents part of the solution. Choose two.)
A. From the Security Configuration and Analysis snap-in save the appropriate .inf file on the local hard drive.
B. Solicit Remote Assistance from each branch office server.
C. From Computer Management open Event Viewer, save the appropriate .evt file on the local hard drive
D. Run secedit.exe, specify the appropriate parameter
E. Establish a Remote Desktop client session with each branch office server
第7题：
A customer server has the maximum local storage installed. The customer plans to share this new storage with other servers. Which of the following provides that server additional storage？（）
- A、Add External Storage via EXP3000
- B、Replace current storage with more dense drives
- C、Add External Storage via SAN
- D、Add storage expansion blade
正确答案:C
第8题：
You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.
You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.
Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
A．Set the database load state for each destination server to No recovery mode.
B．Set the database load state for each destination server to standby mode.
C．Enable the allow database to assume primary role option for both destination servers.
D．Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.
E．Disable the allow database to assume primary role option for both destination servers.
解析：Explanation:B:Astandbyservercanbemaintainedtotaketheplaceoftheprimaryproductionserver,ifneeded.AstandbyserverisasecondarySQLServerinstallationthatiskeptup-to-datewithaprimarySQLServerinstallationthroughtheapplicationoftransactionlogbackupfiles.Youcanautomatetheprocessofmaintainingastandbyserverbycreatingbackup,copy,andrestorejobsthatareperiodicallyexecutedbySQLServerAgentontheprimaryserverandonthestandbyserver.Thisautomatedprocessiscalledlogshipping.Ifyouwantthedestinationdatabasetobeviewableforread-onlyqueries,youmustselecttheStandbyModeoption,thedefaultistheNoRecoveryModeoption.TheStandbymodespecifiesthatthesecondarydatabasebemadeavailableforuse,butinread-onlymode.E:Wedon'twantuserstoaddanydataonFLPSQL02orFLPSQL03.Thereforeweshoulddisabletheallowdatabasetoassumeprimaryroleoptionforthem.IfthisoptionwereenabledFLPSQL02andFLPSQL03wouldbeabletobeusedassourceservers.IncorrectAnswers:A:Thenorecoverymodespecifiesthatthesecondarydatabasebemadeunavailableforuse.WeneedstandbymodesincewewantFLPSQL02andFLPSQL03usedforqueriesandreports.Note:TheactiveportionofthetransactionlogontheprimaryservercanbebackedupusingtheNORECOVERYbackupoption.Thisoptionleavestheprimarydatabaseinrecoverymode.Whentheprimaryserverisreadytobebroughtbackonline,thetransactionlogsfromthestandbyserver(fortheperiodthatuserswereusingthestandbyserverastheprimaryserver)canbeappliedtotheprimaryserver.Thisavoidsthenecessityofapplyingacompletedatabasebackupandallapplicabletransactionlogstorestoretheprimaryserver.Theresultisasignificantdecreaseinthetimerequiredtobringtheprimaryserverbackonline.C:Theprimaryroleoptionmustbedisabledforbothdestinationservers.Ifnottheywouldbeabletochangeandupdatedata.D:Theprimaryroleoptionmustbedisabledforbothdestinationservers.Ifnottheywouldbeabletochangeandupdatedata.
第9题：
A technical consultant needs to deploy a Microsoft Windows 2003 server image from a single x336 to five new x336 servers using Remote Deployment Manager （RDM）. After installing and configuring RDM and loading the installation image， the consultant wants to deploy the first server. After the new x336 is booted， it is unable to connect to the RDM server. Which of the following is the most likely cause of the problem？（）
- A、The new server is not PXE-enabled.
- B、The RDM agent is not configured on the RDM server.
- C、The IBM Director agent is not installed on the new server.
- D、A DHCP server is not installed or configured the network.
正确答案:D
第10题：
Which two statements regarding external authentication servers for firewall user authentication are true?（） (Choose two.)
- A、Up to three external authentication server types can be used simultaneously.
- B、Only one external authentication server type can be used simultaneously.
- C、If the local password database is not configured in the authentication order, and the configured authentication server bypassed.
- D、If the local password database is not configured in the authentication order, and the configured authentication server authentication is rejected.
正确答案:B,D