Implementing Analytics Solutions Using Microsoft Fabric — Question 73

You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2. Workspace1 contains a lakehouse named Lakehouse1. Workspace2 contains a lakehouse named Lakehouse2. Lakehouse1 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?

Answer options

• A. a shortcut
• B. a dataflow
• C. a view
• D. a managed table

Correct answer: A

Explanation

The correct answer is A, a shortcut, because it allows you to create a reference to tables in different workspaces without duplicating the data. Options B, C, and D do not meet the requirement of referencing tables from different lakehouses without creating additional copies of the tables.