Optimize database performance
4 practice questions under this official exam objective (DP-800) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
SQL Database Blocking and RCSI in Microsoft Fabric
This scenario analyzes a blocking chain in Microsoft Fabric SQL using DMVs, leveraging Read Committed Snapshot Isolation (RCSI) to determine that SELE
Azure SQL Blocking from Sleeping Session with Open Transaction
Identifies the root cause of blocking in Azure SQL when a sleeping session holds an open transaction. The correct answer is C because the DMV evidence
Optimizing Azure SQL Dashboard Queries with Nonclustered Indexes
This exam question focuses on resolving slow dashboard queries in Azure SQL Database by implementing an appropriate nonclustered index. The correct so
How Should You Partition Table1 by Year in Azure SQL?
This DP-800 hotspot asks how to partition a 25-million-row Azure SQL table by calendar year so maintenance can target individual partitions. The corre