Exam DA-100 topic 5 question 12 discussion

Yes A is correct. Query folding is not occuring because not supported for flat files and it's the only way to speed up incremental refresh.

Most data sources that support SQL queries support query folding. However, data sources like flat files, blobs, and web feeds typically do not.

I got it on my exam 03/17/2022. 90-95% questions were from here. 61 questions in 100 min. All 3 case studies that appeared in exam, where from here.

In exam 30/12/21

on exam 12/10/2021

on exam - Nov 11, 2021. my answer: Query folding is not occurring.

at the begining I went for D, but after reading "If you see this warning and want to verify the necessary query folding is occurring, use the Power Query Diagnostics feature or trace queries by using a tool supported by the data source, like SQL Profiler. If query folding is not occurring, verify the filter logic is included in the query being passed to the data source. If not, it's likely the query includes a transformation that prevents folding." on https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview, found that the if D could be the perfect answer if it says "missing filter on data source" which causes failure of query folding.

On exam 10/14/21

Not D: Filter on report has no impact on Incremental refresh but setup for Incremental refresh Date Range Filters required. NOT C: This is first attempt at refresh(test). NOT B: Irrelevant . Only A is valid option as Query folding not happening due to huge size of blob.

According to this :https://stackoverflow.com/questions/64093061/power-bi-incremental-refresh-from-azure-blob I go for C answer

I feel the answer should be A because: 1. Dataset refresh fails shouldn't have any relationship to a filter in report level. Filter in report level and dataset level is different. 2. 'The dataset uses incremental refresh' is a wrong solution. Incremental refresh is designed for data sources that support query folding, which is Power Query's ability to generate a single query expression to retrieve and transform source data. Flat file source doesn't support query folding, so it is the root cause of dataset refresh fails.

As per my knowledge its A . Most data sources that have the concept of a query language support query folding. These data sources can include relational databases, OData feeds (including SharePoint lists), Exchange, and Active Directory. However, data sources like flat files, blobs, and web typically do not.

Answer is D -> "You discover that the dataset refresh fails after the refresh runs out of resources." "OUT OF THE RESOUCES" , missing filter.

The possible cause of the issue is "A" Query folding is not occurring because the dataset was created with flat files from the AZURE blob storage. Note: Most data sources that support SQL queries support query folding. Data sources like flat files, blobs, and some web feeds often do not.

A is the correct answer

It is in the question - 'runs out of resources' , has to therefore be querying folding is not happening

lol topaz they're clearly saying query folding isnt occuring and you're saying flat files , blobs and webfeeds do not , and here we have an incremental refresh which requirese querry folding so the answer is clearly A