Microsoft

DP-700 practice question 17

Implementing Data Engineering Solutions Using Microsoft Fabric · free question 17 of 20

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. | 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?
  • A. Trips and Stores only
  • B. Products and Stores only
  • C. Stores only Correct
  • D. Products only
  • E. Products, Stores, and Trips

Explanation

OneLake shortcut caching applies only to Google Cloud Storage, S3, S3-compatible and on-premises data gateway shortcuts, and individual files larger than 1 GB are never cached. Products points to ADLS Gen2 (storage1), which is not a cached shortcut type, so it is always read from the source. Trips points to S3 but the file is 2 GB, above the 1 GB limit. Only Stores (S3, 25 MB) is served from the cache.

Practice the whole free set

Answer all 20 free DP-700 questions with instant feedback, or unlock all 139 questions with Learn and Exam modes.