nerdexam
Microsoft

PL-400 · Question #306

Case Study 7 - Northwind Traders Background Northwind Traders uses Microsoft Dynamics 365 Sales to manage its sales process. To better understand its customers, Northwind Traders invests in a team…

The correct answer is C. Power Automate flow that uses the custom connector. A Power Automate flow utilizing the custom connector is the most suitable method to automate the process of retrieving data from Azure SQL Database and enriching Dynamics 365 account records.

Submitted by noor.lb· Apr 18, 2026

Question

Case Study 7 - Northwind Traders Background Northwind Traders uses Microsoft Dynamics 365 Sales to manage its sales process. To better understand its customers, Northwind Traders invests in a team of researchers who gather data from multiple sources. The company stores the data it collects in a Microsoft Azure SQL Database. The company plans to use the data to enrich account records and make the sales team more effective. Current environment Environment - The company has three Microsoft Power Platform environments with Dynamics 365 Sales installed. The environments are named development, test, and production. - Each environment has an application user that can be used for integrations. - The company must use solutions to perform all customization and configuration deployment. Data - Researchers are responsible for creating account records. - Researchers have permissions on the Account table to create records, read all records, and update records they own. - A synchronous plug-in runs when an account record is created and could reassign the record to a different user. - Users must access data as themselves to enforce security and audit changes. - A column named new_dataid is added to the Account table. The column uniquely identifies which data it should receive. - Researchers have researched only the top 20 percent of account records. Web API - The company creates an Azure Function to run a RESTful .NET Web API. - Data can be retrieved by placing a GET request to the URL https://dataservice- [ENVIRONMENTNAME].azurewebsites.net/enrich/[DATAID]. - [ENVIRONMENTNAME] is the name of the Microsoft Power Platform environment that requests the data. - [DATAID] is the new_dataid column in the Account table. • The Web API response will return a 200 response plus data if the DataId is found. Otherwise, a 404 response is returned. • Developers plan to create a custom connector from the Web API to make it accessible from Microsoft Power Platform. Requirements Custom connector - The Web API definition used to create the custom connector must be generated based on a low-code technology. - The URL used by the custom connector must incorporate the current environment name without hardcoding values. - Errors generated by the custom connector must not cause downstream processes to fail. - Text descriptions and field placeholder text that describe the use of the custom connector must appear for non-developers. Process - All account records must be updated with data from the Web API once automatically. - Only account records that contain a DataId should be updated by the Web API. - Researchers must create Power Automate flows to specify data analysis priority. - The researchers require a process that repurposes a set of identical steps of parameterized Microsoft Dataverse queries from a Power Automate flow for use in other flows that have different parameters. The researchers want to avoid recreating the steps manually each time they create a flow to save time and avoid errors. Issues - A tester attempts to connect to the production instance of the Web API with a DataId that should return data. The tester receives an error stating that the remote name could not be resolved. - A missing component causes an error to occur when importing the solution that contains the Power Automate flow to update account records in a test environment. You need to choose a technology to access the Web API. Which technology should you select?

Options

  • ACanvas app that uses the custom connector
  • BPlug-in that contacts the Web API
  • CPower Automate flow that uses the custom connector
  • DWebhook that contacts the Web API

How the community answered

(22 responses)
  • A
    18% (4)
  • B
    5% (1)
  • C
    73% (16)
  • D
    5% (1)

Why each option

A Power Automate flow utilizing the custom connector is the most suitable method to automate the process of retrieving data from Azure SQL Database and enriching Dynamics 365 account records.

ACanvas app that uses the custom connector

A Canvas app is an interactive user interface for users, not an automation tool for background data enrichment, though it could display enriched data.

BPlug-in that contacts the Web API

A plug-in involves custom code which the general requirements aim to minimize; Power Automate with a custom connector provides a low-code alternative for integration and automation.

CPower Automate flow that uses the custom connectorCorrect

A Power Automate flow can be triggered on a schedule or event, use the custom connector to access Azure SQL Database, and then process and update Dynamics 365 account records, effectively enriching them as required.

DWebhook that contacts the Web API

A webhook is typically used for sending notifications from Dynamics 365 to an external service when an event occurs, not for initiating a data pull from an external database to enrich records within Dynamics 365.

Concept tested: Power Automate for Data Integration and Automation

Source: https://learn.microsoft.com/en-us/power-automate/overview-cloud

Community Discussion

No community discussion yet for this question.

Full PL-400 Practice