You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has eight quad-core processors and 128-GB RAM. Four different applications use the instance. The instance experiences a low number of CXPACKET waits. The instance also experiences a large number of lazy writer waits. You need to optimize the performance of the instance. What should you do?()A、Configure the Resource Governor. B、Configure the Windows System Resource Manager. C、Configure software non-uniform memory access (soft-NUMA).D、Configure an increase in the maximum degree of parallelism option.

You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has eight quad-core processors and 128-GB RAM. Four different applications use the instance. The instance experiences a low number of CXPACKET waits. The instance also experiences a large number of lazy writer waits. You need to optimize the performance of the instance. What should you do?()

  • A、Configure the Resource Governor. 
  • B、Configure the Windows System Resource Manager. 
  • C、Configure software non-uniform memory access (soft-NUMA).
  • D、Configure an increase in the maximum degree of parallelism option.

相关考题:

A crew member is unconscious and the face is flushed. You should ______.A.lay the crew member down with the head and shoulders slightly raisedB.administer a liquid stimulantC.lay the crew member down with the head lower than the feetD.attempt to stand the crew member upright to restore consciousness

You administer your company‘s network. All client computers run Microsoft Windows Vista. A standard user reports that they are unable to install an application. You need to install the applicatin.What should you do?()A.AB.BC.CD.D

You are the network administrator for . In particular you administer a Windows 2003 server named TestKing13. You need to use Disk Management to configure a partition on TestKing13.When you attempt to access Disk Management, you receive the following error message:Unable to connect Logical Disk Manager service.You verify that the Logical Disk Manager service is started.What is the most likely cause of the problem?()A. There is not enough available space on the boot partition.B. The disk performance counters are disabled.C. The Logical Disk Manager Administrative service is disabled.D. The Windows 2003 Administration Tools Pack is not installed

A shipmate suffers a heart attack and stops breathing. You must ______.A.administer oxygenB.immediately check his pulse and start CPRC.make the victim comfortable in a bunkD.immediately give a stimulant,by force if necessary

A shipmate chokes suddenly,cannot speak,and starts to turn blue. You should ______.A.perform the Heimlich maneuverB.make the victim lie down with the feet elevated to get blood to the brainC.immediately administer CPRD.do nothing until the victim becomes unconscious

You are attempting to administer CPR to a victim.When you blow into his mouth it is apparent that no air is getting into the lungs.What should you do ________.A.Blow harder to force the air past the tongueB.Raise the victim's head higher than his feetC.Press on the victim's lungs so that air pressure will blow out any obstructionD.Re-tip the head and try again

If a crew member is exposed to phenol by way of skin or eye contact, you should IMMEDIATELY ______.A.administer oxygenB.treat victim for shockC.flush skin and eyes with waterD.give victim stimulant

You’re a network administer and you issue the command (show port 3/1) on an Ethernet port. Toyour surprise you notice a non-zero entry in the ’Giants’ column. What could be the cause of this?()A、IEEE 802.1QB、IEEE 802.10C、Misconfigured NICD、User configurationE、All of the above

You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database

You administer a SQL Server 2008 instance. The instance is located on a four-processor, quad-core server. The server frequently experiences CPU pressure. The instance contains a very large mission-critical database that is used continuously. You need to ensure that online index rebuilds do not consume all available CPU cycles. Which configuration option should you use?()A、affinity maskB、affinity I/O mask C、max degree of parallelismD、optimize for ad hoc workloads

You install a read-only domain controller (RODC) named RODC1.   You need to ensure that a user named User1 can administer RODC1. The solution must minimize the number of permissions assigned to User1.   Which tool should you use()A、Active Directory Administrative CenterB、Active Directory Users and ComputersC、DsaddD、Dsmgmt

You administer 80 computers that run Windows 7. The computers have static IP addresses. You need tochange the static IP addresses on all the computers by using a startup script.  Which command should youinclude in the startup script ?()A、Ipconfig.exeB、Nbtstat.exeC、Netstat.exeD、Netsh.exe

You have three computers that run Windows 7. You use Windows PowerShell to perform remote administration tasks on all three computers. You need to remotely administer all three  computers by usingPowerShell.  Which PowerShell cmdlet should you use?()A、Enable-PSRemotingB、Enable-PSSessionConfigurationC、New-PSDriveD、New-PSSession

You have a server that runs Windows Server 2008. The server has the Web Server (IIS) server role installed and all the Web Server role services installed.  You need to provide a user the ability to administer a Web site. Which feature should you configure?()A、Net RolesB、Net UsersC、AuthenticationD、IIS Manager Permissions

You are the network administrator for . You administer a Windows Server 2003 computer named TestKing7. Users report that they experience poor performance when they access resources located on TestKing7. You suspect a disk bottleneck. You need to set up performance counters to monitor TestKing7. You need to decide which performance objects to monitor. Which two counters should you choose? ()(Each correct answer presents part of the solution. Select two.)A、LogicalDisk/%IdleTimeB、PhysicalDisk/%DiskTimeC、PhysicalDisk/Avg.DiskQueueLengthD、Memory/WriteCopies/secE、Memory/CommitLimit

单选题You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface:  SQL EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =’group1’, COMMENT = ’New Group’);  This command errorsout displaying the following message:  ERROR at line 1:  ORA-01031: insufficient privileges  ORA-06512: at "SYS.DBMS_RMIN", line 115  ORA-06512: at SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1  What action would you take to overcome this error?()A grant SYSDBA to the userB grant SYSOPER to the userC grant the RESOURCE role to the userD use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the useE grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

单选题A shipmate chokes suddenly,cannot speak,and starts to turn blue. You should().Aperform the Heimlich maneuverBmake the victim lie down with the feet elevated to get blood to the brainCimmediately administer CPRDdo nothing until the victim becomes unconscious

单选题You need to ensure that Admin1 can administer the Web servers to meet the companys technical requirements.To which group should you add Admin1?()Athe Administrators local group on each Web serverBthe Backup Operators domain local groupCthe Backup Operators local group on each Web serverDthe Domain Admins global group

单选题You administer a Windows 2000 Professional computer that is shared by a couple of employees. During one of your sessions at the computer, you notice that one of the other users has installed hardware drivers that have caused the computer to become unstable. You want to determine which of these newly installed drivers are not included in the Hardware Compatibility List (HCL). What should you do? ()ARun the sysprep tool with the -pnp and -noreboot options on the computer.BRun the File Signature Verification tool on the computer.CRun the System File Checker tool on the computer.DConfigure driver signing to prevent the installation of unsigned drivers.

单选题You are the network administrator for . In particular you administer a Windows 2003 server named TestKing13. You need to use Disk Management to configure a partition on TestKing13. When you attempt to access Disk Management, you receive the following error message: "Unable to connect Logical Disk Manager service." You verify that the Logical Disk Manager service is started. What is the most likely cause of the problem?()AThere is not enough available space on the boot partition.BThe disk performance counters are disabled.CThe Logical Disk Manager Administrative service is disabled.DThe Windows 2003 Administration Tools Pack is not installed

单选题You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()ASQL*PlusBiSQL*PlusCManagement ServerDManagement RepositoryEOracle Enterprise Manager 10g Database Control

多选题You work as a database administrator for Supportcenter.cn. You want to administer your database servers, which are running on different host machines, using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()AApplication Server ControlBOracle Management ServiceCOracle Enterprise Manager RepositoryDOracle Enterprise Manager Database Control

单选题You’re a network administer and you issue the command (show port 3/1) on an Ethernet port. Toyour surprise you notice a non-zero entry in the ’Giants’ column. What could be the cause of this?()AIEEE 802.1QBIEEE 802.10CMisconfigured NICDUser configurationEAll of the above

单选题You administer 80 computers that run Windows 7. The computers have static IP addresses. You need tochange the static IP addresses on all the computers by using a startup script.  Which command should youinclude in the startup script ?()AIpconfig.exeBNbtstat.exeCNetstat.exeDNetsh.exe

单选题You are the network administrator for TestKing.com. The network consists of a single Active Directory domain named testking.com. All network servers run Windows Server 2003. You create an organizational unit (OU) named Engineering, which will hold all objects associated with the users and computers in the engineering department. You also create a global group named Engineering Admins, whose members will administer these objects. Now you need to assign the appropriate permissions to the Engineering Admins group so its members can administer the objects in the Engineering OU. First, you use Active Directory Users and Computers to view the properties of the Engineering OU. However, the Security tab is not available. What should you do next?()AConvert the system partition to NTFS.BEnable the Advanced Features option in the View menu of Active Directory Users and Computers.CEnable the Users, Groups, and Computers as Containers option in the View menu of Active Directory Users and Computers.DLog on by using a user account that has Administrator permissions for the Engineering OU.

单选题You administer a SQL Server 2008 instance. The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data. You need to store the sensitive data in the most secure manner possible. You also need to ensure that you minimize the usage of memory space and processor time. Which encryption type should you use?()ASymmetric key encryptionBAsymmetric key encryptionCCertificate-based encryptionDTransparent data encryption

单选题You have three computers that run Windows 7. You use Windows PowerShell to perform remote administration tasks on all three computers. You need to remotely administer all three  computers by usingPowerShell.  Which PowerShell cmdlet should you use?()AEnable-PSRemotingBEnable-PSSessionConfigurationCNew-PSDriveDNew-PSSession

单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A target databaseB auxiliary databaseC third-party databaseD recovery catalog database