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.
Question 571
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A repository connection uses an employee's personal identity that loses access at handover. (2) A Fabric item does not appear in the Git change list even though the workspace is connected. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Reconfigure approved connection authentication and verify continuity of authorized repository access. | (2) Verify item-type support and whether its definition is represented in Git.
- (1) Configure supported workspace Git integration with the authorized repository and branch. | (2) Verify item-type support and whether its definition is represented in Git.
- (1) Reconfigure approved connection authentication and verify continuity of authorized repository access. | (2) Check the workspace branch mapping and synchronization state before deploying.
- (1) Reconcile incoming and outgoing changes before selecting the workspace or Git version. | (2) Verify item-type support and whether its definition is represented in Git.
Explanation
Correct Answer
A:Requirement 1: Production source integrations should not depend on an employee's transient privileges. Requirement 2: Git integration supports specific item definitions, not every operational state or data file. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Production source integrations should not depend on an employee's transient privileges. The substituted action, Configure supported workspace Git integration with the authorized repository and branch., is suited to a different situation: An analytics team wants Fabric notebook and model definitions reviewed through an approved Git repository. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Git integration supports specific item definitions, not every operational state or data file. The substituted action, Check the workspace branch mapping and synchronization state before deploying., is suited to a different situation: A workspace is connected to an old Git branch and publishes an obsolete model version. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Production source integrations should not depend on an employee's transient privileges. The substituted action, Reconcile incoming and outgoing changes before selecting the workspace or Git version., is suited to a different situation: A user modifies workspace items while another engineer commits changes to the repository. It does not satisfy the specified requirement 1.
Question 572
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A developer changes data model columns and assumes Git automatically versions warehouse table rows. (2) A new feature branch contains a stale schema that conflicts with updated main. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Distinguish versioned artifact definitions from runtime datasets and storage backups. | (2) Require pull-request review and validation before merging deployment-bound changes.
- (1) Record the Git commit and deployment run identifier in the release evidence. | (2) Reconcile branch changes with the current integration branch and rerun validation.
- (1) Distinguish versioned artifact definitions from runtime datasets and storage backups. | (2) Reconcile branch changes with the current integration branch and rerun validation.
- (1) Use isolated feature branches and a reviewed merge into the approved main branch. | (2) Reconcile branch changes with the current integration branch and rerun validation.
Explanation
Correct Answer
C:Requirement 1: Source control is not a substitute for data retention, transactions or backup. Requirement 2: Merges can create semantic incompatibilities even when text conflicts are resolved. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Merges can create semantic incompatibilities even when text conflicts are resolved. The substituted action, Require pull-request review and validation before merging deployment-bound changes., is suited to a different situation: A production hotfix is committed without review and breaks downstream reports. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Source control is not a substitute for data retention, transactions or backup. The substituted action, Record the Git commit and deployment run identifier in the release evidence., is suited to a different situation: A change is deployed but its commit cannot be linked to the released workspace state. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Source control is not a substitute for data retention, transactions or backup. The substituted action, Use isolated feature branches and a reviewed merge into the approved main branch., is suited to a different situation: Two developers need to edit semantic models concurrently without overwriting the main branch. It does not satisfy the specified requirement 1.
Question 573
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) Two developers hand-edit related PBIP files and a merge produces invalid references. (2) A compliance process requires a readable history of changes to a published semantic model. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Open and validate the merged PBIP project before publishing its model. | (2) Commit supported PBIP model definition changes with documented reviews.
- (1) Save the solution as a supported Power BI Desktop project (.pbip). | (2) Commit supported PBIP model definition changes with documented reviews.
- (1) Open and validate the merged PBIP project before publishing its model. | (2) Include the required model and report definition artifacts in source control.
- (1) Validate connection configuration and required environment settings after opening the project. | (2) Commit supported PBIP model definition changes with documented reviews.
Explanation
Correct Answer
A:Requirement 1: A syntactically merged repository can still contain broken model-to-report dependencies. Requirement 2: Text-based project definitions support version comparison and accountability. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: A syntactically merged repository can still contain broken model-to-report dependencies. The substituted action, Save the solution as a supported Power BI Desktop project (.pbip)., is suited to a different situation: An engineering team wants semantic-model and report definitions stored as reviewable project files. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Text-based project definitions support version comparison and accountability. The substituted action, Include the required model and report definition artifacts in source control., is suited to a different situation: A contributor checks in a PBIP project but omits its semantic-model folder. It does not satisfy the specified requirement 2.
D:Misses requirement 1: A syntactically merged repository can still contain broken model-to-report dependencies. The substituted action, Validate connection configuration and required environment settings after opening the project., is suited to a different situation: A PBIP project opens locally but its referenced development data source is unavailable in testing. It does not satisfy the specified requirement 1.
Question 574
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A release manager wants to compare changes before overriding the target production workspace. (2) A test workspace contains experimental items that should not be released. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Review deployment pipeline change and dependency comparisons before confirming promotion. | (2) Inspect related item changes and deployment dependencies before promoting the release.
- (1) Plan data movement and persistence separately from supported item deployment. | (2) Select only approved supported items for the deployment where selective deployment is available.
- (1) Review deployment pipeline change and dependency comparisons before confirming promotion. | (2) Select only approved supported items for the deployment where selective deployment is available.
- (1) Configure Fabric deployment pipeline stages and assign the appropriate workspaces. | (2) Select only approved supported items for the deployment where selective deployment is available.
Explanation
Correct Answer
C:Requirement 1: Predeployment comparison reduces accidental replacement of valid target artifacts. Requirement 2: Deployment scope must reflect the release manifest rather than every test artifact. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Deployment scope must reflect the release manifest rather than every test artifact. The substituted action, Inspect related item changes and deployment dependencies before promoting the release., is suited to a different situation: A deployment sends a tested report to production but the semantic model is still outdated. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Predeployment comparison reduces accidental replacement of valid target artifacts. The substituted action, Plan data movement and persistence separately from supported item deployment., is suited to a different situation: A team thinks a Fabric deployment pipeline always migrates the entire dataset history along with definitions. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Predeployment comparison reduces accidental replacement of valid target artifacts. The substituted action, Configure Fabric deployment pipeline stages and assign the appropriate workspaces., is suited to a different situation: A model must move through development, test and production without manually copying files. It does not satisfy the specified requirement 1.
Question 575
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A production release works when manually patched but a redeployment restores test settings. (2) A workspace owner changes the production connection identity after deployment and refresh now fails. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Record and validate persistent environment rules as part of the pipeline. | (2) Validate postdeployment credentials and authorization for the target connection.
- (1) Configure supported deployment rules or target connections for the production environment. | (2) Validate postdeployment credentials and authorization for the target connection.
- (1) Record and validate persistent environment rules as part of the pipeline. | (2) Define supported pipeline parameter rules for the relevant item and stage.
- (1) Check item and rule support rather than assuming every artifact has identical override capabilities. | (2) Validate postdeployment credentials and authorization for the target connection.
Explanation
Correct Answer
A:Requirement 1: Ad hoc target edits are not a reliable substitute for repeatable deployment configuration. Requirement 2: A correct endpoint parameter still requires a valid identity and permissions. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Ad hoc target edits are not a reliable substitute for repeatable deployment configuration. The substituted action, Configure supported deployment rules or target connections for the production environment., is suited to a different situation: A semantic model points to a development SQL endpoint after promotion into production. It does not satisfy the specified requirement 1.
C:Misses requirement 2: A correct endpoint parameter still requires a valid identity and permissions. The substituted action, Define supported pipeline parameter rules for the relevant item and stage., is suited to a different situation: A report's parameter value must differ across development and test workspaces. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Ad hoc target edits are not a reliable substitute for repeatable deployment configuration. The substituted action, Check item and rule support rather than assuming every artifact has identical override capabilities., is suited to a different situation: A deployment rule cannot be applied to an item type that is unsupported in the selected pipeline. It does not satisfy the specified requirement 1.
Question 576
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A workspace rename is proposed and stakeholders assume the dashboard visuals are the only dependency. (2) A deployment completed but key reports are failing because a dependent artifact was not promoted. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Review cross-item relationships and external references before renaming. | (2) Map the dataflow's downstream dependencies before deletion.
- (1) Trace dependency paths from the table through views and the semantic model. | (2) Compare deployed dependency versions and repair missing upstream items.
- (1) Review cross-item relationships and external references before renaming. | (2) Compare deployed dependency versions and repair missing upstream items.
- (1) Inspect Fabric lineage and impact analysis for dependent models and reports. | (2) Compare deployed dependency versions and repair missing upstream items.
Explanation
Correct Answer
C:Requirement 1: Not all dependencies are visible in the report canvas. Requirement 2: A release can pass item upload yet fail at runtime when its dependency graph is incomplete. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: A release can pass item upload yet fail at runtime when its dependency graph is incomplete. The substituted action, Map the dataflow's downstream dependencies before deletion., is suited to a different situation: A dataflow will be retired but its downstream semantic model still refreshes daily. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Not all dependencies are visible in the report canvas. The substituted action, Trace dependency paths from the table through views and the semantic model., is suited to a different situation: A lakehouse table is used by several warehouse views and a model author plans a type change. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Not all dependencies are visible in the report canvas. The substituted action, Inspect Fabric lineage and impact analysis for dependent models and reports., is suited to a different situation: A source warehouse column will be renamed and the team cannot identify affected downstream reports. It does not satisfy the specified requirement 1.
Question 577
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A model automation script must update a measure but not replace unrelated report assets. (2) An XMLA change adds a model table and reports fail because the new table has no processed data. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Target the semantic model metadata through supported XMLA operations. | (2) Process or refresh the affected model partitions after applying metadata changes.
- (1) Use the capacity and workspace XMLA endpoint with appropriate read/write settings and permissions. | (2) Process or refresh the affected model partitions after applying metadata changes.
- (1) Target the semantic model metadata through supported XMLA operations. | (2) Verify tenant settings, capacity XMLA configuration and principal access rights.
- (1) Treat model metadata deployment and data processing or refresh as separate tasks. | (2) Process or refresh the affected model partitions after applying metadata changes.
Explanation
Correct Answer
A:Requirement 1: Tabular metadata changes can be scoped without redeploying a whole reporting workspace. Requirement 2: Model schema availability and populated queryable data are separate lifecycle states. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Tabular metadata changes can be scoped without redeploying a whole reporting workspace. The substituted action, Use the capacity and workspace XMLA endpoint with appropriate read/write settings and permissions., is suited to a different situation: An enterprise semantic model must be managed using supported external tabular-model tools. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Model schema availability and populated queryable data are separate lifecycle states. The substituted action, Verify tenant settings, capacity XMLA configuration and principal access rights., is suited to a different situation: A service principal connects to XMLA for deployment but receives an authorization error. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Tabular metadata changes can be scoped without redeploying a whole reporting workspace. The substituted action, Treat model metadata deployment and data processing or refresh as separate tasks., is suited to a different situation: A team assumes XMLA deployment will automatically refresh all imported source partitions. It does not satisfy the specified requirement 1.
Question 578
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A template is copied to a new environment and still points to old dataset locations. (2) A report designer mistakenly treats a PBIDS connection file as an importable semantic model with measures. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Rebind required parameters and data connections when instantiating the template. | (2) Provide a supported Power BI data source (.pbids) file.
- (1) Remove sensitive credentials and use supported secure connection configuration. | (2) Use a shared semantic model or project artifact for measures, not a PBIDS pointer.
- (1) Rebind required parameters and data connections when instantiating the template. | (2) Use a shared semantic model or project artifact for measures, not a PBIDS pointer.
- (1) Create an appropriate Power BI template (.pbit) file. | (2) Use a shared semantic model or project artifact for measures, not a PBIDS pointer.
Explanation
Correct Answer
C:Requirement 1: Reusable structure does not eliminate environment-specific source setup. Requirement 2: Data source descriptors do not contain the complete analytical model. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Data source descriptors do not contain the complete analytical model. The substituted action, Provide a supported Power BI data source (.pbids) file., is suited to a different situation: A colleague needs a reusable pointer to an approved Power BI-compatible data source, not a full report. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Reusable structure does not eliminate environment-specific source setup. The substituted action, Remove sensitive credentials and use supported secure connection configuration., is suited to a different situation: A team distributes PBIT files containing development secrets in query parameters. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Reusable structure does not eliminate environment-specific source setup. The substituted action, Create an appropriate Power BI template (.pbit) file., is suited to a different situation: Consultants need to reuse a report layout and query definitions without distributing embedded data. It does not satisfy the specified requirement 1.
Question 579
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A report uses a local dataset copy even though a centrally approved model already exists. (2) A new semantic model owner wants to prevent a shared model refresh from blocking unrelated reports without knowing impact. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Connect the report to the approved shared semantic model rather than duplicating definitions. | (2) Inventory the affected reports and define refresh and dependency expectations for the shared model.
- (1) Publish a governed shared semantic model for reuse across reports. | (2) Inventory the affected reports and define refresh and dependency expectations for the shared model.
- (1) Connect the report to the approved shared semantic model rather than duplicating definitions. | (2) Grant the author the necessary Build permission on the shared semantic model.
- (1) Version and review shared semantic model changes using dependency and contract checks. | (2) Inventory the affected reports and define refresh and dependency expectations for the shared model.
Explanation
Correct Answer
A:Requirement 1: Reuse preserves consistent dimensions and certified measures across reports. Requirement 2: Operational stewardship of reusable assets includes refresh reliability and consumer communication. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Reuse preserves consistent dimensions and certified measures across reports. The substituted action, Publish a governed shared semantic model for reuse across reports., is suited to a different situation: Several reports repeat the same revenue definitions and yield inconsistent totals. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Operational stewardship of reusable assets includes refresh reliability and consumer communication. The substituted action, Grant the author the necessary Build permission on the shared semantic model., is suited to a different situation: A report author can view an approved model but cannot build a new report using its measures. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Reuse preserves consistent dimensions and certified measures across reports. The substituted action, Version and review shared semantic model changes using dependency and contract checks., is suited to a different situation: A model is shared across business units and one group changes a measure without consulting consumers. It does not satisfy the specified requirement 1.
Question 580
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A connector returns encrypted-transport errors after a database certificate changes. (2) An analytics workspace has several datasets using separate copies of the same connection settings. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Validate connection encryption and certificate trust for the updated source endpoint. | (2) Verify gateway mapping and the scheduled execution identity's data source authorization.
- (1) Move credentials into approved managed connections or secret storage and rotate the exposed secret. | (2) Standardize on an approved reusable Fabric connection where supported.
- (1) Validate connection encryption and certificate trust for the updated source endpoint. | (2) Standardize on an approved reusable Fabric connection where supported.
- (1) Create a Fabric connection with the supported source type and authorized credentials. | (2) Standardize on an approved reusable Fabric connection where supported.
Explanation
Correct Answer
C:Requirement 1: TLS trust failures require secure endpoint remediation rather than disabling verification. Requirement 2: Central connection ownership simplifies credential rotation and consistent configuration. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Central connection ownership simplifies credential rotation and consistent configuration. The substituted action, Verify gateway mapping and the scheduled execution identity's data source authorization., is suited to a different situation: A gateway-based source works for one developer but fails when a scheduled service job runs. It does not satisfy the specified requirement 2.
B:Misses requirement 1: TLS trust failures require secure endpoint remediation rather than disabling verification. The substituted action, Move credentials into approved managed connections or secret storage and rotate the exposed secret., is suited to a different situation: An engineer stores a production database password as a literal in a notebook committed to Git. It does not satisfy the specified requirement 1.
D:Misses requirement 1: TLS trust failures require secure endpoint remediation rather than disabling verification. The substituted action, Create a Fabric connection with the supported source type and authorized credentials., is suited to a different situation: A warehouse analyst must query an external SQL source using an approved cloud connector. It does not satisfy the specified requirement 1.
Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Practice Tests