From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Creating and managing mirroring

Creating and managing mirroring - Microsoft Fabric Tutorial

From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Creating and managing mirroring

“

Creating and managing mirroring. Now with mirroring, it is a low latency replication service where we're connecting to supported services and a mirrored database is being created in Fabric. We've got three mirroring types. The standard is database mirroring, where it replicates tables and databases. Metadata mirroring, well that doesn't sync data, that syncs metadata and it's not moving the data. We also have open mirroring. Now open mirroring, it lets developers create loading processes to push CSV and parquet data into a mirroring landing zone. Now, in terms of accessing and querying mirrored data, we have a SQL endpoint. And we can use that within the other items available within Fabric to query that mirrored data. Now, why we may want to use mirroring is that it massively simplifies infrastructure and data loading pipelines in that we just have to set up a mirror database pointed at our source system and fabric is going to take care of the managing of the synchronization of the…

Contents