PL-900 · Question #71
A company uses Microsoft 365, SharePoint Online, and Dynamics 365 Sales. You need to recommend tools to build a solution that meets the following requirements: - Synchronize data from an external…
The correct answer is D. Microsoft Dataverse E. Power Automate. Two tools address all three requirements: Microsoft Dataverse (D) can synchronize data from an external SQL Server instance using virtual tables or Azure Synapse Link, serving as the unified data layer. Power Automate (E) handles the remaining two requirements - it can…
Question
Options
- AMicrosoft Excel
- BMicrosoft Word
- CPower BI
- DMicrosoft Dataverse
- EPower Automate
How the community answered
(41 responses)- A10% (4)
- B5% (2)
- C15% (6)
- D71% (29)
Explanation
Two tools address all three requirements: Microsoft Dataverse (D) can synchronize data from an external SQL Server instance using virtual tables or Azure Synapse Link, serving as the unified data layer. Power Automate (E) handles the remaining two requirements - it can automatically send scheduled reports to specific executives and implement approval workflows to ensure opportunities above a set amount are reviewed by a sales manager before progressing. Microsoft Excel (A) and Word (B) are document tools, not integration or automation platforms. Power BI (C) is excellent for visualization but does not natively sync SQL Server data into Dataverse or handle approval logic.
Topics
Community Discussion
No community discussion yet for this question.