You need to implement the solution for the book reviews. Which should you do?

To implement a solution for book reviews, assuming the data resides in an external storage location like Azure Data Lake Storage (ADLS) Gen2, a shortcut is the most efficient method. In Microsoft Fabric, a OneLake shortcut acts as a symbolic link to the external data source. This approach allows you to access and analyze the book review data directly within your lakehouse without ingesting or duplicating it. This avoids data movement, reduces storage costs, and ensures that analyses are always performed on the most current data from the source system.

A. A Dataflow Gen2 is used for data ingestion and transformation. If the requirement is simply to access the data for analysis, a dataflow is an unnecessary step that adds complexity.

C. External data sharing is a feature used to share data from your Fabric workspace with external organizations, not for accessing external data within your workspace.

D. A data pipeline would be used to orchestrate data movement, typically by copying the data into the lakehouse. This creates a duplicate copy, which is less efficient than a shortcut.

1. Microsoft Fabric Documentation - OneLake shortcuts: "Shortcuts in Microsoft Fabric allow you to connect to existing data without having to directly copy it... A shortcut is a symbolic link

which creates a reference between locations. When you access data through a shortcut

the data remains in its original location." This directly supports using a shortcut to access external data without duplication.

Source: Microsoft Learn

OneLake shortcuts

"What is a shortcut?" section.

2. Microsoft Fabric Documentation - Data pipelines: "A data pipeline is used to orchestrate data movement and transformation." This highlights that a pipeline's primary role involves activities like copying

which is what a shortcut is designed to avoid.

Source: Microsoft Learn

Pipelines in Microsoft Fabric

"Overview" section.

3. Microsoft Fabric Documentation - Dataflow Gen2: "Dataflow Gen2 is the new generation of dataflows... you can use it to ingest

clean

and transform data." This confirms that a dataflow is for transformation

not just for referencing data.

Source: Microsoft Learn

What is Dataflow Gen2 in Microsoft Fabric?

"Introduction" section.