Microsoft Exam DA-100 Topic 5 Question 47 Discussion

Actual exam question for Microsoft's DA-100 exam

Question #: 47
Topic #: 5

[All DA-100 Questions]

You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.

From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium

capacity.

You discover that the dataset refresh fails after the refresh runs out of resources.

What is a possible cause of the issue?

AQuery folding is not occurring.

BYou selected Only refresh complete periods.

CThe data type of the column used to partition the data changed.

DA filter is missing on the report.

Show Suggested Answer

Suggested Answer: A

The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by including them in the queries. Using Power Query terminology, this is called ''query folding''. It is not recommended that incremental refresh is used when the required query folding cannot take place.

https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/

by Cyndy at May 07, 2022, 01:20 PM

Limited Time Offer

25%

Off

Get Premium DA-100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!