Microsoft · DP-600
Transform with T-SQL
DP-600 · Lesson 6 of 15 · 37:11
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-600 exam (Microsoft Certified: Fabric Analytics Engineer Associate). In this lesson: views, inline table-valued and scalar functions, stored procedures, and a star schema built in a warehouse with T-SQL, including IDENTITY keys. Includes three original practice questions.
Preview the topics
- Analysts need the sales of any region they pick, reused inside other queries and joins, with no copy of the data. What should you create?
- Every night, new customers must be inserted into a dimension table, and existing customers updated, in one statement, run by a pipeline. What should the procedure use?
- A product dimension is split into three tables: product, subcategory, and category. Reports need fewer joins, and a simpler model. What should the team do?