Correct Answers: B, C and E
For Power Platform projects, you should consider storing all data in the Dataverse. The Dataverse provides not only the storage for various data types but also rich business logic, security, data, and integration functionality. You can use the Dataverse API to access data in the Dataverse outside the Power Platform. Or you can copy the data to the Dataverse from other sources.
If you need to use data from other sources in the Power Apps project, several tools will help you. These tools include the Connectors, Virtual tables, and Dataflows. Power Platform provides 400+ out-of-the-box connectors, including the SQL Server Connector. This connector allows you to connect to Azure SQL Database and SQL Server running on-premises. The Virtual table creates the representation of non-Dataverse data sources inside the Dataverse in a table form. You can read and write the data in a virtual table, and the Dataverse takes care of the data synchronization. The Dataflows help you extract, transform, and load (ETL) data from any source and bring it to the Dataverse or Azure Data Lake Storage.
Option A is incorrect because we need to create or use the Custom connector only if Microsoft does not provide the connector for the data source. Microsoft offers the SQL Connector, and we do not need to create a custom connector.
Option D is incorrect because the activity table does not provide the data integration with non-Dataverse data sources.
Option F is incorrect because the SharePoint Connector is irrelevant for the current task.
For more information about the data source type for Power Platform projects, please visit the below URLs:
https://docs.microsoft.com/en-us/learn/modules/data-modeling/4-data-store
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/virtual-entities/get-started-ve
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabase
https://docs.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365