Microsoft · DP-700
Optimizing performance
DP-700 · Lesson 11 of 11 · 1:07:24
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-700 exam (Microsoft Certified: Fabric Data Engineer Associate). In this lesson: lakehouse table maintenance (OPTIMIZE, V-Order, VACUUM with a seven-day default retention), Spark resource profiles, the native execution engine and autotune, warehouse statistics, data types, cold starts and query insights, and optimizing pipelines and eventhouses (parallel copies, caching policies, materialized views, update policies). Includes three original practice questions.
Preview the topics
- Queries on a lakehouse table got slower after months of small hourly appends, which created thousands of tiny files. What should the engineer run?
- In a new workspace, a team’s tables mostly feed Power BI reports, and it wants read-optimized Spark defaults, with V-Order turned on. Which resource profile fits?
- An engineer wants the warehouse queries that run most often, to optimize them first. Which view should they query?