Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 16 discussion

Actual exam question from Microsoft's DP-700

Question #: 16
Topic #: 1

You have a Google Cloud Storage (GCS) container named storage1 that contains the 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 shortcuts shown in the following table.

You need to read data from all the shortcuts.
Which shortcuts will retrieve data from the cache?

A. Stores only
B. Products only
C. Stores and Products only
D. Products, Stores, and Trips
E. Trips only
F. Products and Trips only

Show Suggested Answer

Suggested Answer: C 🗳️

by name212 at Dec. 8, 2024, 12:41 p.m.

Comments

Submit Cancel

Tuki93

Highly Voted 6 months, 3 weeks ago

Selected Answer: C

Shortcut caching can be used to reduce egress costs associated with cross-cloud data access. As files are read through an external shortcut, the files are stored in a cache for the Fabric workspace. Subsequent read requests are served from cache rather than the remote storage provider. Cached files have a retention period of 24 hours. https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts#caching

upvoted 16 times

Sr18

1 month, 1 week ago

Answer should be B, as ADLS shortcuts are supported as well as gcb, s3. But cap is 1gb.

upvoted 1 times

Sr18

1 month, 1 week ago

My bad this is answer for 18. Here it should be all 3. As all of them are less than 2 gb and 28 days is now max retention.

upvoted 1 times

Sr18

1 month, 1 week ago

I mean 1gb, stupid typo

upvoted 1 times

...

Kiket2ride

Highly Voted 3 months, 1 week ago

Selected Answer: C

By default is C but now D can also be true. See here: The retention period for cached files can be set from 1-28 days https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts#caching

upvoted 6 times

Adriel_1996

3 months, 1 week ago

I am dealing with same issue. Could be C or D depending on your configuration.

upvoted 2 times

...

smanzana

Most Recent 1 week, 5 days ago

Selected Answer: D

D: Cache duration can now be configured between 1 and 28 days, not just the default 24 hours, but files larger than 1 GB are excluded from the cache and will not be cached.

upvoted 1 times

...

rehoboth2165

3 weeks ago

Selected Answer: D

Caching is for 1-28 days on last accessed and the individual files are less than 1GB each

upvoted 2 times

...

f4fdd67

3 weeks, 6 days ago

Selected Answer: C

Here the default retention period is 24 hours, but can be configured to 1-28 days. But, they didn't mention about any retention period. Hence, default retention period is applied and option C is the correct

upvoted 2 times

...

DarioReymago

1 month ago

Selected Answer: D

D: he retention period for cached files can be set from 1-28 days Files are less than 1gb all sources type are supported

upvoted 2 times

...

vernillen

1 month ago

Selected Answer: D

Due to recent changes

upvoted 2 times

...

5dcd3a8

1 month, 1 week ago

Selected Answer: D

With the new update cached files can be set from 1-28. Also the Individual files greater than 1 GB in size aren't cached. https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts#caching

upvoted 3 times

...

upliftinghut

1 month, 3 weeks ago

Selected Answer: D

less than 1 GB & retention up to 18 days => all are ok

upvoted 2 times

...

ts_au

1 month, 3 weeks ago

Selected Answer: D

caching can now be retained up to 28 days

upvoted 5 times

...

henryphchan

4 months, 2 weeks ago

Selected Answer: C

Data within 1GB and accessed less than 24 hours will be cached

upvoted 3 times

...

Bharat

6 months, 2 weeks ago

Selected Answer: D

I think that the correct answer is D instead of C because the caching is enabled for ALL types of files in a Lakehouse whether they are Parquet, JSON, or CSV.

upvoted 4 times

Bharat

6 months, 2 weeks ago

Sorry, I didn't pay attention to the retention period. Because it exceeds 24 hours, it will not be read from the cache. Therefore, the answer is correct.

upvoted 2 times

...