All Practice Exams

100+ Free MB-260 Practice Questions

Pass your Microsoft Dynamics 365 Customer Insights Data Specialist (MB-260) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
~70% Pass Rate
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

A retailer wants to bring loyalty data from an Azure SQL database into Customer Insights - Data without copying the rows into Dataverse. Which data source connector type best matches this need?

A
B
C
D
to track
2026 Statistics

Key Facts: MB-260 Exam

40-60 Q

Typical Questions

Microsoft role-based exam guidance

700/1000

Passing Score

Microsoft (scaled)

100 min

Exam Duration

Microsoft

US$165

U.S. Exam Fee

Microsoft pricing

25-30%

Top Domains

Microsoft Learn skills outline

1 year

Validity

Free renewal on Microsoft Learn

MB-260 is a Microsoft specialty exam delivered through Pearson VUE/OnVUE with a scaled passing score of 700/1000, typically 40-60 questions, and 100 minutes of exam time. The current Microsoft Learn skills outline weights Configure Customer Insights - Data and Ingest data at 25-30% each, Create unified profiles at 15-20%, Enhance data and predictions at 15-20%, and Manage segments and measures at 10-15%. The U.S. exam fee is US$165 and the credential is renewed annually for free on Microsoft Learn.

Sample MB-260 Practice Questions

Try these sample questions to test your MB-260 exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1A retailer wants to bring loyalty data from an Azure SQL database into Customer Insights - Data without copying the rows into Dataverse. Which data source connector type best matches this need?
A.Azure SQL Database connector via Power Query
B.Common Data Model folder in Azure Data Lake Storage Gen2
C.Synapse Link from Dataverse
D.Manual CSV upload
Explanation: The Azure SQL Database connector in Power Query lets Customer Insights - Data ingest tables directly from Azure SQL on a refresh schedule. CDM folders, Synapse Link, and CSV uploads do not connect live to an Azure SQL source.
2An admin needs to ingest tables stored as Common Data Model folders that already include a model.json schema. Which connector should be selected when adding the data source in Customer Insights - Data?
A.Azure Data Lake Storage Gen2 with Common Data Model
B.Power Query SQL connector
C.Salesforce connector
D.Dataverse connector
Explanation: When a data lake already contains CDM-formatted folders with model.json metadata, the Azure Data Lake Storage Gen2 with Common Data Model option uses that schema directly so attributes and relationships are recognized without manual mapping.
3A specialist wants Dataverse tables to be available in Customer Insights - Data with the lowest configuration overhead and near real-time updates. Which option should be used?
A.Connect to Dataverse via the built-in Dataverse data source option
B.Export Dataverse data nightly to CSV and upload to Power Query
C.Use the Salesforce connector against Dataverse
D.Re-create each Dataverse table manually as a custom entity
Explanation: Customer Insights - Data has a native Dataverse data source that consumes Dataverse tables directly. It is faster to configure and refreshes more frequently than nightly file exports, and it does not require rebuilding schemas.
4A B2C insurance company needs to ingest contact data from Salesforce Sales Cloud. Which approach matches the supported integration in Customer Insights - Data?
A.Add a Salesforce data source through Power Query connectors
B.Export each Salesforce report manually as XML and import
C.Use the Adobe Experience Platform connector against Salesforce
D.Forward Salesforce events through Event Grid only
Explanation: Customer Insights - Data ingests Salesforce records through the Salesforce connector available in Power Query when defining a new data source. The other options either require manual work or use connectors meant for other systems.
5A team uses Power Query in Customer Insights - Data to remove sensitive columns and convert data types before ingestion. Which language underlies these data preparation steps?
A.M (Power Query Formula Language)
B.DAX
C.T-SQL
D.Python
Explanation: Power Query queries are written in the M formula language. DAX is used for calculated columns and measures in Power BI/Dataverse, T-SQL targets relational databases, and Python is not the native Power Query language.
6An analyst is preparing a customer table where the primary key column is named CustomerID. During ingestion, what must the analyst confirm in the schema mapping step?
A.A primary key is identified for the table
B.The table has fewer than 10 columns
C.All columns are converted to text
D.The table is renamed to match a Dataverse table
Explanation: Each ingested entity must have a designated primary key so Customer Insights - Data can use it for joins, unification, and downstream processing. Column counts, type coercion to text, or renaming to Dataverse names are not requirements.
7Which storage option does Customer Insights - Data use by default to persist ingested data in CDM format?
A.Microsoft-managed Azure Data Lake Storage Gen2
B.Azure Cosmos DB
C.Azure SQL Hyperscale
D.Local Dataverse only
Explanation: By default, Customer Insights - Data stores its ingested tables in a Microsoft-managed Azure Data Lake Storage Gen2 account in CDM folder format. Customers can also bring their own storage, but the default is the managed lake.
8An organization wants to keep all Customer Insights - Data output inside their own Azure subscription for governance. Which configuration option should be enabled when creating the environment?
A.Bring your own Azure Data Lake Storage Gen2 account
B.Use only Power Query data sources
C.Disable enrichments
D.Switch to a managed Azure SQL Database
Explanation: Customer Insights - Data supports bring-your-own-storage to an Azure Data Lake Storage Gen2 account in the customer's subscription. This keeps unified profile data inside the customer's tenant for governance and lifecycle control.
9A business expects to manage both consumer customers and business accounts in separate environments. Which environment type should be created for the consumer scenario?
A.B2C Customer Insights - Data environment
B.B2B Customer Insights - Data environment
C.Power BI workspace
D.Customer Insights - Journeys instance
Explanation: Customer Insights - Data offers a B2C environment focused on individual consumer profiles, while B2B environments are tuned for account-based unification. The other options are not Customer Insights - Data environments.
10What does the Schema Map step let an admin do for a newly added entity in Customer Insights - Data?
A.Identify the entity, attributes, primary key, and semantic types
B.Run match rules across all data sources
C.Train a custom Azure ML model
D.Schedule the export to Mailchimp
Explanation: Schema Map is where the entity is described, attributes are confirmed and tagged with semantic types, and the primary key is set. Match rules, model training, and export scheduling happen in other workspaces.

About the MB-260 Exam

The Microsoft Dynamics 365 Customer Insights Data Specialist (MB-260) exam validates the skills required to implement Microsoft Dynamics 365 Customer Insights - Data. Candidates configure environments, ingest data from sources such as Azure Data Lake Storage Gen2, Dataverse, Salesforce, and Power Query connectors, prepare and map data, run unification with match and merge rules, build measures and segments, configure prebuilt and custom predictions, enrich profiles with Microsoft and partner data, and export profiles to Dynamics 365 apps, marketing platforms, and custom destinations.

Questions

50 scored questions

Time Limit

100 minutes

Passing Score

700/1000 (scaled)

Exam Fee

US$165 (United States; varies by region) (Microsoft)

MB-260 Exam Content Outline

25-30%

Configure Customer Insights - Data

Create and manage B2C and B2B environments, choose Microsoft-managed or bring-your-own Azure Data Lake Storage Gen2, manage roles in Microsoft Entra ID, configure DLP policies and audit logs, set system and per-source refresh schedules, monitor system status, and connect Customer Insights - Data to Dynamics 365 Sales, Customer Service, Field Service, and Customer Insights - Journeys.

25-30%

Ingest data

Add data sources via Power Query connectors (Azure SQL, Salesforce, Dataverse, SFTP file formats), Common Data Model folders in Azure Data Lake Storage Gen2, Synapse Link for Dataverse, and Adobe Experience Platform; transform data with Power Query M; complete Schema Map by setting primary keys, semantic types, and required attributes.

15-20%

Create unified profiles

Run the unification process: select source fields, deduplicate within a source, define match rules with exact and fuzzy match thresholds, set merge rules and source priority for conflict resolution, generate the unified Customer entity, configure UnifiedActivity for the timeline, and maintain alternateKeys for source-system identifiers.

15-20%

Enhance data and predictions

Add Microsoft enrichments (brand affinity, interests, demographics, location, company), partner enrichments (LiveRamp, AccuWeather, Experian), and custom enrichments via Azure Machine Learning; configure prebuilt predictions for subscription churn, transactional churn, customer lifetime value, and product recommendations; build custom predictions with Azure ML pipeline endpoints; use Copilot AI for natural language segments and customer summaries.

10-15%

Manage segments and measures

Create entity-level (business) measures and customer-level measures with DAX-like expressions, build calculated measures, define segments using attributes and measures, refine and exclude segments, run A/B segment splits and journey-based segments, and configure exports/destinations to Dynamics 365 apps, Adobe Marketo Engage, Mailchimp, SendGrid, Salesforce, file destinations, and custom Azure Functions.

How to Pass the MB-260 Exam

What You Need to Know

  • Passing score: 700/1000 (scaled)
  • Exam length: 50 questions
  • Time limit: 100 minutes
  • Exam fee: US$165 (United States; varies by region)

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

MB-260 Study Tips from Top Performers

1Spin up a free Microsoft Customer Insights - Data trial environment so you can practice ingestion, unification, segments, and exports in the actual product.
2Master the unification waterfall - source field selection, per-source deduplication, match rules with exact and fuzzy thresholds, merge rules with source priority, and the unified Customer entity.
3Practice Schema Map carefully: primary key uniqueness, semantic types (Email, Phone, Name), and how those choices affect later matching and enrichment.
4Know the difference between business (entity-level) measures, customer-level measures, and calculated measures, and recognize when each is appropriate.
5Memorize which prebuilt predictions exist (subscription churn, transactional churn, customer lifetime value, product recommendation) and what data each requires.
6Be fluent in destinations: Dynamics 365 apps, Mailchimp, SendGrid, Salesforce, Adobe Marketo Engage, file export to Azure Data Lake, and custom Azure Functions destinations.
7Understand the B2C vs B2B environment difference, especially the contact-account hierarchy in B2B and account-based unification.
8Review governance topics together: Microsoft Entra roles, RBAC inside Customer Insights - Data, Power Platform DLP policies, and audit logs.

Frequently Asked Questions

What is the MB-260 exam?

MB-260 is the Microsoft Dynamics 365 Customer Insights Data Specialist exam. It validates the skills required to implement Microsoft Dynamics 365 Customer Insights - Data, including environment configuration, data ingestion from sources such as Azure Data Lake Storage Gen2, Dataverse, and Salesforce, schema mapping, unification with match and merge rules, measures and segments, enrichments, prebuilt and custom predictions, and exports to Dynamics 365 apps and marketing platforms.

How many questions are on the MB-260 exam and how long is it?

Microsoft does not publish a fixed MB-260 question count. Microsoft's certification guidance states most role-based exams typically contain 40-60 questions, and MB-260 is scheduled for 100 minutes. The exam uses Microsoft's scaled scoring model and requires 700 out of 1000 to pass.

What does MB-260 cost and where do I take it?

The U.S. exam fee for MB-260 is US$165 and pricing varies by region. The exam is delivered by Pearson VUE either at a test center or online with OnVUE proctoring. Registration is started from the Microsoft Learn MB-260 certification page.

What domains are weighted highest on MB-260?

Microsoft Learn currently weights Configure Customer Insights - Data and Ingest data at 25-30% each, Create unified profiles at 15-20%, Enhance data and predictions at 15-20%, and Manage segments and measures at 10-15%. Plan to spend the most study time on configuration, ingestion, and unification.

Are there prerequisites for MB-260?

There is no formal prerequisite exam. Microsoft expects candidates to have working experience with Dynamics 365 Customer Insights - Data, comfort with Power Query, basic familiarity with Azure Data Lake Storage Gen2 and Common Data Model, and a working understanding of Microsoft Entra ID, Dataverse, and connections to Dynamics 365 apps.

How is MB-260 different from a Customer Insights - Journeys exam?

MB-260 covers Customer Insights - Data: unified profiles, ingestion, unification, segmentation, measures, predictions, enrichments, and exports. Customer Insights - Journeys (formerly real-time marketing) handles event-triggered customer journeys, channels, and triggers and is covered by separate Microsoft credentials.

Does the MB-260 certification expire?

Yes. Microsoft specialty certifications, like associate ones, must be renewed annually. The renewal is free and uses an open-book Microsoft Learn assessment that can be taken in the six-month window before expiration.