A federated query fails while queries against native lakehouse tables succeed. What is the most likely cause?
Select an answer to reveal the explanation.
Short Explanation
Only the queries reaching outside are failing, so look outside. If the platform, workspace, or account were broken, the native lakehouse queries would fail too.
Full Explanation
The failure pattern is the evidence: native lakehouse tables work, federated queries do not, so the fault lies on the path to the remote source. The remote source may be down, unreachable through the network, or refusing the connection, which would affect only queries that depend on it.
Corrupted lakehouse metadata affecting all tables equally is incorrect because it would break native queries as well, contradicting the observation that native lakehouse tables succeed.
A lost connection between the query workspace and the platform is incorrect because it would prevent all queries, not just the federated subset.
A disabled user account is incorrect because it would fail everything, typically at authentication rather than mid-query.
For the exam, use the boundary between what works and what fails to localise the fault.