Design and implement database objects
3 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
3 total · page 1 of 1Azure 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
Does the CustomerProfiles schema satisfy PII and RLS requirements?
This hotspot tests whether a dbo.CustomerProfiles schema using dynamic data masking and row-level security satisfies Contoso's PII and fleet-filtering
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