16.
You want to cycle the SQL Server Agent error log. From which of the following system
databases must you run the sp_cycle_agent_errorlog stored procedure to accomplish
this goal?
- A.master
- B.msdb
- C.model
- D.tempdb
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
|
A. Incorrect: You must run the sp_cycle_agent_errorlog stored procedure from the
msdb system database rather than from the master system database. B. Correct: You must run the sp_cycle_agent_errorlog stored procedure from the msdb system database to rotate the SQL Server Agent error log file. C. Incorrect: You must run the sp_cycle_agent_errorlog stored procedure from the msdb system database rather than from the model system database. D. Incorrect: You must run the sp_cycle_agent_errorlog stored procedure from the msdb system database rather than from the tempdb system database. |
17.
Which feature should you enable and configure so session requests addressed to
a specific instance can be allocated different processor resources based on session
request properties?
- A.Resource Governor
- B.Windows System Resource Manager
- C.Processor affinity
- D.I/O affinity
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct: Resource Governor enables you to allocate session requests to different
resources based on the characteristics of the session request properties. B. Incorrect: WSRM enables you to allocate different resources to different instances but does not enable you to allocate different resources based on session requests. C. Incorrect: Processor affinity enables you to configure the instance to use specific processors but does not enable you to differentiate resources based on session request properties. D. Incorrect: I/O affinity enables you to configure disk I/O to occur by using a specific processor but does not allow you to differentiate resources based on session request properties. |
18.
What is the maximum number of SQL Server 2012 Enterprise edition Database Engine
instances that you can deploy on a non-clustered server running Windows Server 2008
R2 Enterprise edition?
- A.10
- B.25
- C.50
- D.100
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
|
A. Incorrect: You can deploy a maximum of 50 SQL Server 2012 Database Engine
instances on a non-clustered server running Windows Server 2008 R2 Enterprise. Ten instances is fewer than 50. B. Incorrect: You can deploy a maximum of 50 SQL Server 2012 Database Engine instances on a non-clustered server running Windows Server 2008 R2 Enterprise. A 25-instance limit applies to deployment on clustered hosts. Twenty-five instances in a non-clustered environment is fewer than 50. C. Correct: You can deploy a maximum of 50 SQL Server 2012 Database Engine instances on a non-clustered server running Windows Server 2008 R2 Enterprise. D. Incorrect: You can deploy a maximum of 50 SQL Server 2012 Database Engine instances on a non-clustered server running Windows Server 2008 R2 Enterprise. One hundred instances exceeds this value. |
19.
You have configured Resource Governor with three resource pools. You have assigned
the first resource pool a minimum CPU and memory value of 20%. You have assigned
the second resource pool a minimum CPU and memory value of 30%. You want to
assign maximum CPU and memory values to the third resource pool. What is the maximum
CPU and memory value you can assign to this resource pool?
- A.30%
- B.50%
- C.70%
- D.100%
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
|
A. Incorrect: The maximum resource value assigned to the third pool is 100%; the
sum of the minimum resource values assigned to the other pools is 50%. Thirty
percent is less than this value. B. Correct: The maximum resource value assigned to the third pool is 100%; the sum of the minimum resource values assigned to the other pools is 50%. C. Incorrect: The maximum resource value assigned to the third pool is 100%; the sum of the minimum resource values assigned to the other pools is 50%. You cannot assign 70% to this pool. D. Incorrect: The maximum resource value assigned to the third pool is 100%; the sum of the minimum resource values assigned to the other pools is 50%. You cannot assign 100% to this pool. |
20.
A server that has four processors has three SQL Server 2012 Database Engine instances
installed. Which feature should you configure to assign 60% of a host server’s processor
resource to the first instance, 20% to the second instance, and 15% to the third
instance?
- A.Resource Governor
- B.Windows System Resource Manager
- C.Processor affinity
- D.I/O affinity
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
|
A. Incorrect: You can use Resource Governor to assign resources only from within an
instance. You cannot use it to assign resources across instances. B. Correct: You can use WSRM to assign processor resources to different instances. C. Incorrect: Although you can use processor affinity to assign resources, by using processors it is only possible to assign resources to instances in lots of 25% of the total CPU bandwidth. This does not meet the requirements of the question; hence, you should use WSRM. D. Incorrect: I/O affinity enables you to assign dedicated processors to disk I/O. You can’t use this for distributing CPU bandwidth across instances. |
|
|
||||||||||||||||||||||||||||
