You have a Fabric tenant that contains two workspaces named Woritspace1 and Workspace2. Workspace1 contains a lakehouse named Lakehouse1. Workspace2 contains a lakehouse named Lakehouse2. Lakehouse! contains a table named dbo.Sales. Lakehouse2 contains a table named dbo.Customers. You need to ensure that you can write queries that reference both dbo.Sales and dbo.Customers in the same SQL query without making additional copies of the tables. What should you use?

A shortcut in Microsoft Fabric is a symbolic link that references data stored in another location without copying or moving it. To query tables from two different lakehouses (Lakehouse1 and Lakehouse2) in a single SQL query, you should create a shortcut in one lakehouse that points to the table in the other. For instance, creating a shortcut in Lakehouse2 to the dbo.Sales table in Lakehouse1 will make the Sales table accessible through the SQL endpoint of Lakehouse2. This allows you to write a single T-SQL query joining the local dbo.Customers table with the dbo.Sales table via the shortcut, fulfilling the requirement without data duplication.

A. a view: A view is a stored query that operates within the context of a single database (or a lakehouse's SQL endpoint). It cannot directly access a table in a different lakehouse without a pre-existing link, such as a shortcut.

B. a dataflow: A dataflow is an ETL (Extract, Transform, Load) tool. Using it to combine data from both tables would involve ingesting and writing the output to a new location, thus creating a copy of the data, which violates the requirement.

C. a managed table: A managed table is a standard table in a lakehouse where Fabric manages the underlying data. Creating a new managed table to combine the data would require copying the data from the original tables, which is explicitly disallowed.

1. Microsoft Fabric documentation on Shortcuts: "Shortcuts in Microsoft Fabric allow you to reference data across domains

clouds

and accounts without copying the data. Once a shortcut is created to a table in another lakehouse

it appears in the table list of the lakehouse and can be queried like any other table."

Source: Microsoft Learn. (2024). OneLake shortcuts. Section: "What is a shortcut?".

2. Microsoft Fabric documentation on Cross-database querying: "Microsoft Fabric enables you to share data between lakehouses and warehouses without moving or duplicating data. You can create a shortcut in a lakehouse that points to a table in another warehouse or lakehouse... Once the shortcut is created

you can write T-SQL queries that join tables across the three-part named databases."

Source: Microsoft Learn. (2024). Query across databases. Section: "Cross-database queries".

3. Microsoft Fabric documentation on Lakehouse SQL endpoint: "Every Lakehouse has a SQL analytics endpoint... The SQL analytics endpoint enables you to query data in the Lakehouse using T-SQL language." This establishes that each lakehouse is a distinct queryable database context

necessitating a mechanism like shortcuts to bridge them.

Source: Microsoft Learn. (2024). The SQL analytics endpoint of the Lakehouse. Section: "SQL analytics endpoint".