Exam DP-700 topic 1 question 18 discussion

Shortcut caching is currently only supported for GCS, S3 and S3 compatible shortcuts. If a file hasn’t been accessed for more than 24 hrs it's purged from the cache. Individual files greater than 1 GB in size aren't cached https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts#caching

Shortcuts are accessible from both ADLS and Amazon S3 as of the time of writing this answer. Trips is too large to be cached

C is correct. -Shortcut caching is currently supported for Google Cloud Storage (GCS), Amazon S3, and S3-compatible storage. -Azure Data Lake Storage Gen2 (ADLS Gen2) does not require or use caching since it integrates natively with OneLake, so it is not cached. -Files larger than 1 GB are not cached.

ProductFile is in storage1 (Azure) → not cached. TripsFile is in storage2 (Amazon S3), but it's 2 GB, which is large → not cached. StoreFile is in storage2 (Amazon S3) and only 25 MB → likely to be cached.

The question is asking "The data from which shortcuts will be retrieved FROM THE CACHE?". ADLS does NOT need a cache. -> Products is incorrect Tripfile exceeds 1GB -> Trips is incorrect Stores is from S3 and supported by shortcut caching. -> Stores is correct

Individual files greater than 1 GB in size aren't cached

Most Probably the correct answer is B Shortcut caching is currently supported for GCS, S3, S3 compatible, and on-premises data gateway shortcuts. Individual files greater than 1 GB in size aren't cached. https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts#caching

The key detail in this question is that Fabric can cache shortcut data only from Azure Data Lake Storage Gen2, not from Amazon S3. - Only files stored in Azure Data Lake Gen2 (i.e., storage1) can be cached. - That means only ProductFile (Products) is eligible for shortcut caching.

Remember . in documentation, still you cant see ADLS. but ADLS and Dataverse support shortcut now in Fabric. Access one lake house and try. I verified

Products and store because they have less than a GB

ProductFile is part of ADLS GEN2 which according documentation "Shortcut caching is currently only supported for GCS, S3 and S3 compatible shortcuts." hence is not caching. TripsFile exccede 1 GB size Only StoreFile support caching and has the right size Based on: https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts Caching and S3 shortcuts

s3 can be saved https://learn.microsoft.com/en-us/fabric/onelake/create-s3-shortcut and items bigger than 1GB can not cached. "If a file hasn’t been accessed for more than 24 hrs it's purged from the cache. Individual files greater than 1 GB in size aren't cached." https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts

In Microsoft Fabric, when the cache for shortcuts is enabled, the caching mechanism applies based on the file size and source location. ProductFile (50MB) from storage1 (Azure Data Lake Storage Gen2) Cached ✅ (because it's from Azure Data Lake and is small) TripsFile (2GB) from storage2 (Amazon S3) Not cached ❌ (because it's larger than 1GB) StoreFile (25MB) from storage2 (Amazon S3) Cached ✅ (because it's smaller than 1GB) Cache Behavior: Files ≤ 1GB from Azure Data Lake Storage (ADLS) or Amazon S3 are cached. Files > 1GB are not cached. Answer: The data retrieved from the cache will be Products (ProductFile) and Stores (StoreFile).

S3 and ADLS G2 are both supported. Only limitation is the size, meaning Trips is too big to be cached.

Since caching works only for Azure Data Lake Storage Gen2, the shortcuts pointing to Amazon S3 (storage2) will not be retrieved from the cache. Evaluating the shortcuts: Products (shortcut to ProductFile - ADLS Gen2) → ✅ Cached Stores (shortcut to StoreFile - Amazon S3) → ❌ Not Cached Trips (shortcut to TripsFile - Amazon S3) → ❌ Not Cached Answer: The cached data will be retrieved only for Products. Thus, the correct answer is: D. Products only

In Microsoft Fabric, when cache for shortcuts is enabled, the data from the shortcuts is automatically cached in OneLake for faster access. The key factors that determine cache availability are: Shortcut source – Files in Azure Data Lake Storage Gen2 and Amazon S3 are both supported for caching. Cache enabled – If caching is enabled for the workspace, all accessible shortcuts are cached. Data access – Cached data is updated when the source changes or when the cache expires (typically after 30 days of inactivity).

The answer is C. Please refer to MS docs (https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts) - Shortcut caching can be used to reduce egress costs associated with cross-cloud data access. - Shortcut caching is currently only supported for GCS, S3 and S3 compatible shortcuts.