Microsoft · DP-800
Tables and indexes
DP-800 · Lesson 1 of 20 · 3:43
YouTube loads only after you press play. Watch on YouTube ↗
In this lesson
Prepare for the DP-800 exam (Microsoft Certified: SQL AI Developer Associate). In this lesson: choosing data types (decimal, nvarchar, datetime2, datetimeoffset, uniqueidentifier, and json), estimating row size, clustered and nonclustered indexes with included columns, and clustered and nonclustered columnstore indexes. Includes three original practice questions.
Preview the topics
- The Price column stores amounts in euros, and totals must match the accounting system to the cent. Which data type fits?
- A frequent query filters products by category, and returns only their name and price. Which index fits best?
- A 500-million-row sales history table is loaded in bulk every night, rarely updated, and queried for totals by region and month. Which index design fits?