Question 630
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A model uses bidirectional filters on every relationship and reports contain ambiguous results. (2) A model consumes high memory during refresh and the team assumes adding a second report page will solve it. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Simplify to a clear star schema with controlled filter directions. | (2) Move stable descriptions to an appropriate dimension when relationships support it.
- (1) Consider source-side materialization or reusable measures based on intended semantics. | (2) Profile model tables, cardinality and capacity usage before sizing or redesigning.
- (1) Simplify to a clear star schema with controlled filter directions. | (2) Profile model tables, cardinality and capacity usage before sizing or redesigning.
- (1) Remove unneeded high-cardinality columns from the model. | (2) Profile model tables, cardinality and capacity usage before sizing or redesigning.
Explanation
Correct Answer
C:Requirement 1: Relationship design affects both query work and analytical correctness. Requirement 2: Data model memory pressure cannot be fixed by a cosmetic change to report layout. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Data model memory pressure cannot be fixed by a cosmetic change to report layout. The substituted action, Move stable descriptions to an appropriate dimension when relationships support it., is suited to a different situation: A fact table includes a verbose description repeated across millions of rows. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Relationship design affects both query work and analytical correctness. The substituted action, Consider source-side materialization or reusable measures based on intended semantics., is suited to a different situation: A model creates hundreds of calculated columns for values that can be computed in source SQL. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Relationship design affects both query work and analytical correctness. The substituted action, Remove unneeded high-cardinality columns from the model., is suited to a different situation: A semantic model stores transaction GUIDs in multiple high-cardinality string columns that reports never use. It does not satisfy the specified requirement 1.
Question 631
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A finance viewer should browse approved reports but must not edit workspace items. (2) An engineer creates pipelines and notebooks but should not manage other users' workspace membership. (3) A guest loses an approved contract role, but previously authorized workspace access remains. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Assign the Viewer workspace role and verify item-level data permissions. | (2) Use the Contributor workspace role when its authoring capabilities match the duty. | (3) Assign a suitable workspace Admin or Member role after reviewing its management privileges.
- (1) Assign the Viewer workspace role and verify item-level data permissions. | (2) Use the Contributor workspace role when its authoring capabilities match the duty. | (3) Remove or adjust the guest's workspace membership and recheck direct item grants.
- (1) Assign a suitable workspace Admin or Member role after reviewing its management privileges. | (2) Use the Contributor workspace role when its authoring capabilities match the duty. | (3) Remove or adjust the guest's workspace membership and recheck direct item grants.
- (1) Assign the Viewer workspace role and verify item-level data permissions. | (2) Check inherited access through the user's Fabric workspace role. | (3) Remove or adjust the guest's workspace membership and recheck direct item grants.
Explanation
Correct Answer
B:Requirement 1: Viewer is the least powerful standard workspace role, and viewing a report may still require data access. Requirement 2: Contributor permits eligible item authoring without the full access administration powers of higher roles. Requirement 3: Access reviews must cover all effective permissions rather than only identity deactivation elsewhere. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 3: Access reviews must cover all effective permissions rather than only identity deactivation elsewhere. The substituted action, Assign a suitable workspace Admin or Member role after reviewing its management privileges., is suited to a different situation: A model owner must manage workspace content and access settings on behalf of the analytics team. It does not satisfy the specified requirement 3.
C:Misses requirement 1: Viewer is the least powerful standard workspace role, and viewing a report may still require data access. The substituted action, Assign a suitable workspace Admin or Member role after reviewing its management privileges., is suited to a different situation: A model owner must manage workspace content and access settings on behalf of the analytics team. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Contributor permits eligible item authoring without the full access administration powers of higher roles. The substituted action, Check inherited access through the user's Fabric workspace role., is suited to a different situation: An auditor wants to explain why an analyst can edit a model despite no direct item sharing invitation. It does not satisfy the specified requirement 2.
Question 632
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A partner must view one approved report without editing unrelated workspace assets. (2) An engineer gives a colleague read access to a lakehouse and assumes it also authorizes unrestricted table-file reads. (3) An analyst has a workspace Viewer role but still cannot query a particular restricted dataset. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Review whether the user needs the semantic model Build permission. | (2) Review separate item permissions and applicable OneLake data permissions. | (3) Inspect the item's permissions and the applicable data-level access rules.
- (1) Grant scoped item sharing and necessary read or build permissions rather than broad workspace authoring. | (2) Revoke the overbroad share and grant access to an approved security group. | (3) Inspect the item's permissions and the applicable data-level access rules.
- (1) Grant scoped item sharing and necessary read or build permissions rather than broad workspace authoring. | (2) Review separate item permissions and applicable OneLake data permissions. | (3) Review whether the user needs the semantic model Build permission.
- (1) Grant scoped item sharing and necessary read or build permissions rather than broad workspace authoring. | (2) Review separate item permissions and applicable OneLake data permissions. | (3) Inspect the item's permissions and the applicable data-level access rules.
Explanation
Correct Answer
D:Requirement 1: Item sharing narrows exposure when a user only needs one published asset. Requirement 2: Control-plane access and underlying data-plane authorization must both be evaluated. Requirement 3: Workspace membership does not automatically override fine-grained data security restrictions. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Item sharing narrows exposure when a user only needs one published asset. The substituted action, Review whether the user needs the semantic model Build permission., is suited to a different situation: A report viewer can open the report but cannot create their own report from its underlying model. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Control-plane access and underlying data-plane authorization must both be evaluated. The substituted action, Revoke the overbroad share and grant access to an approved security group., is suited to a different situation: A published model is shared to a broad organization-wide link despite containing restricted financial metrics. It does not satisfy the specified requirement 2.
C:Misses requirement 3: Workspace membership does not automatically override fine-grained data security restrictions. The substituted action, Review whether the user needs the semantic model Build permission., is suited to a different situation: A report viewer can open the report but cannot create their own report from its underlying model. It does not satisfy the specified requirement 3.
Question 633
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) Regional sales users should each see only sales records for their assigned territory in one semantic model. (2) A report passes desktop testing but a non-admin user sees all rows after publication. (3) A reviewer needs to validate how a role filters rows without changing production user membership. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Define a semantic-model row-level security role filtering sales by the authorized territory. | (2) Test effective RLS as the actual consuming identity and inspect its model-role assignments. | (3) Model an approved user-to-territory security mapping for dynamic RLS.
- (1) Define a semantic-model row-level security role filtering sales by the authorized territory. | (2) Test effective RLS as the actual consuming identity and inspect its model-role assignments. | (3) Use the supported View as role or equivalent role-testing workflow.
- (1) Model an approved user-to-territory security mapping for dynamic RLS. | (2) Test effective RLS as the actual consuming identity and inspect its model-role assignments. | (3) Use the supported View as role or equivalent role-testing workflow.
- (1) Define a semantic-model row-level security role filtering sales by the authorized territory. | (2) Use appropriate workspace and model management permissions in addition to RLS. | (3) Use the supported View as role or equivalent role-testing workflow.
Explanation
Correct Answer
B:Requirement 1: RLS limits the rows returned to a user without maintaining duplicated models per region. Requirement 2: Testing as a privileged author can mask the restrictions applied to ordinary viewers. Requirement 3: Role simulation helps detect filter mistakes before granting real users access. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 3: Role simulation helps detect filter mistakes before granting real users access. The substituted action, Model an approved user-to-territory security mapping for dynamic RLS., is suited to a different situation: A manager can access two territories and a hard-coded RLS role displays only one. It does not satisfy the specified requirement 3.
C:Misses requirement 1: RLS limits the rows returned to a user without maintaining duplicated models per region. The substituted action, Model an approved user-to-territory security mapping for dynamic RLS., is suited to a different situation: A manager can access two territories and a hard-coded RLS role displays only one. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Testing as a privileged author can mask the restrictions applied to ordinary viewers. The substituted action, Use appropriate workspace and model management permissions in addition to RLS., is suited to a different situation: A team thinks an RLS predicate will prevent a dataset administrator from changing model permissions. It does not satisfy the specified requirement 2.
Question 634
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A compliance role may see a customer table but not the national-identifier column. (2) Two research groups may read separate folders in one shared lakehouse Files area. (3) A user belongs to several OneLake roles and gains more data visibility than the author expected. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Configure object-level security on the restricted model table or supported data object. | (2) Define scoped OneLake security roles for the approved file paths. | (3) Review cumulative effective role grants and any overly broad DefaultReader assignment.
- (1) Apply column-level data security or a restricted projection at the supported OneLake or model layer. | (2) Narrow the OneLake security role to the approved table objects. | (3) Review cumulative effective role grants and any overly broad DefaultReader assignment.
- (1) Apply column-level data security or a restricted projection at the supported OneLake or model layer. | (2) Define scoped OneLake security roles for the approved file paths. | (3) Configure object-level security on the restricted model table or supported data object.
- (1) Apply column-level data security or a restricted projection at the supported OneLake or model layer. | (2) Define scoped OneLake security roles for the approved file paths. | (3) Review cumulative effective role grants and any overly broad DefaultReader assignment.
Explanation
Correct Answer
D:Requirement 1: CLS prevents sensitive columns from being exposed through an otherwise authorized table. Requirement 2: File and folder authorization must be set at the data plane, not inferred from folder naming. Requirement 3: Multiple grants can combine, so a restrictive role does not cancel a separate broad permission. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: CLS prevents sensitive columns from being exposed through an otherwise authorized table. The substituted action, Configure object-level security on the restricted model table or supported data object., is suited to a different situation: A partner should not discover a confidential compensation table through a semantic model at all. It does not satisfy the specified requirement 1.
B:Misses requirement 2: File and folder authorization must be set at the data plane, not inferred from folder naming. The substituted action, Narrow the OneLake security role to the approved table objects., is suited to a different situation: A read-only data role accidentally includes both public and restricted Delta tables. It does not satisfy the specified requirement 2.
C:Misses requirement 3: Multiple grants can combine, so a restrictive role does not cancel a separate broad permission. The substituted action, Configure object-level security on the restricted model table or supported data object., is suited to a different situation: A partner should not discover a confidential compensation table through a semantic model at all. It does not satisfy the specified requirement 3.
Question 635
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A published profit report contains confidential customer details and needs a visible protection classification. (2) A report export must retain appropriate information protection when moved into a supported Office format. (3) An incident reveals that one workspace's classification label is outdated after its business data became regulated. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Apply the approved sensitivity label to the Fabric item. | (2) Review the label's supported downstream protection and export behavior. | (3) Set item access permissions separately from the sensitivity classification.
- (1) Apply the approved sensitivity label to the Fabric item. | (2) Review the label's supported downstream protection and export behavior. | (3) Reassess the data classification and update the affected item's label through governance review.
- (1) Set item access permissions separately from the sensitivity classification. | (2) Review the label's supported downstream protection and export behavior. | (3) Reassess the data classification and update the affected item's label through governance review.
- (1) Apply the approved sensitivity label to the Fabric item. | (2) Check organization label policies and whether the Fabric labeling feature is enabled for the intended users. | (3) Reassess the data classification and update the affected item's label through governance review.
Explanation
Correct Answer
B:Requirement 1: Labels communicate and can help enforce organizational information protection policies. Requirement 2: Sensitivity label effects vary by artifact and export path and should be tested. Requirement 3: Labels should track actual content sensitivity rather than remain a one-time setup step. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 3: Labels should track actual content sensitivity rather than remain a one-time setup step. The substituted action, Set item access permissions separately from the sensitivity classification., is suited to a different situation: An analyst assumes changing a sensitivity label automatically grants a colleague permission to open an item. It does not satisfy the specified requirement 3.
C:Misses requirement 1: Labels communicate and can help enforce organizational information protection policies. The substituted action, Set item access permissions separately from the sensitivity classification., is suited to a different situation: An analyst assumes changing a sensitivity label automatically grants a colleague permission to open an item. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Sensitivity label effects vary by artifact and export path and should be tested. The substituted action, Check organization label policies and whether the Fabric labeling feature is enabled for the intended users., is suited to a different situation: A tenant has labels defined but workspace authors cannot select them on Fabric items. It does not satisfy the specified requirement 2.
Question 636
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) Several reports appear in the catalog and consumers need to identify their team's recommended version. (2) A recently promoted dataset has stale calculations and analysts assume the badge guarantees accuracy. (3) A project shares an endorsed data product but consumers still receive an access denied message. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Apply certified endorsement only through the organization's authorized certification process. | (2) Validate freshness and correctness independently of item endorsement. | (3) Check share permissions and underlying dataset security in addition to endorsement.
- (1) Promote the trusted Fabric item through the supported endorsement action. | (2) Route certification through the designated Fabric certification administrators or approved process. | (3) Check share permissions and underlying dataset security in addition to endorsement.
- (1) Promote the trusted Fabric item through the supported endorsement action. | (2) Validate freshness and correctness independently of item endorsement. | (3) Apply certified endorsement only through the organization's authorized certification process.
- (1) Promote the trusted Fabric item through the supported endorsement action. | (2) Validate freshness and correctness independently of item endorsement. | (3) Check share permissions and underlying dataset security in addition to endorsement.
Explanation
Correct Answer
D:Requirement 1: Promotion signals an owner's recommendation but does not itself grant data access. Requirement 2: Endorsement indicates recommended status, not automatic numerical correctness. Requirement 3: Endorsement is discoverability metadata and cannot replace authorization. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Promotion signals an owner's recommendation but does not itself grant data access. The substituted action, Apply certified endorsement only through the organization's authorized certification process., is suited to a different situation: A company requires formally validated shared semantic models to be distinguishable from merely popular drafts. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Endorsement indicates recommended status, not automatic numerical correctness. The substituted action, Route certification through the designated Fabric certification administrators or approved process., is suited to a different situation: A report owner cannot certify a shared dataset because they lack the required organizational authority. It does not satisfy the specified requirement 2.
C:Misses requirement 3: Endorsement is discoverability metadata and cannot replace authorization. The substituted action, Apply certified endorsement only through the organization's authorized certification process., is suited to a different situation: A company requires formally validated shared semantic models to be distinguishable from merely popular drafts. It does not satisfy the specified requirement 3.
Question 637
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A user can manage a lakehouse item but is surprised by a restricted table governed through OneLake security. (2) A workspace role gives an engineer item creation rights, but an owner wants to restrict customer rows in all queries. (3) A data owner grants ReadAll on a restricted lakehouse and assumes a later fine-grained role automatically reduces it. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Evaluate item administration and OneLake data role evaluation separately. | (2) Define supported row restrictions at the data plane or semantic model. | (3) Grant scoped OneLake security data access for the table when supported.
- (1) Evaluate item administration and OneLake data role evaluation separately. | (2) Define supported row restrictions at the data plane or semantic model. | (3) Review effective broad ReadAll grants before relying on restrictive OneLake roles.
- (1) Grant scoped OneLake security data access for the table when supported. | (2) Define supported row restrictions at the data plane or semantic model. | (3) Review effective broad ReadAll grants before relying on restrictive OneLake roles.
- (1) Evaluate item administration and OneLake data role evaluation separately. | (2) Review the SQL endpoint access mode and its governing security policy before changing it. | (3) Review effective broad ReadAll grants before relying on restrictive OneLake roles.
Explanation
Correct Answer
B:Requirement 1: Control-plane management and table-row data visibility are distinct permission scopes. Requirement 2: Workspace creation rights are not a substitute for row-level data filtering. Requirement 3: A separate full-data grant can defeat intended least-privilege isolation. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 3: A separate full-data grant can defeat intended least-privilege isolation. The substituted action, Grant scoped OneLake security data access for the table when supported., is suited to a different situation: A data analyst requires read-only access to one governed OneLake table through several Fabric engines. It does not satisfy the specified requirement 3.
C:Misses requirement 1: Control-plane management and table-row data visibility are distinct permission scopes. The substituted action, Grant scoped OneLake security data access for the table when supported., is suited to a different situation: A data analyst requires read-only access to one governed OneLake table through several Fabric engines. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Workspace creation rights are not a substitute for row-level data filtering. The substituted action, Review the SQL endpoint access mode and its governing security policy before changing it., is suited to a different situation: A lakehouse SQL endpoint shows different security behavior when switching from delegated to user identity. It does not satisfy the specified requirement 2.
Question 638
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A temporary external consultant needs a single published dashboard for a two-week engagement. (2) A user shares a dataset to the entire company to avoid handling access requests. (3) A partner's guest account is disabled but an active service principal continues to consume shared data. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Validate the report and semantic model permission chain for the external principal. | (2) Replace organization-wide sharing with a governed access group and owner approval. | (3) Audit nonhuman and user principals separately and revoke the no-longer-approved data grants.
- (1) Create an explicitly time-bound, narrowly scoped external access grant. | (2) Grant read or Build access as needed while withholding edit or workspace-author rights. | (3) Audit nonhuman and user principals separately and revoke the no-longer-approved data grants.
- (1) Create an explicitly time-bound, narrowly scoped external access grant. | (2) Replace organization-wide sharing with a governed access group and owner approval. | (3) Validate the report and semantic model permission chain for the external principal.
- (1) Create an explicitly time-bound, narrowly scoped external access grant. | (2) Replace organization-wide sharing with a governed access group and owner approval. | (3) Audit nonhuman and user principals separately and revoke the no-longer-approved data grants.
Explanation
Correct Answer
D:Requirement 1: Limited duration and scope reduce exposure beyond the approved engagement. Requirement 2: Broad sharing expands the audience beyond the stated business requirement. Requirement 3: Service identities are independent access paths that a guest account review might miss. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Limited duration and scope reduce exposure beyond the approved engagement. The substituted action, Validate the report and semantic model permission chain for the external principal., is suited to a different situation: An outside collaborator receives a report link but lacks permission to the shared semantic model behind it. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Broad sharing expands the audience beyond the stated business requirement. The substituted action, Grant read or Build access as needed while withholding edit or workspace-author rights., is suited to a different situation: An external analyst requests permission to update Power BI semantic measures despite only needing read access. It does not satisfy the specified requirement 2.
C:Misses requirement 3: Service identities are independent access paths that a guest account review might miss. The substituted action, Validate the report and semantic model permission chain for the external principal., is suited to a different situation: An outside collaborator receives a report link but lacks permission to the shared semantic model behind it. It does not satisfy the specified requirement 3.
Question 639
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A regulated team must demonstrate who changed a semantic model and when. (2) A storage owner wants evidence of which security roles currently grant access to a sensitive table. (3) A policy team needs to prevent new confidential datasets from being published without classification. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Inspect supported Fabric or Microsoft 365 audit events and version history. | (2) Export and review effective role membership and data permission assignments. | (3) Query the supported inventory or governance catalog filtered by item label.
- (1) Inspect supported Fabric or Microsoft 365 audit events and version history. | (2) Export and review effective role membership and data permission assignments. | (3) Configure applicable governance controls and review compliance rather than relying on naming.
- (1) Query the supported inventory or governance catalog filtered by item label. | (2) Export and review effective role membership and data permission assignments. | (3) Configure applicable governance controls and review compliance rather than relying on naming.
- (1) Inspect supported Fabric or Microsoft 365 audit events and version history. | (2) Review sharing changes and relevant audit logs, then document the authorized audience. | (3) Configure applicable governance controls and review compliance rather than relying on naming.
Explanation
Correct Answer
B:Requirement 1: Traceable activity records help establish change accountability. Requirement 2: Security assessment needs actual grants, not assumptions about item ownership. Requirement 3: Programmatic or procedural enforcement is more reliable than an optional description field. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 3: Programmatic or procedural enforcement is more reliable than an optional description field. The substituted action, Query the supported inventory or governance catalog filtered by item label., is suited to a different situation: A compliance analyst wants to discover all items with a restricted sensitivity classification. It does not satisfy the specified requirement 3.
C:Misses requirement 1: Traceable activity records help establish change accountability. The substituted action, Query the supported inventory or governance catalog filtered by item label., is suited to a different situation: A compliance analyst wants to discover all items with a restricted sensitivity classification. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Security assessment needs actual grants, not assumptions about item ownership. The substituted action, Review sharing changes and relevant audit logs, then document the authorized audience., is suited to a different situation: A production report is shared using an unreviewed link and the team needs an access history. It does not satisfy the specified requirement 2.
Question 640
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A user can query a warehouse via SQL but receives an error opening its semantic model. (2) A semantic model uses a fixed cloud connection identity and an architect assumes every reader's SQL RLS is applied automatically. (3) A team combines OneLake table access rules and semantic RLS and sees unexpected effective filters. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Verify the consuming identity's RLS and OneLake security roles. | (2) Verify the effective connection identity and model security before assuming delegated per-user filtering. | (3) Test the intersection of effective model restrictions and OneLake security for each principal.
- (1) Check the semantic model's own access permissions and required credentials. | (2) Inspect the data source access model and the required model connection identity. | (3) Test the intersection of effective model restrictions and OneLake security for each principal.
- (1) Check the semantic model's own access permissions and required credentials. | (2) Verify the effective connection identity and model security before assuming delegated per-user filtering. | (3) Verify the consuming identity's RLS and OneLake security roles.
- (1) Check the semantic model's own access permissions and required credentials. | (2) Verify the effective connection identity and model security before assuming delegated per-user filtering. | (3) Test the intersection of effective model restrictions and OneLake security for each principal.
Explanation
Correct Answer
D:Requirement 1: Source SQL permissions do not automatically establish access to a separate semantic model item. Requirement 2: Fixed identity and single sign-on yield different security evaluation behavior. Requirement 3: Layered security can create compounded restrictions that require end-to-end verification. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Source SQL permissions do not automatically establish access to a separate semantic model item. The substituted action, Verify the consuming identity's RLS and OneLake security roles., is suited to a different situation: A model author sees full data while a Viewer only sees an authorized subset. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Fixed identity and single sign-on yield different security evaluation behavior. The substituted action, Inspect the data source access model and the required model connection identity., is suited to a different situation: A report consumer has Build permission but cannot connect to a protected source lakehouse. It does not satisfy the specified requirement 2.
C:Misses requirement 3: Layered security can create compounded restrictions that require end-to-end verification. The substituted action, Verify the consuming identity's RLS and OneLake security roles., is suited to a different situation: A model author sees full data while a Viewer only sees an authorized subset. It does not satisfy the specified requirement 3.
Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Practice Tests