A SQL SERVER RECENTLY SUFFERED FROM ALL CPUS RUNNING AT 100 PERCENT...

8. A SQL Server recently suffered from all CPUs running at 100 percent, which you found to be caused by a missing index. You fixed the problem, but you want to stop any new occurrences from saturating all CPUs. Which of these options would achieve this?A. Use sp_configure to set max degree of parallelismB. Use Configuration Manager to configure the SQL Server Service to use fewer CPUsC. Run the Database Tuning Advisor and apply any recommendationsD. Use sp_configure to set cost threshold for parallelism