nerdexam
Microsoft

DP-700 · Question #21

QUESTION 23 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. Name Stored in Size…

The correct answer is C. Stores only. When shortcut caching is enabled, Fabric caches data from shortcuts that are 100 MB or smaller and were accessed within the last 24 hours. In this scenario, only 'StoreFile' meets the size requirement for caching, assuming it was recently accessed.

Monitor and optimize a data analytics solution

Question

QUESTION 23 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. Name Stored in Size Description ProductFile storage1 50 MB Contains a list of products and their details TripsFile storage2 2 GB Contains one month's worth of taxi trip data StoreFile storage2 25 MB Contains a list of stores and their addresses 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?

Options

  • ATrips and Stores only
  • BProducts and Store only
  • CStores only
  • DProducts only
  • EProducts, Stores, and Trips

How the community answered

(40 responses)
  • A
    13% (5)
  • B
    3% (1)
  • C
    78% (31)
  • E
    8% (3)

Why each option

When shortcut caching is enabled, Fabric caches data from shortcuts that are 100 MB or smaller and were accessed within the last 24 hours. In this scenario, only 'StoreFile' meets the size requirement for caching, assuming it was recently accessed.

ATrips and Stores only

'TripsFile' (2 GB) exceeds the 100 MB caching limit and therefore will not be retrieved from the cache.

BProducts and Store only

'ProductFile' (50 MB) meets the size criteria, but for 'Stores only' to be the correct answer, it implies 'ProductFile' data was not recently accessed enough to be retrieved from the cache.

CStores onlyCorrect

Fabric's shortcut caching mechanism prioritizes files up to 100 MB in size and those that have been accessed within the last 24 hours. 'StoreFile' at 25 MB meets the size requirement for caching, and for it to be retrieved from cache, it is implicitly assumed to have been recently accessed.

DProducts only

'ProductFile' (50 MB) meets the size criteria, but for 'Stores only' to be the correct answer, it implies 'ProductFile' data was not recently accessed enough to be retrieved from the cache.

EProducts, Stores, and Trips

'TripsFile' (2 GB) exceeds the 100 MB caching limit, so it will not be cached.

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#Shortcuts#Caching#Data retrieval optimization

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-700 Practice