READ Free Dumps For Microsoft- 70-462
| Question ID 18823 | You administer a Microsoft SQL Server 2012 server that has multiple databases.
You need to ensure that users are unable to create stored procedures that begin with sp_.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
|
| Option A | Answer :
|
| Correct Answer | A |
Explanation
| Question ID 18824 | You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores.
You discover performance issues when large amounts of data are written to tables under
heavy system load.
You need to limit the number of cores that handle I/O.
What should you configure?
|
| Option A | Processor affinity
|
| Option B | Lightweight pooling
|
| Option C | Max worker threads
|
| Option D | I/O affinity
|
| Correct Answer | D |
Explanation Explanation: Explanation/Reference: http://msdn.microsoft.com/en-us/library/ms189629.aspx