Question 10
During a Microsoft Fabric design review, stakeholders report: A user can query a warehouse via SQL but receives an error opening its semantic model. What should the engineer do?
Explanation
Correct Answer
Source SQL permissions do not automatically establish access to a separate semantic model item. The recommended action directly addresses the stated requirement.
Incorrect Answers
This action is appropriate when a semantic model uses a fixed cloud connection identity and an architect assumes every reader's SQL RLS is applied automatically. Fixed identity and single sign-on yield different security evaluation behavior. However, the question instead requires Check the semantic model's own access permissions and required credentials. because source SQL permissions do not automatically establish access to a separate semantic model item.
This action is appropriate when a report consumer has Build permission but cannot connect to a protected source lakehouse. Build authorizes model reuse, not necessarily read rights on separate source items. However, the question instead requires Check the semantic model's own access permissions and required credentials. because source SQL permissions do not automatically establish access to a separate semantic model item.
This action is appropriate when a model author sees full data while a Viewer only sees an authorized subset. Effective row visibility can differ by principal even on a shared model. However, the question instead requires Check the semantic model's own access permissions and required credentials. because source SQL permissions do not automatically establish access to a separate semantic model item.






Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Practice Tests