DP-500 Question #58: Real Exam Question with Answer & Explanation

The correct answer is B: 1. Even if a query like 'Orders' is load-disabled, it will be executed once during a dataset refresh if other loaded queries are dependent on it, to provide the data for its dependents.

Query and transform data

Question

Based on a query dependency diagram where 'Orders' is load-disabled and dependent queries 'Order Details', 'Customer', 'Shipper' are loaded, when the dataset refreshes, the Orders query will be executed how many times?

Options

Explanation

Even if a query like 'Orders' is load-disabled, it will be executed once during a dataset refresh if other loaded queries are dependent on it, to provide the data for its dependents.

Common mistakes.

A. The query will be executed because its dependent queries are loaded, even if 'Orders' itself is load-disabled.
C. The query will be executed once to produce its result, which is then used by all its dependents; it doesn't execute once per dependent.

Concept tested. Power Query load-disabled queries and dependencies

Reference. https://learn.microsoft.com/en-us/power-query/power-query-overview#query-load-behavior

Topics

#Query dependencies#Load-disabled queries#Data refresh#Power Query execution

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice Browse All DP-500 Questions