MB-910 Describe Dynamics 365 Customer Insights Practice Question
A marketing manager wants to use Dynamics 365 Customer Insights to create a unified customer profile from transactional data stored in Azure SQL Database and engagement data from Dynamics 365 Marketing. Which data source type should they configure in Customer Insights - Data to connect to the Azure SQL Database?
⚠ Common exam trap
It's easy for candidates to confuse 'Power Query Online' as a data source type instead of recognizing it as the transformation engine used within connectors, leading them to select it over the specific Azure SQL Database 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
✓
Azure SQL Database connector
The Azure SQL Database connector is the correct data source type because it directly ingests transactional data from Azure SQL Database into Customer Insights - Data, enabling the creation of unified customer profiles. This connector supports incremental updates and schema mapping, which are essential for merging transactional data with engagement data from Dynamics 365 Marketing.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Azure SQL Database connector
Why this is correct
Customer Insights - Data includes a native Azure SQL Database connector.
- ✗
Export destination
Why it's wrong here
Export destinations are for outputting unified profiles, not for ingesting data.
- ✗
Common Data Model folder
Why it's wrong here
Common Data Model folder is a storage schema, not a data source type.
- ✗
Power Query Online
Why it's wrong here
Power Query Online is a transformation tool, not a data source connector.
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.