Priscilla is an enterprise architect at Fenway Consulting advising a client on which data sources can be surfaced to a Copilot Studio agent through prebuilt Copilot connectors without building custom connectors. The client has four data repositories they want to make available: (1) SharePoint Online document libraries, (2) Microsoft Graph-indexed content from Teams channels, (3) A legacy on-premises Oracle database, (4) ServiceNow incident records. Which of the following correctly identifies which sources are natively supported by prebuilt Copilot connectors?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Copilot connectors cover cloud-based enterprise SaaS platforms — SharePoint, Teams/Graph, and ServiceNow are all in the gallery. An on-premises Oracle database isn't a SaaS cloud service, so it needs custom connector work with an on-premises data gateway bridge. Answer: B.
Full explanation below image
Full Explanation
Copilot connectors in Microsoft Copilot Studio are designed to surface data from cloud-based enterprise platforms that expose searchable APIs or Microsoft Graph integrations. The Copilot connector gallery grows over time, but understanding which sources are natively supported helps architects set realistic expectations.
Option B is correct. Microsoft provides prebuilt Copilot connectors for Microsoft 365 content surfaces including SharePoint Online (document libraries and sites), Microsoft Teams (including channel messages and meeting content indexed via Microsoft Graph), and major SaaS enterprise platforms including ServiceNow. These connectors handle authentication, search API calls, and result formatting automatically.
The on-premises Oracle database is the exception. On-premises databases are not SaaS cloud services — they run inside private networks and require either a custom connector (using Power Platform's custom connector wizard with an On-Premises Data Gateway to route traffic) or an API layer (such as an Azure API Management façade in front of an on-premises SQL gateway). Neither approach uses a prebuilt Copilot connector.
Option A is incorrect because Oracle does not have a prebuilt Copilot connector. On-premises systems generally require custom integration work.
Option C is incorrect because it severely understates the Copilot connector ecosystem. Beyond SharePoint, the gallery includes Teams/Graph, ServiceNow, Salesforce, Confluence, and other enterprise SaaS platforms.
Option D is incorrect on two counts: Teams content IS available through Copilot connectors via Microsoft Graph, and ServiceNow does not require a paid marketplace add-on — its connector is available in the standard Copilot connector gallery.
Exam tip: Copilot connectors are for cloud SaaS platforms with accessible APIs. On-premises systems, legacy databases, and custom APIs require custom connectors or API layers. Know this boundary — it is a recurring exam theme.