Microsoft · AB-410
Columns, relationships, and AI columns
AB-410 · Lesson 4 of 17 · 24:42
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 AB-410 exam (Building Intelligent Applications). In this lesson: column data types and choices, lookups, one-to-many and many-to-many relationships, relationship behaviors (cascade all, remove link, restrict), prompt columns that store AI-generated values in rows, row summaries generated by Copilot on forms and views, and when to use each. Includes three original practice questions.
Preview the topics
- Deleting a building that still has work orders must fail, so that Contoso never loses a history by accident. Which delete behavior fits?
- Contoso’s planners want a short Copilot-generated overview at the top of every work order form, with the priority, the building, and recent activities. What should the team configure?
- A Contoso flow must route urgent inspections, using an AI-generated risk level saved with each inspection row. What should store that level?