Which two actions should you recommend?

Correct Answer for the following Question is given below

A Windows Azure application connects to a SQL Azure database.Connections to the database are being dropped due to throttling.You need to recommend an approach for identifying the root cause of the problem. Which two actions should you recommend?(Each correct answer presents part of the solution. Choose two.)Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.There are two types of dynamic management views and functions:Server-scoped dynamic management views and functions. These require VIEW SERVER STATE permission on the server.Database-scoped dynamic management views and functions. These require VIEW DATABASE STATE permission on the database.

Question:

Which two actions should you recommend?

Options:

Use Dynamic Management Views to analyze performance issues.

Decrease the connection timeout in the database connection string.

Make sure the application is closing database connections that are not needed.

Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.

Correct Answer

The Correct Answer for this Question is

Use Dynamic Management Views to analyze performance issues.
Make sure the application is closing database connections that are not needed.

Explanation

The Question – Which two actions should you recommend? has been answered correctly and answers for the question is Use Dynamic Management Views to analyze performance issues.
Make sure the application is closing database connections that are not needed.

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