Question 560
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A model creates hundreds of calculated columns for values that can be computed in source SQL. (2) A model uses bidirectional filters on every relationship and reports contain ambiguous results. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Profile model tables, cardinality and capacity usage before sizing or redesigning. | (2) Simplify to a clear star schema with controlled filter directions.
- (1) Consider source-side materialization or reusable measures based on intended semantics. | (2) Simplify to a clear star schema with controlled filter directions.
- (1) Remove unneeded high-cardinality columns from the model. | (2) Simplify to a clear star schema with controlled filter directions.
- (1) Consider source-side materialization or reusable measures based on intended semantics. | (2) Move stable descriptions to an appropriate dimension when relationships support it.
Explanation
Correct Answer
B:Requirement 1: Model size and refresh work may fall when unnecessary calculated columns are removed. Requirement 2: Relationship design affects both query work and analytical correctness. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Model size and refresh work may fall when unnecessary calculated columns are removed. The substituted action, Profile model tables, cardinality and capacity usage before sizing or redesigning., is suited to a different situation: A model consumes high memory during refresh and the team assumes adding a second report page will solve it. It does not satisfy the specified requirement 1.
C:Misses requirement 1: Model size and refresh work may fall when unnecessary calculated columns are removed. 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.
D:Misses requirement 2: Relationship design affects both query work and analytical correctness. 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.
Question 561
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) An auditor wants to explain why an analyst can edit a model despite no direct item sharing invitation. (2) A guest loses an approved contract role, but previously authorized workspace access remains. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Check inherited access through the user's Fabric workspace role. | (2) 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) Remove or adjust the guest's workspace membership and recheck direct item grants.
- (1) Check inherited access through the user's Fabric workspace role. | (2) Assign a suitable workspace Admin or Member role after reviewing its management privileges.
- (1) Use the Contributor workspace role when its authoring capabilities match the duty. | (2) Remove or adjust the guest's workspace membership and recheck direct item grants.
Explanation
Correct Answer
A:Requirement 1: Workspace-level permissions can confer capabilities across multiple items independent of direct shares. Requirement 2: 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
B:Misses requirement 1: Workspace-level permissions can confer capabilities across multiple items independent of direct shares. The substituted action, Assign the Viewer workspace role and verify item-level data permissions., is suited to a different situation: A finance viewer should browse approved reports but must not edit workspace items. It does not satisfy the specified requirement 1.
C:Misses requirement 2: 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 2.
D:Misses requirement 1: Workspace-level permissions can confer capabilities across multiple items independent of direct shares. The substituted action, Use the Contributor workspace role when its authoring capabilities match the duty., is suited to a different situation: An engineer creates pipelines and notebooks but should not manage other users' workspace membership. It does not satisfy the specified requirement 1.
Question 562
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A published model is shared to a broad organization-wide link despite containing restricted financial metrics. (2) An analyst has a workspace Viewer role but still cannot query a particular restricted dataset. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Revoke the overbroad share and grant access to an approved security group. | (2) Review whether the user needs the semantic model Build permission.
- (1) Review separate item permissions and applicable OneLake data permissions. | (2) Inspect the item's permissions and the applicable data-level access rules.
- (1) Revoke the overbroad share and grant access to an approved security group. | (2) 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) Inspect the item's permissions and the applicable data-level access rules.
Explanation
Correct Answer
C:Requirement 1: A scoped audience better enforces intended information exposure than an unrestricted sharing link. Requirement 2: 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 2: 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 2.
B:Misses requirement 1: A scoped audience better enforces intended information exposure than an unrestricted sharing link. The substituted action, Review separate item permissions and applicable OneLake data permissions., is suited to a different situation: An engineer gives a colleague read access to a lakehouse and assumes it also authorizes unrestricted table-file reads. It does not satisfy the specified requirement 1.
D:Misses requirement 1: A scoped audience better enforces intended information exposure than an unrestricted sharing link. The substituted action, Grant scoped item sharing and necessary read or build permissions rather than broad workspace authoring., is suited to a different situation: A partner must view one approved report without editing unrelated workspace assets. It does not satisfy the specified requirement 1.
Question 563
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A team thinks an RLS predicate will prevent a dataset administrator from changing model permissions. (2) A reviewer needs to validate how a role filters rows without changing production user membership. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Use appropriate workspace and model management permissions in addition to RLS. | (2) 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 the supported View as role or equivalent role-testing workflow.
- (1) Use appropriate workspace and model management permissions in addition to RLS. | (2) Model an approved user-to-territory security mapping for dynamic RLS.
- (1) Test effective RLS as the actual consuming identity and inspect its model-role assignments. | (2) Use the supported View as role or equivalent role-testing workflow.
Explanation
Correct Answer
A:Requirement 1: Row filters restrict query results, not who can administer the data model. Requirement 2: 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
B:Misses requirement 1: Row filters restrict query results, not who can administer the data model. The substituted action, Define a semantic-model row-level security role filtering sales by the authorized territory., is suited to a different situation: Regional sales users should each see only sales records for their assigned territory in one semantic model. It does not satisfy the specified requirement 1.
C:Misses requirement 2: 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 2.
D:Misses requirement 1: Row filters restrict query results, not who can administer the data model. The substituted action, Test effective RLS as the actual consuming identity and inspect its model-role assignments., is suited to a different situation: A report passes desktop testing but a non-admin user sees all rows after publication. It does not satisfy the specified requirement 1.
Question 564
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A read-only data role accidentally includes both public and restricted Delta tables. (2) A user belongs to several OneLake roles and gains more data visibility than the author expected. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Narrow the OneLake security role to the approved table objects. | (2) Configure object-level security on the restricted model table or supported data object.
- (1) Define scoped OneLake security roles for the approved file paths. | (2) Review cumulative effective role grants and any overly broad DefaultReader assignment.
- (1) Narrow the OneLake security role to the approved table objects. | (2) 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) Review cumulative effective role grants and any overly broad DefaultReader assignment.
Explanation
Correct Answer
C:Requirement 1: Object selection in a role prevents a coarse data grant from exposing unrelated datasets. Requirement 2: 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 2: 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 2.
B:Misses requirement 1: Object selection in a role prevents a coarse data grant from exposing unrelated datasets. The substituted action, Define scoped OneLake security roles for the approved file paths., is suited to a different situation: Two research groups may read separate folders in one shared lakehouse Files area. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Object selection in a role prevents a coarse data grant from exposing unrelated datasets. The substituted action, Apply column-level data security or a restricted projection at the supported OneLake or model layer., is suited to a different situation: A compliance role may see a customer table but not the national-identifier column. It does not satisfy the specified requirement 1.
Question 565
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A tenant has labels defined but workspace authors cannot select them on Fabric items. (2) An incident reveals that one workspace's classification label is outdated after its business data became regulated. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Check organization label policies and whether the Fabric labeling feature is enabled for the intended users. | (2) 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) Reassess the data classification and update the affected item's label through governance review.
- (1) Check organization label policies and whether the Fabric labeling feature is enabled for the intended users. | (2) Set item access permissions separately from the sensitivity classification.
- (1) Review the label's supported downstream protection and export behavior. | (2) Reassess the data classification and update the affected item's label through governance review.
Explanation
Correct Answer
A:Requirement 1: Published label definitions are not automatically available to every user and workload. Requirement 2: 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
B:Misses requirement 1: Published label definitions are not automatically available to every user and workload. The substituted action, Apply the approved sensitivity label to the Fabric item., is suited to a different situation: A published profit report contains confidential customer details and needs a visible protection classification. It does not satisfy the specified requirement 1.
C:Misses requirement 2: 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 2.
D:Misses requirement 1: Published label definitions are not automatically available to every user and workload. The substituted action, Review the label's supported downstream protection and export behavior., is suited to a different situation: A report export must retain appropriate information protection when moved into a supported Office format. It does not satisfy the specified requirement 1.
Question 566
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A report owner cannot certify a shared dataset because they lack the required organizational authority. (2) A project shares an endorsed data product but consumers still receive an access denied message. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Route certification through the designated Fabric certification administrators or approved process. | (2) Apply certified endorsement only through the organization's authorized certification process.
- (1) Validate freshness and correctness independently of item endorsement. | (2) Check share permissions and underlying dataset security in addition to endorsement.
- (1) Route certification through the designated Fabric certification administrators or approved process. | (2) Check share permissions and underlying dataset security in addition to endorsement.
- (1) Promote the trusted Fabric item through the supported endorsement action. | (2) Check share permissions and underlying dataset security in addition to endorsement.
Explanation
Correct Answer
C:Requirement 1: The certification privilege can be governed separately from item creation. Requirement 2: 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 2: 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 2.
B:Misses requirement 1: The certification privilege can be governed separately from item creation. The substituted action, Validate freshness and correctness independently of item endorsement., is suited to a different situation: A recently promoted dataset has stale calculations and analysts assume the badge guarantees accuracy. It does not satisfy the specified requirement 1.
D:Misses requirement 1: The certification privilege can be governed separately from item creation. The substituted action, Promote the trusted Fabric item through the supported endorsement action., is suited to a different situation: Several reports appear in the catalog and consumers need to identify their team's recommended version. It does not satisfy the specified requirement 1.
Question 567
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A lakehouse SQL endpoint shows different security behavior when switching from delegated to user identity. (2) A data owner grants ReadAll on a restricted lakehouse and assumes a later fine-grained role automatically reduces it. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Review the SQL endpoint access mode and its governing security policy before changing it. | (2) Review effective broad ReadAll grants before relying on restrictive OneLake roles.
- (1) Evaluate item administration and OneLake data role evaluation separately. | (2) Review effective broad ReadAll grants before relying on restrictive OneLake roles.
- (1) Review the SQL endpoint access mode and its governing security policy before changing it. | (2) Grant scoped OneLake security data access for the table when supported.
- (1) Define supported row restrictions at the data plane or semantic model. | (2) Review effective broad ReadAll grants before relying on restrictive OneLake roles.
Explanation
Correct Answer
A:Requirement 1: User identity and delegated identity evaluate permissions through different paths. Requirement 2: 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
B:Misses requirement 1: User identity and delegated identity evaluate permissions through different paths. The substituted action, Evaluate item administration and OneLake data role evaluation separately., is suited to a different situation: A user can manage a lakehouse item but is surprised by a restricted table governed through OneLake security. It does not satisfy the specified requirement 1.
C:Misses requirement 2: 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 2.
D:Misses requirement 1: User identity and delegated identity evaluate permissions through different paths. The substituted action, Define supported row restrictions at the data plane or semantic model., is suited to a different situation: A workspace role gives an engineer item creation rights, but an owner wants to restrict customer rows in all queries. It does not satisfy the specified requirement 1.
Question 568
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) An external analyst requests permission to update Power BI semantic measures despite only needing read access. (2) A partner's guest account is disabled but an active service principal continues to consume shared data. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Grant read or Build access as needed while withholding edit or workspace-author rights. | (2) Validate the report and semantic model permission chain for the external principal.
- (1) Replace organization-wide sharing with a governed access group and owner approval. | (2) Audit nonhuman and user principals separately and revoke the no-longer-approved data grants.
- (1) Grant read or Build access as needed while withholding edit or workspace-author rights. | (2) 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) Audit nonhuman and user principals separately and revoke the no-longer-approved data grants.
Explanation
Correct Answer
C:Requirement 1: The principle of least privilege separates querying a model from changing its definitions. Requirement 2: 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 2: 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 2.
B:Misses requirement 1: The principle of least privilege separates querying a model from changing its definitions. The substituted action, Replace organization-wide sharing with a governed access group and owner approval., is suited to a different situation: A user shares a dataset to the entire company to avoid handling access requests. It does not satisfy the specified requirement 1.
D:Misses requirement 1: The principle of least privilege separates querying a model from changing its definitions. The substituted action, Create an explicitly time-bound, narrowly scoped external access grant., is suited to a different situation: A temporary external consultant needs a single published dashboard for a two-week engagement. It does not satisfy the specified requirement 1.
Question 569
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A production report is shared using an unreviewed link and the team needs an access history. (2) A policy team needs to prevent new confidential datasets from being published without classification. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Review sharing changes and relevant audit logs, then document the authorized audience. | (2) 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) Configure applicable governance controls and review compliance rather than relying on naming.
- (1) Review sharing changes and relevant audit logs, then document the authorized audience. | (2) Query the supported inventory or governance catalog filtered by item label.
- (1) Export and review effective role membership and data permission assignments. | (2) Configure applicable governance controls and review compliance rather than relying on naming.
Explanation
Correct Answer
A:Requirement 1: Governance review connects a sharing event to traceable ownership and approval. Requirement 2: 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
B:Misses requirement 1: Governance review connects a sharing event to traceable ownership and approval. The substituted action, Inspect supported Fabric or Microsoft 365 audit events and version history., is suited to a different situation: A regulated team must demonstrate who changed a semantic model and when. It does not satisfy the specified requirement 1.
C:Misses requirement 2: 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 2.
D:Misses requirement 1: Governance review connects a sharing event to traceable ownership and approval. The substituted action, Export and review effective role membership and data permission assignments., is suited to a different situation: A storage owner wants evidence of which security roles currently grant access to a sensitive table. It does not satisfy the specified requirement 1.
Question 570
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A report consumer has Build permission but cannot connect to a protected source lakehouse. (2) A team combines OneLake table access rules and semantic RLS and sees unexpected effective filters. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Inspect the data source access model and the required model connection identity. | (2) Verify the consuming identity's RLS and OneLake security roles.
- (1) Verify the effective connection identity and model security before assuming delegated per-user filtering. | (2) Test the intersection of effective model restrictions and OneLake security for each principal.
- (1) Inspect the data source access model and the required model connection identity. | (2) 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) Test the intersection of effective model restrictions and OneLake security for each principal.
Explanation
Correct Answer
C:Requirement 1: Build authorizes model reuse, not necessarily read rights on separate source items. Requirement 2: 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 2: 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 2.
B:Misses requirement 1: Build authorizes model reuse, not necessarily read rights on separate source items. The substituted action, Verify the effective connection identity and model security before assuming delegated per-user filtering., is suited to a different situation: A semantic model uses a fixed cloud connection identity and an architect assumes every reader's SQL RLS is applied automatically. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Build authorizes model reuse, not necessarily read rights on separate source items. The substituted action, Check the semantic model's own access permissions and required credentials., is suited to a different situation: A user can query a warehouse via SQL but receives an error opening its semantic model. It does not satisfy the specified requirement 1.
Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Practice Tests