Question 590
A semantic model queries SQL endpoint data with an expensive SQL view and the team wants to avoid repeated DirectQuery fallback. Which test result satisfies the scenario?
Explanation
Correct Answer
This directly verifies the intended outcome: Materialization can remove a fallback-causing SQL view dependency. The accepted result is: Diagnostics show the intended Direct Lake execution and correct view-equivalent rows.
Incorrect Answers
A name doesn't materialize the view.
The model can fail queries.
Changes business requirements.