MS SQL Server - 79 - Performance Monitoring Tool Part 2 MCQ

79 – Performance Monitoring Tool Part 2 MCQ

1 / 25

1. Which tool in SQL Server allows you to manage and optimize the performance of your queries by tracking query execution statistics?

Query Store

Performance Data Collector

Live Query Statistics

Resource Governor

2 / 25

2. What is the primary function of the Query Store in SQL Server?

To manage hardware resources

To capture and analyze query performance data

To manage database schemas

To automatically optimize queries

3 / 25

3. Which SQL Server tool can automatically apply query performance recommendations to improve database performance?

Live Query Statistics

Resource Governor

Performance Data Collector

Automatic Tuning

4 / 25

4. In SQL Server, what is the primary role of the Performance Data Collector?

To manage hardware resources

To manage database schemas

To capture and store performance-related data

To automatically optimize queries

5 / 25

5. What does the Resource Governor in SQL Server primarily focus on?

Automatically tuning queries

Managing memory allocation

Monitoring query execution statistics

Managing disk space

6 / 25

6. Which tool in SQL Server provides real-time query execution statistics and graphical representation?

Performance Data Collector

Automatic Tuning

Live Query Statistics

Query Store

7 / 25

7. What is the main advantage of using Query Store in SQL Server for query optimization?

It captures and retains query performance history.

It provides automatic query optimization.

It optimizes disk storage.

It manages hardware resources.

8 / 25

8. Which tool in SQL Server allows you to define and manage resource allocation for different workloads?

Automatic Tuning

Resource Governor

Performance Data Collector

Query Store

9 / 25

9. In SQL Server, what is the primary purpose of Live Query Statistics?

To capture and analyze query performance data

To automatically optimize queries

To provide real-time query execution information

To manage hardware resources

10 / 25

10. What is the primary goal of Automatic Tuning in SQL Server?

To capture and store performance-related data

To manage hardware resources

To provide real-time query execution statistics

To automatically optimize queries for better performance

11 / 25

11. Which tool in SQL Server allows you to capture and store performance-related data for analysis?

Query Store

Performance Data Collector

Resource Governor

Live Query Statistics

12 / 25

12. What does the Resource Governor tool in SQL Server help you manage?

Memory allocation for workloads

Disk space utilization

Query performance history

Hardware resources

13 / 25

13. In SQL Server, how does the Query Store assist in query performance optimization?

It optimizes CPU usage.

It captures and retains query performance history.

It manages disk storage efficiently.

It provides automatic query optimization.

14 / 25

14. Which SQL Server tool provides recommendations for automatic query performance tuning?

Performance Data Collector

Query Store

Automatic Tuning

Resource Governor

15 / 25

15. What is the primary function of Live Query Statistics in SQL Server?

To manage hardware resources

To capture and display real-time query execution statistics

To provide automatic query optimization

To optimize disk storage

16 / 25

16. In SQL Server, which tool allows you to monitor and control the allocation of CPU and memory resources to different workloads?

Automatic Tuning

Resource Governor

Performance Data Collector

Query Store

17 / 25

17. What is the primary role of the Performance Data Collector in SQL Server?

To manage database schemas

To automatically optimize queries

To manage hardware resources

To capture and store performance-related data

18 / 25

18. Which tool in SQL Server provides graphical representation of query execution plans and statistics?

Automatic Tuning

Resource Governor

Query Store

Live Query Statistics

19 / 25

19. In SQL Server, what is the main benefit of using Automatic Tuning?

It automatically applies query performance recommendations.

It manages hardware resources efficiently.

It captures and retains query performance history.

It provides real-time query execution statistics.

20 / 25

20. Which tool in SQL Server helps you track and analyze query performance history?

Resource Governor

Performance Data Collector

Query Store

Live Query Statistics

21 / 25

21. What is the primary goal of the Resource Governor in SQL Server?

To provide real-time query execution statistics

To manage hardware resources

To capture and retain performance-related data

To automatically optimize queries

22 / 25

22. In SQL Server, which tool provides recommendations for index optimization?

Performance Data Collector

Query Store

Resource Governor

Automatic Tuning

23 / 25

23. What is the primary function of Live Query Statistics in SQL Server?

To manage hardware resources

To optimize disk storage

To capture and display real-time query execution statistics

To provide automatic query optimization

24 / 25

24. Which tool in SQL Server helps you manage and optimize query execution plans?

Query Store

Automatic Tuning

Live Query Statistics

Performance Data Collector

25 / 25

25. In SQL Server, which tool is focused on monitoring and controlling resource allocation for workloads?

Query Store

Resource Governor

Performance Data Collector

Automatic Tuning

Your score is

MS SQL Server – 79 – Performance Monitoring Tool Part 2 MCQ