Question 770
An analyst assumes Copilot in Fabric will automatically query a private lakehouse owned by another division without a permission grant. A generated SQL script works in a development lakehouse but fails in a production SQL endpoint with a different feature set. Which course of action addresses the stated issues?
Explanation
Correct Answer
First, assistant capability does not bypass Fabric resource authorization. Second, Microsoft SQL experiences share language concepts but can differ in supported database capabilities.
Incorrect Answers
Verify workspace, lakehouse and identity entitlements before expecting source-grounded assistance; Attach authorized plan and workload context and treat the suggested tuning changes as hypotheses to test: microsoft SQL experiences share language concepts but can differ in supported database capabilities.
Validate the target engine's supported SQL surface and deploy only code tested against that platform; do not verify workspace, lakehouse and identity entitlements before expecting source-grounded assistance: verify workspace, lakehouse and identity entitlements before expecting source-grounded assistance.
Submit the change through the required pull request and validation process rather than applying the model output directly; validate the target engine's supported SQL surface and deploy only code tested against that platform: assistant capability does not bypass Fabric resource authorization.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests