What should you recommend?

Correct Answer for the following Question is given below

You have a query that is used by a reporting dashboard.Users report that the query sometimes takes a long time to run. You need to recommend a solution to identify what is causing the issue.What should you recommend?More than one answer choice may achieve the goal. Select the BEST answer.Step 1: Turn on the blocked process report. This will look for any blocking taking 20 seconds or longer.–Make sure you don’t have any pending changesSELECT *FROM sys.configurationsWHERE value <> value_in_use;GO exec sp_configure ‘show advanced options’, 1;GORECONFIGUREGO exec sp_configure ‘blocked process threshold (s)’, 20;GORECONFIGUREGOStep 2: Set up a trace to capture the blocked process report. Run it as a server side trace. blocked process threshold Server Configuration Option


What should you recommend?


Set the blocked process threshold, and then run SQL Server Profiler.

Set the blocked process threshold, and then create an alert.

Enable trace flag 1204, and then create an alert.

Create a job that queries the sys.dm_os_waiting_tasks dynamic management view.

Correct Answer

The Correct Answer for this Question is

Set the blocked process threshold, and then create an alert.


The Question – What should you recommend? has been answered correctly and answers for the question is Set the blocked process threshold, and then create an alert.

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment