Shortcut caching supports only S3/GCS shortcuts and excludes files larger than 1 GB

DP-700 By islever Editorial Last updated

Ingest and transform batch data

Short answer

C Only the Store shortcut (Amazon S3, under 1 GB) is cached; ADLS Gen2 shortcuts are not cache-eligible and the 2 GB Trips file exceeds the 1 GB limit.

Question

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? - Exhibit: Shortcut caching supports only S3/GCS shortcuts and excludes files
  1. Trips and Stores only
  2. Products and Store only
  3. Stores only Correct Answer
  4. Products only
  5. Products, Stores, and Trips

Key Takeaways

Shortcut caching eligibility is governed by both source type and file size: only S3/GCS-class shortcuts qualify, and any single file over 1 GB is excluded regardless of source.

With the cache for shortcuts enabled, only data from supported external shortcut sources (currently GCS, S3, S3-compatible, and on-premises data gateway) is cached, and individual files larger than 1 GB are never cached. ADLS Gen2 shortcuts are not eligible for caching.

Common mistake: Assuming Azure Data Lake Storage Gen2 shortcuts are cached like S3 shortcuts, or forgetting that the 2 GB Trips file exceeds the 1 GB caching limit.

Expert Analysis

Why the Answer Is Correct

Microsoft Fabric documentation for OneLake shortcuts states that shortcut caching 'currently supports Google Cloud Storage (GCS), S3, S3 compatible, and on-premises data gateway shortcuts.' Azure Data Lake Storage Gen2 is explicitly not in that supported list, so the Products shortcut (ADLS Gen2) is not cached. The cache also excludes individual files greater than 1 GB, so the 2 GB Trips file is not cached either. Only the Store shortcut, which points to Amazon S3 and is under 1 GB, is retrieved from the cache.

Why the Other Options Are Wrong

Option A (Trips and Stores) fails because Trips is 2 GB and exceeds the 1 GB caching limit. Option B (Products and Store) fails because Products is an ADLS Gen2 shortcut, which is not a supported caching source. Option D (Products only) and E (all three) both wrongly include ADLS Gen2 and/or the oversized Trips file.

Community Comment Notes

The community was split (C 46 vs B 41). Several comments claimed ADLS Gen2 is also cached, but the official doc note lists only GCS, S3, S3-compatible, and on-premises data gateway shortcuts as supported, so the documentation-supported answer is C.

Official Reference

https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts

This link opens the official vendor documentation in a new tab.

Community Votes

C
53%
B
47%

53% of anonymous learners picked answer C. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 14 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 14

  1. Tuki93 👍 6 Answered C
    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
  2. henryphchan 👍 5 Answered C
    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.
  3. Adriel_1996 👍 4 Answered C
    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
  4. prabhjot 👍 4 Answered B
    Shortcuts are accessible from both ADLS and Amazon S3 as of the time of writing this answer. Trips is too large to be cached
  5. 01ceacf 👍 4 Answered B
    File greater than 1GB in size are not cached. https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts
Show 9 more comments
  1. vish9 👍 2 Answered B
    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).
  2. DarkDerf 👍 2 Answered D
    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
  3. JensQ 👍 2 Answered B
    S3 and ADLS G2 are both supported. Only limitation is the size, meaning Trips is too big to be cached.
  4. amli123 👍 2 Answered C
    Files > 1GB not cached Shorcut caching only supported for S3
  5. Tamele001 👍 2 Answered B
    Products and store because they have less than a GB
  6. ChenFu 👍 1 Answered E
    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).
  7. Diana11 👍 1 Answered D
    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
  8. cuomuqi 👍 1 Answered B
    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
  9. Coder99 👍 1 Answered D
    Only the Azure-based shortcut (Products) retrieves data from the cache.

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

A 500-million-row fact table exceeds the F32 Direct Lake guardrail, so increase the capacity to F64

S-grade

Updating warehouse tables requires at least the Contributor workspace role because Write is not shareable to a Viewer

S-grade

Run T-SQL in a KQL database only by prefixing the query with a -- comment line

S-grade

Store semi-structured data readable by T-SQL, KQL, and Spark in an eventhouse

S-grade

← Back to DP-700 Study Guide