11.
You have recently removed a SQL 2012 Database Engine instance from a computer
running the Windows Server 2008 R2 operating system. Prior to the removal of the
instance, you had configured affinity so that the default instance used CPU 0 and 1 and
the second instance used CPU 2 and 3. You want to ensure that the default instance
can use all processors available to the host. Which of the following commands would
you use to accomplish this goal?
- A.ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = AUTO
- B.ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 2,3
- C.ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,1
- D.ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,4
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct: The ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU =
AUTO statement will configure the instance to use all available processors. B. Incorrect: The ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 2,3 statement will configure the instance to use processors 2 and 3 instead of all available processors. C. Incorrect: The ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,1 statement will configure the instance to use processors 0 and 1 instead of all available processors. D. Incorrect: The ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,4 statement will configure the instance to use processors 0 and 4 instead of all available processors. |
12.
You have run the following command on a SQL Server 2012 default instance:
EXEC sys.sp_configure 'show advanced options', 1;
GO
Which of the following commands must you run to configure the instance so that the maximum amount of memory the instance uses does not exceed 4,096 GB? (Each answer presents part of a complete solution. Choose two.)
EXEC sys.sp_configure 'show advanced options', 1;
GO
Which of the following commands must you run to configure the instance so that the maximum amount of memory the instance uses does not exceed 4,096 GB? (Each answer presents part of a complete solution. Choose two.)
- A.RECONFIGURE;
GO - B.EXEC sys.sp_configure 'min server memory', 1024;
GO - C.EXEC sys.sp_configure 'min server memory', 4096;
GO - D.EXEC sys.sp_configure 'max server memory', 4096;
GO
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
|
A. Correct: You need to execute the statement: RECONFIGURE; GO To reconfigure the instance to use the new maximum server memory setting. B. Incorrect: You should not execute the statement: EXEC sys.sp_configure 'min server memory', 1024; GO This statement configures the minimum rather than the maximum instance memory. C. Incorrect: You should not execute the statement: EXEC sys.sp_configure 'min server memory', 4096; GO This statement configures the minimum rather than the maximum instance memory. D. Correct: You need to execute the statement: EXEC sys.sp_configure 'max server memory', 4096; GO This statement correctly configures the maximum instance memory. |
13.
You want to ensure that disk input/output operations of an instance are bound to a
specific processor. Which of the following would you configure to accomplish this goal?
- A.Minimum server memory
- B.Maximum server memory
- C.Processor affinity
- D.I/O affinity
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
|
A. Incorrect: Minimum server memory enables you to specify a minimum amount of
memory allocated to the instance. B. Incorrect: Maximum server memory enables you to specify a maximum amount of memory allocated to the instance. C. Incorrect: Processor affinity enables you to bind instance CPU traffic to specific processes but not to disk I/O activity. D. Correct: I/O affinity enables you to bind disk input/output operations to a specific processor. |
14.
You want to ensure that all future databases created on a SQL 2012 instance are
configured to Auto Shrink. Which of the following system databases do you modify to
accomplish this goal?
- A.master
- B.model
- C.msdb
- D.tempdb
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
|
A. Incorrect: The master system database records all system-level information. B. Correct: The model system database is used as a template for all newly created databases. C. Incorrect: The msdb system database is used by SQL Server Agent for scheduling alerts and jobs. D. Incorrect: The tempdb system database holds temporary objects and intermediate result sets. |
15.
Which stored procedure do you use to enable Database Mail on an instance?
- A.sp_monitor
- B.sp_configure
- C.sp_rename
- D.sp_depends
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct: You use sp_configure to enable Database Mail on an SQL instance. B. Incorrect: Use the sp_rename stored procedure to change the name of a usercreated object in the current database. C. Incorrect: Use the sp_monitor stored procedure to display statistics about SQL Server. D. Incorrect: Use the sp_depends stored procedure to display information about database object dependencies. |
|
|
||||||||||||||||||||||||||||
