MB-910 Describe Dynamics 365 Customer Insights Practice Question
A company is planning to implement Dynamics 365 Customer Insights. They have customer data stored in an on-premises SQL Server database and also in Salesforce CRM. They want to unify this data in Customer Insights. Which data ingestion method should they use to bring data from both sources?
⚠ Common exam trap
Many candidates think on-premises data requires a separate ingestion method like Azure Blob Storage, not realizing that Power Query with an on-premises data gateway can directly connect to SQL Server, and that the Salesforce connector is a native Power Query connector.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use Power Query with a gateway for on-premises SQL and the Salesforce connector for Salesforce
Dynamics 365 Customer Insights uses Power Query as its primary data ingestion engine, which supports both on-premises SQL Server via an on-premises data gateway and cloud-based Salesforce CRM through a dedicated Salesforce connector. This allows the company to unify data from both sources without requiring intermediate storage or third-party tools.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use Power Query connectors for cloud data only, then use a gateway for on-premises SQL
Why it's wrong here
Power Query supports both cloud and on-premises via gateway.
- ✓
Use Power Query with a gateway for on-premises SQL and the Salesforce connector for Salesforce
Why this is correct
Both data sources can be ingested using Power Query connectors.
- ✗
Export data from SQL to Azure Blob Storage and then ingest from Blob, and use Salesforce API
Why it's wrong here
Unnecessary intermediate steps.
- ✗
Use third-party ETL tool to push data into Customer Insights via API
Why it's wrong here
While possible, not the standard recommended method.
Go deeper
Related to this question
About these practice questions
One of 941 original MB-910 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This MB-910 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the MB-910 exam.