Microsoft Power Platform Fundamentals — Question 122

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 daily -
✑ from an external Microsoft SQL Server instance.
✑ Send a report automatically to specific company executives.
✑ Ensure that opportunities over a specified amount are approved by a sales manager.
Which two tools or components should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Answer options

• A. Microsoft Excel
• B. Microsoft Word
• C. Power BI
• D. Microsoft Dataverse
• E. Power Automate

Correct answer: C, E

Explanation

Power BI is the correct choice for creating and sharing reports automatically, which aligns with the need to send reports to executives. Power Automate facilitates the daily synchronization of data and the approval process for opportunities, making it essential for the solution. The other options, Microsoft Excel and Word, do not provide the necessary functionalities for automation and data integration required in this scenario.