Exam DP-600 topic 1 question 84 discussion

you can not create view directly. you need to create shortcuts first to access table in different workspaces .https://community.fabric.microsoft.com/t5/General-Discussion/Cross-Workspace-access/m-p/3744282#:~:text=You%20cannot%20directly%20query%20the,and%20then%20query%20the%20shortcut.

It's a fabric exam and they're really proud of their shortcuts, which are specifically designed for accessing data without making an additional copy of it.

the d option is changed to script, that is the correct one anyway

My mistake. Please delete my post.

I checked the query below using MS fabric. The below query runs in both lake houses (warehouses under those). As long as they are managed tables, the below query works. select * from Lakehouse1.dbo.Sales select * from Lakehouse2.dbo.Customers

I checked the query below with MS fabric. The below query runs in both lake houses (warehouses under those). As long as they are tables, the below query works. select * from Lakehouse1.dbo.Sales select * from Lakehouse2.dbo.Customers

shortcut (100%)

Shortcuts are specifically designed for cross-lakehouse referencing and provide a seamless and efficient way to query data across different workspaces without data duplication or complex configurations, making them the best choice for this scenario. Views typically reference tables within the same database or lakehouse. While you can create views that reference tables in different schemas or databases, they generally do not support cross-workspace references directly. Creating views for cross-workspace data might require additional configuration or data duplication.

Shortcuts enable you to do it in an easy way.

shortcut first

First create shortcut in order to be able to create view on top

C. a view A view is a virtual table that contains data from one or more tables. You can create a view that references tables from different lakehouses (in this case, dbo.Sales from Lakehouse1 and dbo.Customers from Lakehouse2).