DP-300 Certification Practice Question #118

Question

You have an Azure SQL database named db1.
You need to retrieve the resource usage of db1 from the last week.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To query resource usage for an Azure SQL database from the last week, we must use a view that retains historical data for at least 7 days. `sys.resource_stats` retains data for 14 days, whereas `sys.dm_db_resource_stats` only retains data for the last 60 minutes. Additionally, `sys.resource_stats` includes the columns `database_name` and `start_time`, which are referenced in the query's WHERE and ORDER BY clauses. To calculate the starting date boundary of seven days ago, we use the T-SQL function `DATEADD` with a negative offset of 7 days from the current date.

More DP-300 practice questions