Microsoft · DP-600
Visual queries and SQL
DP-600 · Lesson 8 of 15 · 47:18
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: the visual query editor, SELECT, WHERE, and TOP, common table expressions, GROUP BY and HAVING, ROW_NUMBER with QUALIFY, and cross-database queries. Includes three original practice questions.
Preview the topics
- An analyst who never writes SQL must join two warehouse tables, filter them, and share the result as a view. What should the analyst use?
- For each region, the analyst needs only the best-selling product, from a ranked query, with no subquery. Which clause filters on the rank?
- Orders live in a warehouse, and returns in a lakehouse of the same workspace. The analyst must join them in one T-SQL query, without copying data. How should the returns table be referenced?