MB-260 Exam Dumps – Reliable Way to Pass and Get Certified

1. You are a Customer Data Platform Specialist. The primary audience for your instance of audience insights is business accounts. You need to show audience insights data to Dynamics 365 Sales users without updating data in Dataverse.

Which Customer Card Add-in controls requires you to create semantic entity mapping before you can use it?

2. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

You are a Customer Data Platform Specialist. Your company’s information technology department (IT) has a CSV file stored on one of their Shared Documents folders within their SharePoint sites which they have ingested into audience insights. The file contains a row header with some special characters, columns of different types (quantities, prices, etc.), and some rows with a high proportion of nulls and missing primary keys. You have been asked to clean and transform the data in audience insights to be ready for unification.

What should you do?

Solution: Clean the data by removing any rows where the primary key is missing, delete any leading or trailing zeros on the primary key, and name the query. Click “Next” and your data is now ready for unification.

Does this meet the goal?

3. DRAG DROP

You are the administrator for a new Dynamics 365 Customer Insights environment at your organization.

You need to set up the Search & filter index for the first time.

What three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

4. 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?

5. Create a segment from the results page using the ChurnScore field and a Greater than operator for the lower bounds value of the group you identified.

Does this meet the goal?

6. Data exports and scheduled refreshes are not allowed in test environments.



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.

✑ 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.

✑ 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.

✑ The Sales team uses the Dynamics 365 Sales app but are not able to use segments generated in audience insights to generate marketing lists.

✑ Marketing campaigns often sound redundant and inefficient as the same

messaging is being sent to multiple members of the same household.

✑ The Marketing team cannot create fully personalized communications due to missing Full Name in the unified customer record.

✑ 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

✑ 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.

✑ Implement necessary changes to address the remaining pain points identified during the Leadership Team meeting.



Detailed Requirements

Pain Points

✑ 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

✑ 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

✑ 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)

✑ 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

✑ 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

✑ 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



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.

7. DRAG DROP

You are a Customer Data Platform Specialist. Your organization is using the Dynamics 365 Customer Insights as the Customer Data Platform.

Your marketing team wants to explore the suggested segments feature and create a segment based on measures.

Which four steps should be performed in sequence to achieve this goal? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

8. You are a Customer Data Platform Specialist. Some of the data your company stores need to adhere to strict organization compliance and security when establishing connections and exports. Your information technology department tells you that you must use a dedicated Azure key vault with your audience insights environment to help the organization meet its compliance requirements. The dedicated key vault will be used to stage and use secrets in an organization’s compliance boundary.

Which two statements are true about using audience insights and Azure Key Vault to store the secrets for each of the connections set up?

NOTE: Each correct selection is worth one point.

9. 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.

10. You are a Customer Data Platform Specialist. You are reviewing the system status. You notice that an insights refresh process shows a “skipped” status.

Which system process type should you review to find the step that is blocking the insights refresh from starting?

11. You are implementing a scheduled refresh in Microsoft Dynamics 365 Customer Insights.

You need to describe scheduled refreshes to your colleague.

Which two statements should you convey? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

12. You are a Customer Data Platform Specialist. Your marketing team is in the process of mapping entities and attributes in the data unification process of audience insights. You are assisting them with completing this task.

Which two statements correctly describe how audience insights handles the mapping of semantic types for entity attributes? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

13. You are implementing Dynamics 365 Customer Insights - Data as your company's Customer Data Platform.

The initial dataset tables contain contacts from Dynamics 365 Sales. ©Commerce customers, and service management platform incidents.

In your first unification run. you set Dynamics 365 as the primary table but only see eCommerce profiles that were able to be matched with Dynamics 365 contacts. You need to ensure that unmatched eCommerce customers are also added as a profile in Customer Insights - Data

Solution: Make eCommerce customers the primary table in the match step.

Does this meet the goal?

14. Your organization's marketing team is in the process of mapping tables and attributes in the data unification process of Dynamics 365 Customer Insights - Dat a. They need your help with this task.

You need to explain to the marketing team how Customer Insights - Data handles the mapping of semantic types for table attributes.

Which two statements should you convey? Each correct answer presents part of the solution. NOTE Each correct selection is worth one point.

15. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

You are a Customer Data Platform Specialist. Your company’s information technology department (IT) has a CSV file stored on one of their Shared Documents folder within their SharePoint sites which they have ingested into audience insights. The file contains a row header with some special characters, columns of different types (quantities, prices, etc.), and some rows with a high proportion of nulls and missing primary keys. You have been asked to clean and transform the data in audience insights to be ready for unification.

What should you do?

Solution: Clean the data by transforming the first row to be used as headers and removing special characters and spaces from header row, defining column types to be appropriate field types, remove rows with missing primary keys, and name the query. Click “Next” and your data is now ready for unification.

Does this meet the goal?

16. 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.

17. The marketing team wants to create a segment for a new email campaign to invite customers to a series of in-store events.

What should you do first?

18. DRAG DROP

You are a Customer Data Platform Specialist. Your company uses audience insights as their Customer Data Platform.

The marketing team wants to know the total amount the customer has spent. The order lines are linked to a profile as part of the point-of-sale data source and through their loyalty ID.

Which five actions should you perform in sequence to create this insight? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

19. 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 company’s B2B scenarios and data.

Which statement is correct when considering audience insights for business accounts versus individual consumers?

20. You ate taking over administrative responsibilities tor a Dynamics 365 Customer Insights - Data environment at your organisation, and you are reviewing the indexes set up for Customer profiles in the environment.

One of your users has asked you to make DateofBirth a searchable attribute. You navigate to the Search & filter index page and see that there is already an attribute with the name DateofBirth It has an x in the Included in search column.

You need to report your findings to the use*.

What should you tell the user?

21. You need to configure the out-of-the-box sentiment analysis model to run on survey response data.

Which two fields contain data that must be mapped to model input parameters? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

22. You are a Customer Data Platform Specialist.

One of the marketing users asked you to create two lists:

✑ All customers that live in Paris, France

✑ All customers that have made more than ten online purchases

You decide to create these lists as quick segments.

Which two options should you use as the base in quick segments to create the required insights? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

23. DRAG DROP

You are a contributor for a Dynamics 365 Customer Insights - Data instance at an online retail company.

Your customer experience team wants to better respond to online reviews posted on the company website. You ingest the reviews as a table, and create an activity with recommended semantic mappings named Online Feedback.

You need to configure Customer Insights - Data to classify the online reviews as negative or positive.

Which five actions should you perform in sequence? To answer, move the five appropriate actions from the list of actions to the answer area. Arrange the five actions in the correct order.

24. Topic 2, Misc. 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.

25. You are a Customer Data Platform Specialist. Your organization recently implemented audience insights. You need to create a measure using the ‘Average Transaction Value’ template to track the average spent by a customer.

As part of the process of creating the measure, you need to add data and map it to the data from the Unified Activity entity.

When you are setting up the measure, which two steps should you perform to complete this task? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

26. 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.

27. You are a Customer Data Platform Specialist. You successfully installed the Customer Card Add-in and the required add-in control in Dynamics 365 Sales app. You need to show customer enrichment data from audience insights in the Dynamics 365 Sales application.

Which two statements must be true for you to show the required data on a Customer Card Add-in control? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

28. Your data analytics team wants to create a custom machine learning model to predict whether a customer will purchase a particular product.

You need to explain what is required for integrating a custom model with Microsoft Dynamics 36S Customer Insights.

Which two requirements should you tell them? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

29. You need to implement the out-of-the-box product recommendation model to generate event recommendations for the post-purchase email.

What action must you perform to use this model?

30. You are a Customer Data Platform Specialist. Your organization is using Power Query when connecting to Data Sources in audience insights. You need to load eCommerce Contacts to audience insights.

Which statement about loading data to audience insights using Power Query is correct?

31. You are a Customer Data Platform Specialist. You are creating a new measure for business accounts (B2B) in audience insights.

One of the requirements for the new business-level measure is to add a dimension of the city for each business account.

What is needed to ensure that this measure is created as a business-level measure instead of a customer-level measure?

32. Your company wants to create a segment to identify the customers who are more likely to purchase the three most-recommended products from the out-of-the-box product recommendations model.

Before defining this segment, you need to first configure and run the product recommendations model.

Which point should you consider when configuring the product recommendation model?

33. 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?

34. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

A company's IT department has a CSV file stored on one of their Shared Documents folders within their Microsoft SharePoint sites. The data from the CSV file is ingested into Dynamics 365 Customer Insights - Data.

The file contains a row header and columns of different types, such as quantities and prices. The file also contains some rows with a high proportion of nulls.

You need to clean and transform the data in Customer Insights - Data to be ready for unification.

Solution: Remove any rows where the primary key is missing, delete any leading or trailing zeros on the primary key, and name the query. Select Next and your data is now ready for unification.

Does This meet the goal?