MS SQL Server - 78 - Performance Monitoring Tool Part 1 MCQ

78 – Performance Monitoring Tool Part 1 MCQ

1 / 25

1. When deciding which monitoring tool to use in SQL Server, what is the first step?

Select Database Engine Tuning Advisor

Choose SQL Server Profiler by default

Identify your specific monitoring requirements

Opt for Extended Events in all cases

2 / 25

2. SQL Server Profiler is primarily used for what purpose?

Disk system tuning

Database schema design

Query optimization

Monitoring and capturing events

3 / 25

3. Which tool in SQL Server is commonly used for monitoring and capturing events, such as queries and errors?

SQL Server Data Tools

Extended Events

SQL Server Configuration Manager

Database Engine Tuning Advisor

4 / 25

4. What is the primary function of SQL Server Profiler?

To monitor and capture SQL Server events and actions

To automatically optimize queries

To disable query optimization

To manage database schemas

5 / 25

5. In SQL Server, which tool is used for performance tuning and recommending index changes?

Database Engine Tuning Advisor

Extended Events

SQL Server Configuration Manager

SQL Server Profiler

6 / 25

6. What is the main purpose of Extended Events in SQL Server?

To optimize query execution plans

To recommend index changes

To manage database schemas

To monitor and capture server events with minimal overhead

7 / 25

7. When should you choose Extended Events over SQL Server Profiler for monitoring?

Always

When you need to monitor specific events with minimal performance overhead

When you need to automatically optimize queries

When you want to manage database schemas

8 / 25

8. SQL Server Profiler is commonly used for what type of monitoring?

Disk system tuning

Memory management

Monitoring specific server events and actions

CPU performance analysis

9 / 25

9. Which monitoring tool in SQL Server provides recommendations for query performance improvements?

SQL Server Profiler

Extended Events

Database Engine Tuning Advisor

SQL Server Configuration Manager

10 / 25

10. In SQL Server, what is the main advantage of Extended Events over SQL Server Profiler?

SQL Server Profiler is always the better choice.

Extended Events provides a more user-friendly interface.

Extended Events optimizes query execution plans.

Extended Events captures events with lower performance overhead.

11 / 25

11. What does Database Engine Tuning Advisor primarily focus on in SQL Server?

Managing database schemas

Disk system tuning

Recommending query performance improvements

Monitoring specific server events and actions

12 / 25

12. When is SQL Server Profiler a preferred choice for monitoring?

When automatic query optimization is needed

When minimal performance overhead is a top priority

When disk system tuning is the main concern

When managing database schemas is a requirement

13 / 25

13. Which tool is commonly used for monitoring and capturing events with minimal performance overhead in SQL Server?

SQL Server Profiler

Database Engine Tuning Advisor

Extended Events

SQL Server Configuration Manager

14 / 25

14. In SQL Server, which tool can recommend index changes to improve query performance?

Database Engine Tuning Advisor

SQL Server Profiler

SQL Server Configuration Manager

Extended Events

15 / 25

15. What is the primary goal of SQL Server Profiler?

To disable query optimization

To monitor and capture SQL Server events and actions

To optimize query execution plans

To manage database schemas

16 / 25

16. When should you choose Database Engine Tuning Advisor for performance tuning in SQL Server?

When you want to automatically optimize queries

When you need to monitor specific events with minimal performance overhead

When you want recommendations for query performance improvements

When you need to manage database schemas

17 / 25

17. In SQL Server, which tool allows you to capture events with lower performance overhead and more efficiency?

Database Engine Tuning Advisor

SQL Server Profiler

SQL Server Configuration Manager

Extended Events

18 / 25

18. What is the primary role of Database Engine Tuning Advisor in SQL Server?

To automatically optimize queries

To monitor and capture specific server events and actions

To manage database schemas

To recommend index changes for query performance improvements

19 / 25

19. SQL Server Profiler is best suited for which type of monitoring?

Monitoring specific server events and actions

Memory management

Disk system tuning

Query optimization

20 / 25

20. When should you consider using Extended Events in SQL Server?

When you want to disable query optimization

When you want recommendations for query performance improvements

When you need to monitor specific events with minimal performance overhead

When you want to manage database schemas

21 / 25

21. What does SQL Server Profiler focus on when monitoring server events and actions?

Query performance recommendations

Capturing events and actions

Disk system tuning

CPU performance analysis

22 / 25

22. Which tool is known for its ability to provide query optimization recommendations in SQL Server?

Extended Events

SQL Server Configuration Manager

Database Engine Tuning Advisor

SQL Server Profiler

23 / 25

23. In SQL Server, which monitoring tool is more resource-intensive, particularly when capturing events?

SQL Server Configuration Manager

SQL Server Profiler

Database Engine Tuning Advisor

Extended Events

24 / 25

24. What is the main advantage of using Extended Events over SQL Server Profiler?

SQL Server Profiler is always the better choice.

Extended Events captures events with higher performance overhead.

Extended Events captures events with lower performance overhead.

Extended Events provides a more user-friendly interface.

25 / 25

25. When should you consider using SQL Server Profiler for monitoring?

When you want to manage database schemas

When you want to optimize query execution plans

When you need recommendations for query performance improvements

When you need to monitor specific events with minimal performance overhead

Your score is

MS SQL Server – 78 – Performance Monitoring Tool Part 1 MCQ