You need to configure monitoring for Tailspin Toys

HOTSPOT
Note: This question is part of a series of questions that use the same scenario. For your convenience, the
scenario is repeated in each question. Each question presents a different goal and answer choices, but the text
of the scenario is exactly the same in each question in this series.
You are a database administrator for a company that has an on-premises Microsoft SQL Server environment
and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each
customer uses a dedicated instance. The environments that you manage are shown in the following table.

You need to configure monitoring for Tailspin Toys.
In the table below, identify the monitoring tool that you must use for each activity.
NOTE: Make only one selection in each column.
Hot Area:

HOTSPOT
Note: This question is part of a series of questions that use the same scenario. For your convenience, the
scenario is repeated in each question. Each question presents a different goal and answer choices, but the text
of the scenario is exactly the same in each question in this series.
You are a database administrator for a company that has an on-premises Microsoft SQL Server environment
and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each
customer uses a dedicated instance. The environments that you manage are shown in the following table.

You need to configure monitoring for Tailspin Toys.
In the table below, identify the monitoring tool that you must use for each activity.
NOTE: Make only one selection in each column.
Hot Area:

Answer:

Explanation:
Monitoring from application: Transact-SQL
Transact-SQL can be used to monitor a customized application.
Trend analysis: System Monitor
System Monitor can provide trend analysis.
From question

https://docs.microsoft.com/en-us/sql/relational-databases/performance/performance-monitoringand-tuning-tools



Leave a Reply 0

Your email address will not be published. Required fields are marked *