A company has a legacy MS Access invoicing application that runs on Windows Server 2016. For its Power Platform solution, the company stores data in the Dataverse and Azure table. The company invites you as a Solution Architect to help automate and integrate the legacy data with the current data sources. 
What two data access types would you use in your solution design?

Answer options:

A.Azure SQL Connector
B.Azure Table Storage Connector
C.Azure Data Explorer
D.Data Gateway
E.SharePoint Connector

Correct Answers: B and D 
As a Solution Architect, you need to design automation and integration for the company’s data flow. For the automation of the legacy data, you can use the Desktop flow. Power Automate Desktop flow automates processes on legacy, modern desktop, and web applications. There are two types of Desktop flows automation on the windows desktop and the web application. The Desktop flow runs only on Windows-based machines. The device needs to run Windows 10, Windows Server 2016, or 2019. You can create a Desktop flow using Power Automate Desktop or alternative solutions involving Windows recorder and Selenium IDE. 
When you automate the Desktop flow execution using an instant flow, you need to connect your instant cloud flow with the Power Automate Desktop application running on the Windows-based device. You must install an on-premises data gateway for this purpose. Power Automate Desktop flow interacts with the application using its elements, images, and coordinates. 
Azure table provides storage for NoSQL data. For the Azure table, you need to use the Azure Table Storage Connector. You can use this connector with Power Automate and Logic Apps. 
All other options are incorrect. 
For more information about Power Platform connectors, please visit the below URLs: 

https://docs.microsoft.com/en-us/learn/modules/robotic-process-automation/1-introduction
https://docs.microsoft.com/en-us/connectors/azuretables/