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

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.

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).

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

In Microsoft Fabric, when the cache for shortcuts is enabled, data accessed via shortcuts can be cached in OneLake, reducing latency and improving performance. However, not all shortcuts are automatically cached - only those pointing to Azure Data Lake Storage Gen2 (ADLS Gen2) The only shortcut whose data will be retrieved from the cache is Products

Files > 1GB not cached Shorcut caching only supported for S3

File greater than 1GB in size are not cached. https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts