Câu 47: 70-764: Administering a SQL Database Infrastructure

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 monitor WingDB and gather information for troubleshooting issues. What should you use?

1. A. sp_updatestats
2. B. sp_lock — đáp án hiện tại
3. C. sys.dm_os_waiting_tasks
4. D. sys.dm_tran_active_snapshot_database_transactions
5. E. Activity Monitor