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.

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

Latest DP-500 Dumps Valid Version with 83 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments