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 mask
B: affinity I/O mask
C: max degree of parallelism
D: optimize for ad hoc workloads
A: affinity mask
B: affinity I/O mask
C: max degree of parallelism
D: optimize for ad hoc workloads
举一反三
- 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 mask B: affinity I/O mask C: max degree of parallelism D: optimize for ad hoc workload
- 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 thatyou minimize the usage of memory space and processor time. Which encryption type should you use?() A: Symmetric key encryption B: Asymmetric key encryption C: Certificate-based encryption D: Transparent data encryption
- You install Windows Server 2008 R2 (Server Core Installation) on a server. The server will store virtual machines (VMs) on a volume that is attached to the server by means of an iSCSI connection. You need to configure the server so that VMs can be stored on the iSCSI volume. Which two commands should you run?() A: iscsicli listTarget B: iscsicli qaddTarget C: iscsicli qloginTarget D: iscsicli AddConnection
- You have a Windows Server 2008 R2 Hyper-V server. You need to ensure that you are prompted to specify a custom snapshot name when you create a snapshot. What should you use to create the snapshot?() A: Hyper-V Manager B: Windows Server Backup C: the Virtual Machine Connection window D: the Backup command-line tool (also known as wbadmin.exe)
- You have an Exchange Server 2010 Mailbox server.The server is a member of a database availability group (DAG).The server fails.You install the operating system on a new server and use the same computer name.You join the server to the domain.You need to reinstall Exchange Server 2010 on the server.The solution must ensure that previous Exchange server configurations are applied to the new server.What should you do?()