QuestionQ207

Demonstrate the capabilities of Power Automate

A company uses Microsoft 365, SharePoint Online, and Microsoft Teams.

You need to recommend tools for building a solution that satisfies these requirements:

  • Synchronize data each day from an external Microsoft SQL Server instance.
  • Automatically send a report to specified company executives.
  • Ensure approvals are routed to the appropriate company executive.

Which two tools or components should you recommend? Each correct answer provides part of the solution.

NOTE: Each correct selection is worth one point.

Choose two
  • A Microsoft Excel
  • B Power Automate
  • C Microsoft Word
  • D Power BI
  • E Microsoft Dataverse
Explanation

Power BI supports scheduled refresh of SQL Server-backed report data and can email report subscriptions to specified recipients on a daily schedule. Power Automate supports workflow automation and approval actions, allowing approval requests to be assigned and routed to the appropriate executive.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!