exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 18 discussion

Actual exam question from Microsoft's DP-700
Question #: 18
Topic #: 1
[All DP-700 Questions]

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?

  • A. Trips and Stores only
  • B. Products and Store only
  • C. Stores only
  • D. Products only
  • E. Products, Stores, and Trips
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
henryphchan
4 days, 19 hours ago
Selected Answer: 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.
upvoted 1 times
henryphchan
4 days, 19 hours ago
- Cached files have a retention period of 24 hours. - Individual files greater than 1 GB in size aren't cached.
upvoted 1 times
...
...
prabhjot
2 weeks, 1 day ago
Selected Answer: 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
upvoted 1 times
...
Diana11
2 weeks, 2 days ago
Selected Answer: 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
upvoted 1 times
Diana11
2 weeks, 2 days ago
..and Store, because in Lakehouse1, we have -> A shortcut to StoreFile aliased as Stores Correct answer is B. Products and Store only. Trips is too large to be cached (2 GB).
upvoted 1 times
...
...
Coder99
2 weeks, 4 days ago
Selected Answer: D
Only the Azure-based shortcut (Products) retrieves data from the cache.
upvoted 1 times
...
Tuki93
4 weeks ago
Selected Answer: 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
upvoted 2 times
...
amli123
1 month ago
Selected Answer: C
Files > 1GB not cached Shorcut caching only supported for S3
upvoted 1 times
...
01ceacf
2 months, 1 week ago
Selected Answer: B
File greater than 1GB in size are not cached. https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago