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.
Question
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)- A18% (4)
- B5% (1)
- C73% (16)
- D5% (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.
A Canvas app is an interactive user interface for users, not an automation tool for background data enrichment, though it could display enriched data.
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.
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.
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.