Home / Microsoft / MB-260

Microsoft MB-260 Practice Test - Questions Answers

Question list

List of questions

Question 1

(0)

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

Question 2

(0)

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 st

Question 3

(0)

DRAG DROP You are a Customer Data Platform Specialist. You want to add data sources that connect to data in the organization's Azure Data Lake. You need to enable data profiling for the entity with

Question 4

(0)

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

Question 5

(0)

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 per

Question 6

(0)

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 e

Question 7

(0)

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

Question 8

(0)

You need to begin planning how to address the marketing team's requests for future enhancements. If you implement the requested changes, what is the total number of connections that will be require

Question 9

(0)

DRAG DROP Your manager asks you to delete all custom deduplications rules and create new ones for each regional data source. Customer records are considered duplicates if they contain: 1. Close ma

Question 10

(0)

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 pr

Related questions

An organization is using Microsoft Power Query when connecting to data sources in Microsoft Dynamics 365 Customer Insights. You need to load eCommerce Contacts to Dynamics 365 Customer Insights using Microsoft Power Query. Which is an appropriate action to take when using Microsoft Power Query to ingest data?

A company has Microsoft Dynamics 365 Customer Insights set up as the Customer Data Platform. The eCommerce application sends updates on customer purchases to Dynamics 365 Customer Insights through its real-time APIs. You configured eCommerce purchases to show on the customer activity timeline. A marketing user reports that eCommerce purchases for customers seem to be disappearing from the customer activity timelines over time. The marketing user also notices that segments based on eCommerce purchases are not updating. You need to explain why this is happening. Which two explanations should you provide? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

The loyalty operations lead at your organization wants a filter to be added on the attribute Loyalty Tiers, which is available on Customer profiles in your Dynamics 365 Customer Insights environment. The Loyalty hers, in order of increasing loyalty status, are: Non-member, Bronze, Silver, Gold, Platinum. Most customers are in the lowest tier of the program, non-member, and then progressive^ fewer customers are in each subsequent tier. You need to create a filter to sort the options as closely as possible to increasing loyalty status. What should you select for Sort options by in the filter pane?

HOTSPOT You are a Dynamics 365 Customer Insights - Data administrator in a consumer goods company. You need to explain to your company's marketing team which measures can be viewed in a customer profile. In the Measures overview, which two measures are visible on the customer profile? To answer, select the appropriate measures in the answer area. NOTE: Each correct selection is worth one point.

DRAG DROP As a Customer Data Platform Specialist, you set up audience insights as the new Customer Data Platform. The product owner wants you to make sure that data sources are refreshed daily. Which five 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.

You are a Customer Data Platform Specialist. Your company has audience insights set up as their Customer Data Platform solution. You transferred the management of the platform to a contractor. You want the contractor to manage the existing connections without having administrator access. Which two statements are correct about allowing contributors to use a connection for exports? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You are a Customer Data Platform Specialist. Your company implemented audience insights as their Customer Data Platform. While discussing the AI possibilities of audience insights with a campaign manager, you mention that the solution can suggest segments based on the activities of a profile. The campaign manager asks you to run a suggestion based on the sales order lines that are available in audience insights. Which three factors will affect the segment suggestions? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

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.

DRAG DROP You are reviewing the system status in Microsoft Dynamics 365 Customer Insights. You notice that different refresh processes are not successful. You need to find the step that is blocking these processes from refreshing. Which dependency types are associated with each process? To answer, drag the appropriate dependency types to the correct processes. 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 match is worth one point.

Your organizations IT team created the customer profile records by unifying the Account, Contact, and Web Account tables. After unification was completed, the team noticed that three relationships were created automatically. 1. CustomerToContact 2. CustomerToAccount 3. CustomerToWebAccount You need to advise the team about how they can configure and update these three relationships. What should you recommend?

Question 1

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.

Show Answer Show Case Study Comment (0)

Question 2

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?

In audience insights, under Data, select Data Sources, add data source and select Azure data lake storage as an import method, enter name as "Loyalty Cell Phone" and enter storage account name to authenticate. Repeat the steps for other tables.

In audience insights, select Data Sources, add data source, enter "CellPhone" in the name field and click Next.

In audience insights, add data source and select Azure data lake storage as an import method, enter "cellPhone_loyalty" as a data source name, and then enter the container name and method to authenticate. Repeat the same steps for other tables.

In audience insights, add data source and select Microsoft Dataverse as an import method, enter "CellPhoneloyalty" as a data source name.

Show Answer Show Case Study Comment (0)

Question 3

DRAG DROP

You are a Customer Data Platform Specialist. You want to add data sources that connect to data in the organization's 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.

Show Answer Show Case Study Comment (0)

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

Question 4

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?

Edit the merged FullName field and combine fields by most recent based on timestamp in the source entity.

Edit the merged FullName field and combine fields by least recent based on timestamp in the source entity.

Separate the fields in the merged FullName field, create a new field, and add attributes in priority order.

Edit the merged FullName field, combine fields by importance, and manually rank the source entities.

Show Answer Show Case Study Comment (0)

Question 5

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.

Show Answer Show Case Study Comment (0)

Question 6

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.

Validate you have access to edit the Search and index pages in audience insights.

On the Search and filter index pane, add Last Name, Full Name, Email, Cell Phone, Street Address, and DOB fields to Index. Click Save and Run.

You must run Merge in order to view the newly added fields on the customer profile.

On the Search and filter index pane. Add Last Name, FullName, Email, Home Phone, DOB fields to Index. Click Save and Run.

Show Answer Show Case Study Comment (0)

Question 7

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.

In order to export segment of customers who have DOB to Dynamics 365 Sales to create marketing lists, a connection to the Dynamics 365 Sales environment must be configured.

Contacts do not have to be present in Dynamics 365 Sales because the export process will create new contact records if they do not already exist.

In order to export segment of customers who have Loyalty email to Dynamics 365 Sales, a connection to the Dynamics 365 Sales environment must be configured.

Dynamics 365 Sales Contacts must be ingested into audience insights as a data source and included in the unified customer profile.

Show Answer Show Case Study Comment (0)

Question 8

You need to begin planning how to address the marketing team's requests for future enhancements.

If you implement the requested changes, what is the total number of connections that will be required in BYAE's Dynamics 365 Customer Insights environment?

Show Answer Comment (0)

Question 9

DRAG DROP

Your manager asks you to delete all custom deduplications rules and create new ones for each regional data source. Customer records are considered duplicates if they contain:

1. Close match on first name,

2. Same last name.

3. Same street address, and

4. Same postal code

You need to complete the configuration of the deduplication matching conditions.