Cert EspressoLearn. Practise. Find your flow.

A LITTLE FOCUS.
A BIG NEXT STEP.

Your pace. Your space.
Microsoft · DP-600

Choose a data store

DP-600 · Lesson 5 of 15 · 31:57

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: choosing between a lakehouse, a warehouse, an eventhouse, and a SQL database in Fabric, OneLake availability for KQL databases, and OneLake integration for semantic models. Includes three original practice questions.

Preview the topics
  • Suppliers send raw JSON files and product images, and data scientists will train models on them with Spark notebooks. Which store fits?
  • A Direct Lake semantic model must read click events stored in a KQL database, without copying them with a pipeline. What should the team turn on?
  • Finance’s Import model, on a Fabric capacity, holds the official revenue figures. Data scientists must use those exact figures in Spark, without rebuilding the transformations. What should the team do?