Microsoft · DP-700
Batch ingestion
DP-700 · Lesson 6 of 11 · 35: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: choosing a data store (lakehouse, warehouse, eventhouse, SQL database), OneLake shortcuts to other items, ADLS, and Amazon S3, mirroring with its free replication compute and storage, open mirroring, and loading with pipelines, COPY INTO, T-SQL, Dataflow Gen2, and Copy job. Includes three original practice questions.
Preview the topics
- A team of SQL developers needs a store for a star schema, loaded with stored procedures and multi-table transactions. Which store fits?
- Data scientists need a large dataset already in Amazon S3, and the company does not want to copy or duplicate it. What should the engineer create?
- An operational Azure SQL database must be available in OneLake for analytics, continuously in sync, with no ETL to build. What should the engineer use?