Developing SQL Databases — Question 163

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You need to collect data from the following two sources:
✑ The performance counters of the operating system
✑ Microsoft SQL Server events
You must analyze the two datasets side-by side by using a single tool.
Solution: You use dynamic management views and SQL Server Profiler to collect performance data. You use SQL Server Management Studio (SSMS) to analyze the data.
Does this meet the goal?

Answer options

Correct answer: A

Explanation

The correct answer is 'Yes' because using dynamic management views and SQL Server Profiler allows for effective collection of performance data from both the operating system and SQL Server events. Additionally, SQL Server Management Studio (SSMS) provides a robust environment for analyzing this data side by side, thereby meeting the goal stated in the question. The alternative option 'No' is incorrect as it does not acknowledge the effectiveness of the proposed tools in meeting the requirements.