nerdexam
Microsoft

DP-700 · Question #19

You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled. Workspace1 creates a lakehouse named Lakehouse1. Lakehouse1 has the following shortcuts shown in the following…

The correct answer is C. Stores and Products only. When shortcut caching is enabled in Fabric, data from shortcuts that are frequently accessed (within 24 hours) and are 100MB or smaller will be retrieved from the cache. Shortcuts exceeding 100MB or not accessed recently will bypass the cache.

Monitor and optimize a data analytics solution

Question

You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled. Workspace1 creates a lakehouse named Lakehouse1. Lakehouse1 has the following shortcuts shown in the following table. Name Size ProductFile.parquet 8 MB StoreFile.json 500 MB TripsFile.csv 99 MB 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 shown in the following table. Name Source Last accessed Products ProductFile 12 hours ago Stores StoreFile 4 hours ago Trips TripsFile 48 hours ago You need to read data from all the shortcuts. Which shortcuts will retrieve data from the cache?

Options

  • AStores only
  • BProducts only
  • CStores and Products only
  • DProducts, Stores, and Trips
  • ETrips only
  • FProducts and Trips only

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    14% (4)
  • C
    69% (20)
  • D
    7% (2)
  • E
    7% (2)

Why each option

When shortcut caching is enabled in Fabric, data from shortcuts that are frequently accessed (within 24 hours) and are 100MB or smaller will be retrieved from the cache. Shortcuts exceeding 100MB or not accessed recently will bypass the cache.

AStores only

'Stores only' is incorrect because 'Products' also meets the caching criteria.

BProducts only

'Products only' is incorrect because 'Stores' also meets the caching criteria.

CStores and Products onlyCorrect

The cache for shortcuts applies to files up to 100MB in size that have been accessed within the last 24 hours. 'Products' (8 MB, accessed 12 hours ago) and 'Stores' (99 MB, accessed 4 hours ago) both meet these criteria.

DProducts, Stores, and Trips

'Trips' (500 MB) exceeds the 100 MB cache limit, so it will not be cached, making this choice incorrect.

ETrips only

'Trips only' is incorrect because 'Trips' exceeds the 100 MB cache limit and 'Products' and 'Stores' would also be cached.

FProducts and Trips only

'Trips' will not be cached due to its size, making this choice incorrect.

Concept tested: Fabric Lakehouse shortcut caching rules

Source: https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-shortcuts#cache-for-shortcuts

Topics

#Fabric Lakehouse#Data caching#Performance optimization#Shortcuts

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-700 Practice