Microsoft · DP-800
Constraints, sequences, and partitioning
DP-800 · Lesson 2 of 20 · 9:53
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-800 exam (Microsoft Certified: SQL AI Developer Associate). In this lesson: primary keys, foreign keys and cascading actions, unique, check, and default constraints, sequences shared across tables, and table partitioning with partition functions, schemes, elimination, and switching. Includes three original practice questions.
Preview the topics
- CustomerID is already the primary key of the Customer table, and the EmailAddress column must never hold duplicates. What should you add?
- Orders and returns must share one series of document numbers, and the application needs the next number before it inserts the row. What should you use?
- A 3 TB orders table is filtered by order date in most reports, and its oldest month is archived every month. Which design fits?