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.
Question 641
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) An analytics team wants Fabric notebook and model definitions reviewed through an approved Git repository. (2) A user modifies workspace items while another engineer commits changes to the repository. (3) A Fabric item does not appear in the Git change list even though the workspace is connected. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Configure supported workspace Git integration with the authorized repository and branch. | (2) Reconcile incoming and outgoing changes before selecting the workspace or Git version. | (3) Check the workspace branch mapping and synchronization state before deploying.
- (1) Configure supported workspace Git integration with the authorized repository and branch. | (2) Reconcile incoming and outgoing changes before selecting the workspace or Git version. | (3) Verify item-type support and whether its definition is represented in Git.
- (1) Check the workspace branch mapping and synchronization state before deploying. | (2) Reconcile incoming and outgoing changes before selecting the workspace or Git version. | (3) 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) Reconfigure approved connection authentication and verify continuity of authorized repository access. | (3) Verify item-type support and whether its definition is represented in Git.
Explanation
Correct Answer
B:Requirement 1: Git integration records supported item definitions under version control for collaborative review. Requirement 2: Competing modifications require explicit review to avoid overwriting valid work. Requirement 3: 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
A:Misses requirement 3: 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 3.
C:Misses requirement 1: Git integration records supported item definitions under version control for collaborative review. 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 1.
D:Misses requirement 2: Competing modifications require explicit review to avoid overwriting valid work. The substituted action, Reconfigure approved connection authentication and verify continuity of authorized repository access., is suited to a different situation: A repository connection uses an employee's personal identity that loses access at handover. It does not satisfy the specified requirement 2.
Question 642
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) Two developers need to edit semantic models concurrently without overwriting the main branch. (2) A change is deployed but its commit cannot be linked to the released workspace state. (3) A new feature branch contains a stale schema that conflicts with updated main. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Require pull-request review and validation before merging deployment-bound changes. | (2) Record the Git commit and deployment run identifier in the release evidence. | (3) 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) Distinguish versioned artifact definitions from runtime datasets and storage backups. | (3) 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) Record the Git commit and deployment run identifier in the release evidence. | (3) Require pull-request review and validation before merging deployment-bound changes.
- (1) Use isolated feature branches and a reviewed merge into the approved main branch. | (2) Record the Git commit and deployment run identifier in the release evidence. | (3) Reconcile branch changes with the current integration branch and rerun validation.
Explanation
Correct Answer
D:Requirement 1: Branching supports parallel work and controlled integration of definition changes. Requirement 2: Traceability requires connecting source revision to the actual deployed version. Requirement 3: 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 1: Branching supports parallel work and controlled integration of definition changes. 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 1.
B:Misses requirement 2: Traceability requires connecting source revision to the actual deployed version. The substituted action, Distinguish versioned artifact definitions from runtime datasets and storage backups., is suited to a different situation: A developer changes data model columns and assumes Git automatically versions warehouse table rows. It does not satisfy the specified requirement 2.
C:Misses requirement 3: 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 3.
Question 643
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) An engineering team wants semantic-model and report definitions stored as reviewable project files. (2) A PBIP project opens locally but its referenced development data source is unavailable in testing. (3) A compliance process requires a readable history of changes to a published semantic model. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Save the solution as a supported Power BI Desktop project (.pbip). | (2) Validate connection configuration and required environment settings after opening the project. | (3) Include the required model and report definition artifacts in source control.
- (1) Save the solution as a supported Power BI Desktop project (.pbip). | (2) Validate connection configuration and required environment settings after opening the project. | (3) Commit supported PBIP model definition changes with documented reviews.
- (1) Include the required model and report definition artifacts in source control. | (2) Validate connection configuration and required environment settings after opening the project. | (3) Commit supported PBIP model definition changes with documented reviews.
- (1) Save the solution as a supported Power BI Desktop project (.pbip). | (2) Open and validate the merged PBIP project before publishing its model. | (3) Commit supported PBIP model definition changes with documented reviews.
Explanation
Correct Answer
B:Requirement 1: PBIP exposes project artifacts suitable for source-controlled collaboration. Requirement 2: Versioned definitions do not guarantee an accessible data source in every environment. Requirement 3: 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
A:Misses requirement 3: 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 3.
C:Misses requirement 1: PBIP exposes project artifacts suitable for source-controlled collaboration. 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 1.
D:Misses requirement 2: Versioned definitions do not guarantee an accessible data source in every environment. The substituted action, Open and validate the merged PBIP project before publishing its model., is suited to a different situation: Two developers hand-edit related PBIP files and a merge produces invalid references. It does not satisfy the specified requirement 2.
Question 644
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A model must move through development, test and production without manually copying files. (2) A team thinks a Fabric deployment pipeline always migrates the entire dataset history along with definitions. (3) A test workspace contains experimental items that should not be released. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Inspect related item changes and deployment dependencies before promoting the release. | (2) Plan data movement and persistence separately from supported item deployment. | (3) 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) Review deployment pipeline change and dependency comparisons before confirming promotion. | (3) 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) Plan data movement and persistence separately from supported item deployment. | (3) Inspect related item changes and deployment dependencies before promoting the release.
- (1) Configure Fabric deployment pipeline stages and assign the appropriate workspaces. | (2) Plan data movement and persistence separately from supported item deployment. | (3) Select only approved supported items for the deployment where selective deployment is available.
Explanation
Correct Answer
D:Requirement 1: Deployment pipelines promote supported item definitions through controlled lifecycle stages. Requirement 2: Deployment pipelines primarily manage the supported artifact lifecycle, not general bulk data migration. Requirement 3: 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 1: Deployment pipelines promote supported item definitions through controlled lifecycle stages. 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 1.
B:Misses requirement 2: Deployment pipelines primarily manage the supported artifact lifecycle, not general bulk data migration. The substituted action, Review deployment pipeline change and dependency comparisons before confirming promotion., is suited to a different situation: A release manager wants to compare changes before overriding the target production workspace. It does not satisfy the specified requirement 2.
C:Misses requirement 3: 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 3.
Question 645
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A semantic model points to a development SQL endpoint after promotion into production. (2) A deployment rule cannot be applied to an item type that is unsupported in the selected pipeline. (3) A workspace owner changes the production connection identity after deployment and refresh now fails. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Configure supported deployment rules or target connections for the production environment. | (2) Check item and rule support rather than assuming every artifact has identical override capabilities. | (3) Define supported pipeline parameter rules for the relevant item and stage.
- (1) Configure supported deployment rules or target connections for the production environment. | (2) Check item and rule support rather than assuming every artifact has identical override capabilities. | (3) Validate postdeployment credentials and authorization for the target connection.
- (1) Define supported pipeline parameter rules for the relevant item and stage. | (2) Check item and rule support rather than assuming every artifact has identical override capabilities. | (3) Validate postdeployment credentials and authorization for the target connection.
- (1) Configure supported deployment rules or target connections for the production environment. | (2) Record and validate persistent environment rules as part of the pipeline. | (3) Validate postdeployment credentials and authorization for the target connection.
Explanation
Correct Answer
B:Requirement 1: Environment-specific connection values must be adjusted independently of logical model definitions. Requirement 2: Deployment rules vary by artifact support and property type. Requirement 3: 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
A:Misses requirement 3: 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 3.
C:Misses requirement 1: Environment-specific connection values must be adjusted independently of logical model definitions. 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 1.
D:Misses requirement 2: Deployment rules vary by artifact support and property type. The substituted action, Record and validate persistent environment rules as part of the pipeline., is suited to a different situation: A production release works when manually patched but a redeployment restores test settings. It does not satisfy the specified requirement 2.
Question 646
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A source warehouse column will be renamed and the team cannot identify affected downstream reports. (2) A lakehouse table is used by several warehouse views and a model author plans a type change. (3) A deployment completed but key reports are failing because a dependent artifact was not promoted. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Map the dataflow's downstream dependencies before deletion. | (2) Trace dependency paths from the table through views and the semantic model. | (3) Compare deployed dependency versions and repair missing upstream items.
- (1) Inspect Fabric lineage and impact analysis for dependent models and reports. | (2) Review cross-item relationships and external references before renaming. | (3) Compare deployed dependency versions and repair missing upstream items.
- (1) Inspect Fabric lineage and impact analysis for dependent models and reports. | (2) Trace dependency paths from the table through views and the semantic model. | (3) Map the dataflow's downstream dependencies before deletion.
- (1) Inspect Fabric lineage and impact analysis for dependent models and reports. | (2) Trace dependency paths from the table through views and the semantic model. | (3) Compare deployed dependency versions and repair missing upstream items.
Explanation
Correct Answer
D:Requirement 1: Dependency review exposes consumers that may break from a source-schema change. Requirement 2: Multi-hop lineage reveals impacts beyond the nearest direct consumer. Requirement 3: 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 1: Dependency review exposes consumers that may break from a source-schema change. 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 1.
B:Misses requirement 2: Multi-hop lineage reveals impacts beyond the nearest direct consumer. The substituted action, Review cross-item relationships and external references before renaming., is suited to a different situation: A workspace rename is proposed and stakeholders assume the dashboard visuals are the only dependency. It does not satisfy the specified requirement 2.
C:Misses requirement 3: 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 3.
Question 647
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) An enterprise semantic model must be managed using supported external tabular-model tools. (2) A team assumes XMLA deployment will automatically refresh all imported source partitions. (3) An XMLA change adds a model table and reports fail because the new table has no processed data. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Use the capacity and workspace XMLA endpoint with appropriate read/write settings and permissions. | (2) Treat model metadata deployment and data processing or refresh as separate tasks. | (3) Verify tenant settings, capacity XMLA configuration and principal access rights.
- (1) Use the capacity and workspace XMLA endpoint with appropriate read/write settings and permissions. | (2) Treat model metadata deployment and data processing or refresh as separate tasks. | (3) Process or refresh the affected model partitions after applying metadata changes.
- (1) Verify tenant settings, capacity XMLA configuration and principal access rights. | (2) Treat model metadata deployment and data processing or refresh as separate tasks. | (3) 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) Target the semantic model metadata through supported XMLA operations. | (3) Process or refresh the affected model partitions after applying metadata changes.
Explanation
Correct Answer
B:Requirement 1: XMLA exposes compatible tabular model metadata for lifecycle automation. Requirement 2: Model definitions can be deployed without automatically processing all underlying data. Requirement 3: 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
A:Misses requirement 3: 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 3.
C:Misses requirement 1: XMLA exposes compatible tabular model metadata for lifecycle automation. 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 1.
D:Misses requirement 2: Model definitions can be deployed without automatically processing all underlying data. The substituted action, Target the semantic model metadata through supported XMLA operations., is suited to a different situation: A model automation script must update a measure but not replace unrelated report assets. It does not satisfy the specified requirement 2.
Question 648
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) Consultants need to reuse a report layout and query definitions without distributing embedded data. (2) A team distributes PBIT files containing development secrets in query parameters. (3) A report designer mistakenly treats a PBIDS connection file as an importable semantic model with measures. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Provide a supported Power BI data source (.pbids) file. | (2) Remove sensitive credentials and use supported secure connection configuration. | (3) Use a shared semantic model or project artifact for measures, not a PBIDS pointer.
- (1) Create an appropriate Power BI template (.pbit) file. | (2) Rebind required parameters and data connections when instantiating the template. | (3) Use a shared semantic model or project artifact for measures, not a PBIDS pointer.
- (1) Create an appropriate Power BI template (.pbit) file. | (2) Remove sensitive credentials and use supported secure connection configuration. | (3) Provide a supported Power BI data source (.pbids) file.
- (1) Create an appropriate Power BI template (.pbit) file. | (2) Remove sensitive credentials and use supported secure connection configuration. | (3) Use a shared semantic model or project artifact for measures, not a PBIDS pointer.
Explanation
Correct Answer
D:Requirement 1: PBIT can package reusable report structure while prompting for data connections. Requirement 2: A reusable template should never become an uncontrolled credential distribution channel. Requirement 3: 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 1: PBIT can package reusable report structure while prompting for data connections. 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 1.
B:Misses requirement 2: A reusable template should never become an uncontrolled credential distribution channel. The substituted action, Rebind required parameters and data connections when instantiating the template., is suited to a different situation: A template is copied to a new environment and still points to old dataset locations. It does not satisfy the specified requirement 2.
C:Misses requirement 3: 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 3.
Question 649
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) Several reports repeat the same revenue definitions and yield inconsistent totals. (2) A model is shared across business units and one group changes a measure without consulting consumers. (3) A new semantic model owner wants to prevent a shared model refresh from blocking unrelated reports without knowing impact. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Publish a governed shared semantic model for reuse across reports. | (2) Version and review shared semantic model changes using dependency and contract checks. | (3) Grant the author the necessary Build permission on the shared semantic model.
- (1) Publish a governed shared semantic model for reuse across reports. | (2) Version and review shared semantic model changes using dependency and contract checks. | (3) Inventory the affected reports and define refresh and dependency expectations for the shared model.
- (1) Grant the author the necessary Build permission on the shared semantic model. | (2) Version and review shared semantic model changes using dependency and contract checks. | (3) 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) Connect the report to the approved shared semantic model rather than duplicating definitions. | (3) Inventory the affected reports and define refresh and dependency expectations for the shared model.
Explanation
Correct Answer
B:Requirement 1: Centralizing measures reduces metric drift between independently authored reports. Requirement 2: Shared assets require change governance because one modification affects many reports. Requirement 3: 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
A:Misses requirement 3: 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 3.
C:Misses requirement 1: Centralizing measures reduces metric drift between independently authored reports. 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 1.
D:Misses requirement 2: Shared assets require change governance because one modification affects many reports. The substituted action, Connect the report to the approved shared semantic model rather than duplicating definitions., is suited to a different situation: A report uses a local dataset copy even though a centrally approved model already exists. It does not satisfy the specified requirement 2.
Question 650
A Microsoft Fabric analytics team faces 3 concurrent, independent needs in the same workstream: (1) A warehouse analyst must query an external SQL source using an approved cloud connector. (2) An engineer stores a production database password as a literal in a notebook committed to Git. (3) An analytics workspace has several datasets using separate copies of the same connection settings. Which action bundle addresses ALL 3 needs without replacing a required control with a different one?
- (1) Verify gateway mapping and the scheduled execution identity's data source authorization. | (2) Move credentials into approved managed connections or secret storage and rotate the exposed secret. | (3) Standardize on an approved reusable Fabric connection where supported.
- (1) Create a Fabric connection with the supported source type and authorized credentials. | (2) Validate connection encryption and certificate trust for the updated source endpoint. | (3) Standardize on an approved reusable Fabric connection where supported.
- (1) Create a Fabric connection with the supported source type and authorized credentials. | (2) Move credentials into approved managed connections or secret storage and rotate the exposed secret. | (3) Verify gateway mapping and the scheduled execution identity's data source authorization.
- (1) Create a Fabric connection with the supported source type and authorized credentials. | (2) Move credentials into approved managed connections or secret storage and rotate the exposed secret. | (3) Standardize on an approved reusable Fabric connection where supported.
Explanation
Correct Answer
D:Requirement 1: A connection specifies source endpoint and authentication information for governed reuse. Requirement 2: Source code is not a secure place for long-lived production credentials. Requirement 3: 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 1: A connection specifies source endpoint and authentication information for governed reuse. 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 1.
B:Misses requirement 2: Source code is not a secure place for long-lived production credentials. The substituted action, Validate connection encryption and certificate trust for the updated source endpoint., is suited to a different situation: A connector returns encrypted-transport errors after a database certificate changes. It does not satisfy the specified requirement 2.
C:Misses requirement 3: 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 3.
Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Practice Tests