Questions for the MB-260 were updated on : Sep 01 ,2024
DRAG DROP
You are a Customer Data Platform Specialist. You are implementing an incremental refresh in audience insights. All the data
is stored in an Azure SQL database and is ingested to audience insights using Power Query. You need to configure an
incremental refresh for data sources.
Which four actions should you perform in sequence to meet this requirement? To answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order.
Select and Place:
Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/incremental-refresh-data-
sources
You are a Customer Data Platform Specialist. The marketing team requested that customer cellphone numbers be added to
the customer profile in audience insights. The customer cellphone numbers are stored in a separate table in the Azure Gen 2
Storage Account.
You decide to create the data source(s) needed in audience insights.
Which statements best describes the steps needed to ingest the required data to audience insights?
C
Explanation:
There are three data sources containing customer profile data loaded to a dedicated storage account and container in the
Azure Data Lake. Ingesting Cell phone data- the requirement is to keep the name of the date sources aligned with the
design document. cellPhone_loyaly.csv: srcid (primary key), cellphone
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-power-query
DRAG DROP
You are a Customer Data Platform Specialist. You want to add data sources that connect to data in the organizations Azure
Data Lake. You need to enable data profiling for the entity within the data source while creating it.
Which three actions should you perform in sequence to meet this requirement? To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-common-data-model
Topic 2, Case Study 2
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete
each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure
that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study.
Case studies might contain exhibits and other resources that provide more information about the scenario that is described
in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make
changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of
the case study before you answer the questions. Clicking these buttons displays information such as business requirements,
existing environment, and problem statements. When you are ready to answer a question, click the Question button to return
to the question.
General Overview
AdventureWorks Cycles is a bicycle retailer with a few locations in the Midwest region. The AdventureWorks Cycles
business model supports both in store purchases as well as online orders. In addition to offering a wide variety of bicycles,
the company sells clothing, performance nutrition supplements, bicycle parts as well as bicycle fitting and repair services.
The customer base varies from professional cyclists, individual leisure riders to families. The business experienced
unprecedented growth of over 2000% during the pandemic bringing a total number of customers to 10,000. The company
decided to invest in Microsoft Dynamics 365 Customer Insights and Dynamics 365 Sales App to unify customer data and
improve sales.
Data Source
AdventureWorks Cycles uses Customer Insights to connect to data from three different sources to generate a unified
customer record. The data ingestion has been done for the initial data load. There are three data sources containing
customer profile data loaded to a dedicated storage account and container in the Azure Data Lake:
Loyalty data source: This data source contains customer profile information from in-store purchases.
- loyalty.member.csv: srcid (primary key), firstname, lastname, middlename, fullname, addressstreet, loyalty_email, city,
zipcode, state, homephone, datecreated, timestamp
Ecommerce Data source: This data source contains customer profile information from online purchases.
- ecom.member.csv: ecid (primary key), firstname, last name, fullname, email, homephone, streetaddress, city, zip, state,
datecreated, timestamp
Cycling Clubs Data Source: This data source contains customer profile information for members of Cycling clubs.
- cclubcust.csv: ccid (primary key) firstname, lastname, full_name, email, main phone, streetaddress1, city, zip_code, state,
datecreated, datecreated, timestamp
The Loyalty data source contains the largest and most trusted dataset. It is considered the Primary Source followed by
Ecommerce and Cycling Clubs Data Sources.
All three data sources share common customer demographics. Map, Match, and Merge (M3) rules within audience insights
are applied accordingly to generate a unified customer record.
Additionally, there are three data sources that contain customer cellphone numbers for Loyalty, Ecommerce, and Cycling
Club data sources that have been loaded to the Azure Data Lake but have not been ingested into audience insights.
cellPhone_loyaly.csv: srcid (primary key), cellphone cellPhone_ec.csv: ecid (primary key), cellphone
cellPhone_cc.csv: ccid (primary key), cellphone
Pain Points
The AdventureWorks Cycles leadership team identified several pain points that need to be addressed immediately to support
current growth and ensure customer satisfaction.
1. Lack of strategy for refreshing the customer data in the audience insights. There is a considerable effort needed to build
pipelines to flow the incremental data updates into the Azure Data Lake so it can be ingested and processed in audience
insights.
2. Customer Service reps cannot search for customers efficiently in audience insights which affects the customer
satisfaction. Also, they do not have valid cell phone numbers for customers since it is not part of the profile.
3. The Sales team uses the Dynamics 365 Sales app but are not able to use segments generated in audience insights to
generate marketing lists.
4. Marketing campaigns often sound redundant and inefficient as the same messaging is being sent to multiple members of
the same household.
5. The Marketing team cannot create fully personalized communications due to missing Full Name in the unified customer
record.
6. The test team is complaining that they do not have a dedicated UAT environment where they can test features before they
are deployed to production.
Project Goals
1. Create a strategy to implement incremental data refresh in prod audience insights that reads data from Azure Data Lake
Gen 2. In parallel configure incremental refresh in one of the non-production audience insights where all the data sources
are available, loaded from Azure SQL database, through Power Query to audience insights instance. This will allow some
testing of the incremental refresh functionality to be completed while the long-term strategy is being finalized.
2. Implement necessary changes to address the remaining pain points identified during the Leadership Team meeting.
Detailed Requirements
Pain Points
1. Configuring incremental refreshes for all customer data profiles as follows:
- Incremental data refresh should be configured for member tables only
- Timestamp data and time field should be used by the system to check when the record was last updated - All three tables
should be refreshed every two days
2. Adding additional data sources and search fields to audience insights
- Ingesting Cell phone data- the requirement is to keep the name of the date sources aligned with the design document. See
section 1 for more details.
- Furthermore, to get a quick snapshot of the quality of data, data profiling should be enabled for the phone fields only
- The following fields from the unified customer record should be added to index: Last Name, Full Name, Email, Cell Phone,
Street Address, DOB
3. Ability to use segments from the audience insights to generate marketing lists
- The Sales team needs to generate a marketing campaign based on segment of customers who have a Loyalty email.
(loyalty.email)
4. Ability to group customer profiles into a household cluster for purpose of generating targeted marketing communication
- A household cluster is defined as customers who share Last Name, Street Address, City, Zip Code and State
5. Adding Full Name field to the unified customer record
- Full Name is a merged field with the following merging policy a. loyalty.member.fullname
b. ecom.member.fullname
c. cclubcust.csv.full_name
6. Creating a sandbox environment that mirrors the current development environment - Create a sandbox environment called
UAT1 and copy configurations from env. DEV1.
a. Note: there is also an exiting environment called Dev and it is not configured correctly and should not be copied
You are a Customer Data Platform Specialist. The marketing team wants to send personalized marketing emails to
customers, but the customer FullName attribute has not been correctly populated as part of the profile unification process.
You update the Map process to include the loyalty.member.fullname, ecom.member.fullname, and
cclubcust.member.full_name fields. Then, you map the fields to the Person.FullName semantic type. Audience insights
automatically merges these fields into the FullName attribute on the Merge page.
What action should you perform to make sure the merged FullName field contains the most trusted data available?
D
Explanation:
Adding Full Name field to the unified customer record
Full Name is a merged field with the following merging policy
a. loyalty.member.fullname
b. ecom.member.fullname
c. cclubcust.csv.full_name
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/merge-entities
DRAG DROP
You are a Customer Data Platform Specialist. You are asked to create a household cluster to group profiles that share a set
of demographic data points.
Which three actions should you perform in sequence to configure a household cluster? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/merge-entities#group-
profiles-into-households-or-clusters
You are a Customer Data Platform Specialist. Dynamics 365 Customer Insights (CI) users have complained that they are not
able to quickly find customers using main demographic data points. You must ensure users are able to search customers
using any of the available fields.
Which two statements define the actions that should be completed to satisfy this requirement? Each option represents a
partial solution.
NOTE: Each correct selection is worth one point.
A B
Explanation:
The following fields from the unified customer record should be added to index: Last Name, Full Name, Email, Cell Phone,
Street Address, DOB.
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/search-filter-index
Topic 3, Case Study 3
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete
each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure
that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study.
Case studies might contain exhibits and other resources that provide more information about the scenario that is described
in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make
changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of
the case study before you answer the questions. Clicking these buttons displays information such as business requirements,
existing environment, and problem statements. When you are ready to answer a question, click the Question button to return
to the question.
General Overview
AdventureWorks Cycles is a bicycle retailer with a few locations in the Midwest region. The AdventureWorks Cycles
business model supports both in store purchases as well as online orders. In addition to offering a wide variety of bicycles,
the company sells clothing, performance nutrition supplements, bicycle parts as well as bicycle fitting and repair services.
The customer base varies from professional cyclists, individual leisure riders to families. The business experienced
unprecedented growth of over 2000% during the pandemic bringing a total number of customers to 10,000. The company
decided to invest in Microsoft Dynamics 365 Customer Insights and Dynamics 365 Sales App to unify customer data and
improve sales.
Data Source
AdventureWorks Cycles uses Customer Insights to connect to data from three different sources to generate a unified
customer record. The data ingestion has been done for the initial data load. There are three data sources containing
customer profile data loaded to a dedicated storage account and container in the Azure Data Lake:
Loyalty data source: This data source contains customer profile information from in-store purchases.
- loyalty.member.csv: srcid (primary key), firstname, lastname, middlename, fullname, addressstreet, loyalty_email, city,
zipcode, state, homephone, datecreated, timestamp
Ecommerce Data source: This data source contains customer profile information from online purchases.
- ecom.member.csv: ecid (primary key), firstname, last name, fullname, email, homephone, streetaddress, city, zip, state,
datecreated, timestamp
Cycling Clubs Data Source: This data source contains customer profile information for members of Cycling clubs.
- cclubcust.csv: ccid (primary key) firstname, lastname, full_name, email, main phone, streetaddress1, city, zip_code, state,
datecreated, datecreated, timestamp
The Loyalty data source contains the largest and most trusted dataset. It is considered the Primary Source followed by
Ecommerce and Cycling Clubs Data Sources.
All three data sources share common customer demographics. Map, Match, and Merge (M3) rules within audience insights
are applied accordingly to generate a unified customer record.
Additionally, there are three data sources that contain customer cellphone numbers for Loyalty, Ecommerce, and Cycling
Club data sources that have been loaded to the Azure Data Lake but have not been ingested into audience insights.
cellPhone_loyaly.csv: srcid (primary key), cellphone cellPhone_ec.csv: ecid (primary key), cellphone
cellPhone_cc.csv: ccid (primary key), cellphone
Pain Points
The AdventureWorks Cycles leadership team identified several pain points that need to be addressed immediately to support
current growth and ensure customer satisfaction.
1. Lack of strategy for refreshing the customer data in the audience insights. There is a considerable effort needed to build
pipelines to flow the incremental data updates into the Azure Data Lake so it can be ingested and processed in audience
insights.
2. Customer Service reps cannot search for customers efficiently in audience insights which affects the customer
satisfaction. Also, they do not have valid cell phone numbers for customers since it is not part of the profile.
3. The Sales team uses the Dynamics 365 Sales app but are not able to use segments generated in audience insights to
generate marketing lists.
4. Marketing campaigns often sound redundant and inefficient as the same messaging is being sent to multiple members of
the same household.
5. The Marketing team cannot create fully personalized communications due to missing Full Name in the unified customer
record.
6. The test team is complaining that they do not have a dedicated UAT environment where they can test features before they
are deployed to production.
Project Goals
1. Create a strategy to implement incremental data refresh in prod audience insights that reads data from Azure Data Lake
Gen 2. In parallel configure incremental refresh in one of the non-production audience insights where all the data sources
are available, loaded from Azure SQL database, through Power Query to audience insights instance. This will allow some
testing of the incremental refresh functionality to be completed while the long-term strategy is being finalized.
2. Implement necessary changes to address the remaining pain points identified during the Leadership Team meeting.
Detailed Requirements
Pain Points
1. Configuring incremental refreshes for all customer data profiles as follows:
- Incremental data refresh should be configured for member tables only
- Timestamp data and time field should be used by the system to check when the record was last updated - All three tables
should be refreshed every two days
2. Adding additional data sources and search fields to audience insights
- Ingesting Cell phone data- the requirement is to keep the name of the date sources aligned with the design document. See
section 1 for more details.
- Furthermore, to get a quick snapshot of the quality of data, data profiling should be enabled for the phone fields only
- The following fields from the unified customer record should be added to index: Last Name, Full Name, Email, Cell Phone,
Street Address, DOB
3. Ability to use segments from the audience insights to generate marketing lists
- The Sales team needs to generate a marketing campaign based on segment of customers who have a Loyalty email.
(loyalty.email)
4. Ability to group customer profiles into a household cluster for purpose of generating targeted marketing communication
- A household cluster is defined as customers who share Last Name, Street Address, City, Zip Code and State
5. Adding Full Name field to the unified customer record
- Full Name is a merged field with the following merging policy a. loyalty.member.fullname
b. ecom.member.fullname
c. cclubcust.csv.full_name
6. Creating a sandbox environment that mirrors the current development environment - Create a sandbox environment called
UAT1 and copy configurations from env. DEV1.
a. Note: there is also an exiting environment called Dev and it is not configured correctly and should not be copied
You are a Customer Data Platform Specialist. You need to design a process to share the unified customer profile with the
sales team. The sales team uses the Dynamics 365 Sales app for marketing list generation.
Which two conditions must be met to export segments needed by the sales team to the D365 Sales app? Each correct
answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A D
Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/export-dynamics365-sales
You are a Customer Data Platform Specialist. The sales team asks you for an update on its requirement to be able to create
a marketing list in Dynamics 365 Sales from audience insights data.
Which validation is necessary to satisfy the sales teams requirement?
B
Explanation:
Ability to use segments from the audience insights to generate marketing lists:
The Sales team needs to generate a marketing campaign based on segment of customers who have a Loyalty email.
(loyalty.email)
Topic 4, Mixed Questions
You are a Customer Data Platform Specialist. You need to create relationships to connect entities so that they can be further
used in defining segments and measures by the marketing team.
Which three relationship types are available in audience insights? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A D E
Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/relationships
You are a Customer Data Platform Specialist. Your company operates mainly in the business-to-business (B2B) space.
The chief marketing officer (CMO) asks you to implement audience insights and ensure that it can handle the companys
B2B scenarios and data.
Which statement is correct when considering audience insights for business accounts versus individual consumers?
C
Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/work-with-business-accounts
You are a Customer Data Platform Specialist. Your companys chief marketing officer (CMO) learns about Dynamics 365
Customer Insights engagement insights capability. Your CMO wants to understand how engagement insights can be used to
enhance audience insights.
Which two statements describe the benefits of engagement insights? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A D
Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/engagement-insights/overview
DRAG DROP
You are a Customer Data Platform Specialist. The chief marketing officer (CMO) asked you to look at different use cases as
you are implementing the Customer Insights platform.
Which use case is applicable to either audience insights or engagement insights? To answer, drag the appropriate capability
to the correct use case. Each capability may be used once, more than once, or not at all. You may need to drag the split bar
between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/engagement-insights/overview
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/overview
DRAG DROP
You are a Customer Data Platform Specialist. You are in the process of implementing audience insights as the Customer
Data Platform (CDP) solution for your company.
Your manager asks you to give a short presentation for new users who will be using audience insights and explain some of
the benefits that audience insights will offer them.
Which user group will take which benefit from audience insights? To answer, drag the appropriate user group to the correct
benefit. Each user group may be used once, more than once, or not at all. You may need to drag the split bar between
panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/overview
HOTSPOT
You are a Customer Data Platform Specialist. Your company has audience insights set up as their Customer Data Platform
(CDP). The product owner entered a user story on your backlog to add data from the new loyalty solution into the CDP. You
defined the data source. You are ready to add the loyalty contacts to the data unification process.
Which new data entity area should you select in the Map phase of the data unification process?
Hot Area:
Explanation:
Reference: https://powerobjects.com/customer-insights/microsoft-dynamics-365-contacts-to-customer-insights/
You are a Customer Data Platform Specialist. You completed all the steps in the match phase of the data unification process
in the audience insights. You need to review and validate your match results.
Which three metrics are available for you to validate the results? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
B C D
Explanation:
Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/match-entities