Optimize database performance
7 practice questions under this official exam objective (DP-800), each with the answer key, an option-by-option explanation and instant feedback.
Questions under this objective
7 total · page 1 of 1SQL 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
Optimizing Azure SQL Reporting with Columnstore and Rowstore Indexes
Learn how to optimize Azure SQL database performance by selecting Clustered Columnstore Indexes for large analytical tables and Clustered Rowstore Ind
Azure SQL Indexing Strategy for Mixed OLTP and Analytics Workloads
Learn how to map Azure SQL index types to specific performance requirements, using nonclustered columnstore indexes for analytics and filtered indexes
Optimizing JSON Queries with Computed Columns and Covering Indexes
Learn how to optimize SQL queries filtering JSON properties in Microsoft Fabric by creating persisted computed columns and covering indexes to elimina
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