What can you identify from the diagnostics query?

You are running a diagnostic against a query as shown in the following exhibit.

What can you identify from the diagnostics query?
A . All the query steps are folding.
B . Elevated permissions are being used to query records.
C . The query is timing out.
D . Some query steps are folding.

View Answer

Answer: A

Explanation:

Understanding folding with Query Diagnostics

One of the most common reasons to use Query Diagnostics is to have a better understanding of what operations were ‘pushed down’ by Power Query to be performed by the back-end data source, which is also known as ‘folding’. If we want to see what folded, we can look at what is the ‘most specific’

query, or queries, that get sent to the back-end data source. We can look at this for both ODATA and SQL.

Reference: https://docs.microsoft.com/en-us/power-query/querydiagnosticsfolding