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

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.

View Answer

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:

Tailspin Toys has a custom application that accesses a hosted database named TSpinDB. The application

will monitor TSpinDB and capture information over time about which database objects are accessed and

how frequently they are accessed.

References: https://docs.microsoft.com/en-us/sql/relational-databases/performance/performancemonitoring-

and-tuning-tools