Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Microsoft Discussions

Exam DP-600 topic 1 question 26 discussion

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

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily.
You create a Microsoft Power BI semantic model named Model1 that uses the CSV files as a data source. You configure incremental refresh for Model1 and publish the model to a Premium capacity in the Fabric tenant.
When you initiate a refresh of Model1, the refresh fails after running out of resources.
What is a possible cause of the failure?

  • A. Query folding is occurring.
  • B. Only refresh complete days is selected.
  • C. XMLA Endpoint is set to Read Only.
  • D. Query folding is NOT occurring.
  • E. The delta type of the column used to partition the data has changed.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Fermd at Feb. 13, 2024, 9:23 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Nefirs
Highly Voted 1 month, 1 week ago
Selected Answer: E
i don't really know. But A and D regarding query folding seem for me not to be relevant since query folding does not make sense anyway on CSV/Flatfile connections. In my understanding, query folding sends a query back to the source. And what kind of query would that be to a CSV source?
upvoted 6 times
...
d47320d
Most Recent 1 week, 3 days ago
Correct Answer: "E. The delta type of the column used to partition the data has changed." Explanation: Query folding is not applicable with csv files, which rules out A,D answers. The provided Microsoft link related to "problem-loading-data-takes-too-long", states two causes, one related to query folding (we've already ruled it out) and another one related to the data type, which in turn leads us to answer E.
upvoted 2 times
eeeliiisaaa
1 week ago
But DELTA type? I have not found anything related to that concept...
upvoted 1 times
...
...
sraakesh95
2 months ago
Selected Answer: D
Combining the references by XiltroX and Momoanwar: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot#problem-loading-data-takes-too-long https://learn.microsoft.com/en-us/power-query/power-query-folding
upvoted 1 times
neoverma
3 weeks, 4 days ago
as per the documentation: https://learn.microsoft.com/en-us/power-query/query-folding-examples#no-query-folding-example "Queries that rely solely on unstructured data sources or that don't have a compute engine, such as CSV or Excel files, don't have query folding capabilities. This means that Power Query evaluates all the required data transformations using the Power Query engine." so not sure what this has to do with query folding at all
upvoted 1 times
...
...
XiltroX
2 months, 1 week ago
Selected Answer: D
D is the right choice. Here's why: https://learn.microsoft.com/en-us/power-query/power-query-folding
upvoted 1 times
...
estrelle2008
2 months, 1 week ago
Selected Answer: B
Without considering external tooling (C), without further context I can already identify B, D and E as possible causes. Question should be: What could NOT be a cause? I add answer B to this: Resource exhaustion due to partial-day refresh, when Only refresh complete days is selected while configuring incremental refresh.
upvoted 2 times
...
Momoanwar
2 months, 2 weeks ago
Selected Answer: D
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot#problem-loading-data-takes-too-long
upvoted 3 times
...
Nicofr
2 months, 2 weeks ago
Selected Answer: E
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot#problem-loading-data-takes-too-long
upvoted 2 times
...
Fermd
2 months, 3 weeks ago
Selected Answer: C
C. XMLA Endpoint is set to Read Only: If the XMLA endpoint for the Premium capacity is set to Read Only, any attempt to update or refresh the model through this endpoint, including incremental refresh, would fail. This configuration directly explains the resource exhaustion during a refresh operation as the read-only mode wouldn't allow the necessary updates to occur.
upvoted 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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