A new storage array must be configured for a database server

题目
单选题
A new storage array must be configured for a database server. This array will store transaction logs that are always being written.  Which of the following RAID solutions would provide fault tolerance and fast write operations without the use of parity? ()
A

 RAID 0

B

 RAID 3

C

 RAID 6

D

 RAID 10

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()

  • A、More than one database is to be registered with the listener.
  • B、The users will connect the database by using the host naming method.
  • C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
  • D、The database that is to be registered with the listener is configured in shared server mode.
  • E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

正确答案:C,E

第2题:

An administrator needs to maintain 1TB of storage space for a server. A performance critical application will use this storage space for a database. The database will be replicated between multiple servers. Cost and performance are the most important considerations. Which of the following RAID configurations would be the BEST choice for the storage array?()

  • A、RAID 6 with six 250GB hard drives
  • B、RAID 5 with five 250GB hard drives
  • C、RAID 0 with four 250GB hard drives
  • D、RAID 10 with eight 250GB hard drives

正确答案: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.


正确答案:A
解析: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题:

You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single site named KingSite1.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging  solution.Company.com has recently configured the mailbox server as members of a database availability group (DAG) with a public folder database. During the course of the business week you receive instruction from Company.com to create a new Active Directory site and install Exchange server in the site whilst ensuring the public folders are stored on servers in both sites. What should you do?()

  • A、You should consider having clustered continuous replication (CCR) configured on two servers in the new site.You should then have the replication settings for all public folder databases modified.
  • B、You should consider having the standby continuous replication (SCR) configured on a server in the new site.You should then have the Enable-StorageGroupCopy cmdlet run from a server in the new site.
  • C、You should consider having a public folder database created on a server in the new site.You should then have the replication settings for all public folders modified.
  • D、You should consider having a public folder database created on a server in the new site.You should then have the set-DatabaseAvailabilityGroup cmdlet run from a server in the new site.

正确答案:C

第5题:

A new storage array must be configured for a database server. This array will store transaction logs that are always being written. Which of the following RAID solutions would provide fault tolerance and fast write operations without the use of parity?()

  • A、RAID 0
  • B、RAID 3
  • C、RAID 6
  • D、RAID 10

正确答案:D

第6题:

A new switch is installed in the Testking network. This switch is to be configured sothat VLAN information will be automatically distributed to all the other Cisco Catalyst switches in the network. Which of the conditions below have to be met in order for this to occur?()

  • A、The switch that will share the VLAN information must be in the VTP Server mode.
  • B、The switches must be in the same VTP domain.
  • C、The switch that will share the VLAN information must be configured as the root bridge.
  • D、The switches must be configured to use the same VTP version.
  • E、The switches must be configured to use the same STP version.
  • F、The switches must be configured to use the same type of ID tagging.
  • G、The switches must be connected over VLAN trunks.

正确答案:A,B,F

第7题:

A new server must be configured to provide fault tolerant connectivity to the DMZ and the backend database. Which of the following is the MOST cost effective way to accomplish this?()

  • A、A total of six NICs: two pairs of teamed NICs for the DMZ and two NICs for the backenddatabase.
  • B、One NIC can be configured with VLANs for the DMZ and backend database.
  • C、A total of eight NICs to be teamed with the appropriate VLANs configured for the DMZ andbackend database.
  • D、A total of four NICs: two NICs for the DMZ and two NICs for the backend database.

正确答案:D

第8题:

The Cisco CRS Server must be configured to communicate and interoperate with the Cisco CallManager. Which two must be configured on the Cisco CRS Server?()

  • A、Application Management to load applications  
  • B、JTAPI Subsystem with the JTAPI Call Control Group  
  • C、Database Subsystem communication with LDAP Directory  
  • D、JTAPI Subsystem with the JTAPI provider  

正确答案:B,D

第9题:

A new array of hard drives has been added to an existing server; however, when the server is booted into the Windows OS the new drives fail to appear in My Computer.  From which of the following locations can the new storage drives be added?()

  • A、 Format command
  • B、 Hypervisor
  • C、 Computer Management
  • D、 Disk Management
  • E、 Virtual Center

正确答案:C,D

第10题:

You have an Exchange Server 2010 organization. You plan to deploy two new Mailbox servers.  Both Mailbox servers will be members of a database availability group (DAG). You need to recommend a hard-disk configuration for the new servers. Your recommendation must meet the following requirements:.Maximize write performance .Prevent a switchover if a single disk fails Which disk configuration should you recommend?()

  • A、RAID 0 array
  • B、RAID 1 array
  • C、RAID 5 array
  • D、RAID 10 array

正确答案:D

更多相关问题