Question

Your team maintains a Fabric lakehouse in the Analytics workspace. Another team owns a lakehouse in the Sales workspace that already stores cleansed, curated Delta tables of customer orders that are refreshed hourly. You need those order tables available for querying inside your Analytics lakehouse's SQL analytics endpoint. The requirements are: no data duplication, no additional storage cost in your workspace, and consumers must always see the latest data without any scheduled refresh. Which approach should you implement?

Accepted Answer

Create a OneLake shortcut in the Analytics lakehouse that points to the Delta table folders in the Sales lakehouse.

Answer

Build a Dataflow Gen2 that reads the Sales tables and writes them into the Analytics lakehouse on an hourly schedule.

Answer

Use a Data pipeline Copy activity to replicate the Sales Delta tables into the Analytics lakehouse every hour.

Answer

Enable mirroring of the Sales lakehouse into the Analytics lakehouse.