The data from which shortcuts will be retrieved from the cache?

You have an Azure Data Lake Storage Gen2 account named storage1 and an Amazon S3 bucket named storage2.

You have the Delta Parquet files shown in the following table.

You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled.

Workspace1 contains a lakehouse named Lakehouse1.

Lakehouse1 has the following shortcuts:

– A shortcut to ProductFile aliased as Products

– A shortcut to StoreFile aliased as Stores

– A shortcut to TripsFile aliased as Trips

The data from which shortcuts will be retrieved from the cache?
A . Trips and Stores only
B . Products and Store only
C . Stores only
D . Products only
E . Products. Stores, and Trips

View Answer

Answer: B

Explanation:

When the cache for shortcuts is enabled in Fabric, the data retrieval is governed by the caching behavior, which generally retains data for a specific period after it was last accessed. The data from the shortcuts will be retrieved from the cache if the data is stored in locations that support caching.

Here’s a breakdown based on the data’s location:

Products: The ProductFile is stored in Azure Data Lake Storage Gen2 (storage1). Since Azure Data Lake is a supported storage system in Fabric and the file is relatively small (50 MB), this data is most likely cached and can be retrieved from the cache.

Stores: The StoreFile is stored in Amazon S3 (storage2), and even though it is stored in a different cloud provider, Fabric can cache data from Amazon S3 if caching is enabled. This data (25 MB) is likely cached and retrievable.

Trips: The TripsFile is stored in Amazon S3 (storage2) and is significantly larger (2 GB) compared to the other files. While Fabric can cache data from Amazon S3, the larger size of the file (2 GB) may exceed typical cache sizes or retention windows, causing this file to likely be retrieved directly from the source instead of the cache.