Get Real MB-260 Exam Dumps [Aug-2024] Practice Tests
Last MB-260 practice test reviews: Practice Test Microsoft dumps
NEW QUESTION # 59
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/incremental-refresh-data-sources
NEW QUESTION # 60
You are a Customer Data Platform Specialist. Your company's information technology team wants to use the out-of-the-box customer lifetime value (CLV) machine learning (ML) capabilities that come with audience insights, but the team has some concerns about the suitability of their dat
a. You need to confirm if their research about data requirements is correct.
Which two statements are correct about the data characteristic requirements for configuring the CLV ML model? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. There should be at least 100.000 unique customers to perform the CLV model.
- B. There should be at least two to three transactions per customer ID. preferably across multiple dates.
- C. The CLV model will not run if there is any missing data in the fields.
- D. There should be preferably two to three years of transactional data to predict CLV for one year.
Answer: B,D
Explanation:
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/predict-customer-lifetime-value
NEW QUESTION # 61
You want to address the IT operations teams goal.
What is the first step you should take?
- A. Add a primary key to the PageViews table.
- B. Configure incremental refresh for the GubMember table.
- C. Recreate EventAttendee as a partitioned table.
- D. Add a primary key to the EventAttendee table.
Answer: B
NEW QUESTION # 62
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.
Answer:
Explanation:
Explanation
Text Description automatically generated with low confidence
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-common-data-mode
NEW QUESTION # 63
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.
Answer:
Explanation:
Explanation:
NEW QUESTION # 64
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?
- A. In audience insights, select Data Sources, add data source, enter "CellPhone" in the name field and click Next.
- B. 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.
- C. In audience insights, add data source and select Microsoft Dataverse as an import method, enter "CellPhoneloyalty" as a data source name.
- D. In audience insights, add data source and select Azure data lake storage as an import method, enter "cellPhoneJoyalty1 as a data source name, and then enter the container name and method to authenticate. Repeat the same steps for other tables.
Answer: D
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
NEW QUESTION # 65
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/system
NEW QUESTION # 66
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?
- A. Create a merged FirstName field from attributes in the LoyattyMember and EcommerceCustomer tables.
- B. Separate the fields in the merged FuttName field and create new fields for first name and last name.
- C. Map attenuates from the LoyattyMember and EeommereeCustomer tables to the Person.FirstNcme semantic type.
- D. Enable data profiling for the firstname attenuates in the LoyaltyMember and tcommerceCustomer tables
Answer: D
NEW QUESTION # 67
Your organization's marketing team is in the process of mapping tables and attributes in the data unification process of Dynamics 365 Customer Insights - Data. 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.
- A. The Define the data in the unmapped fields section shows attributes that are not automatically mapped to a semantic type.
- B. The Review mapped fields section shows all attributes for which a semantic type is automatically identified.
- C. Attributes must be mapped to the semantic type of ID in order to be used as a primary key for the table.
- D. Attributes that are automatically mapped to a semantic type cannot be remapped to a custom semantic type.
Answer: B,D
NEW QUESTION # 68
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?
- A. Include an IsReturn field in the Power Query definition for event tickets.
- B. Upload a product catalog table with categories and prices for event types.
- C. Change the existing semantic mapping type for the event tickets activity.
- D. Add an event type id GUID to the event tickets Power Query definition.
Answer: C
NEW QUESTION # 69
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. Validate you have access to edit the Search and index pages in audience insights.
- B. On the Search and filter index pane. Add Last Name, FullName, Email, Home Phone. DOB fields to Index. Click Save and Run.
- C. You must run Merge in order to view the newly added fields on the customer profile.
- D. 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.
Answer: A,D
Explanation:
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
NEW QUESTION # 70
You implemented Microsoft Dynamos 365 Customer Insights as the Customer Data Platform solution. Now, you are building segments that were requested by the marketing department. One of the segments that is requested is "all customers that made an eCommerce purchase in the last 12 months".
You need to consider the implications of building a segment that uses tables other than Customer Which system behavior should you consider when building multi-table segments?
- A. Choosing different relationship paths can result in different numbers of segment members.
- B. All the rules within the segment need to use the same relationship path.
- C. Only activities that are related to customer profiles through relationship paths can be used.
- D. Dynamics 365 Customer Insights selects the most direct path when there are multiple possible relationship paths available.
Answer: C
NEW QUESTION # 71
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.
You are setting up a new Dynamics 365 Customer Insights - Data environment and want to connect a Microsoft Dataverse environment.
While trying to connect, you receive the error This CDS organization is already attached to another Customer Insights - Data instance.
You need to resolve the issue and ensure you can connect the new Customer Insights - Data environment to the Dataverse.
Solution: In Microsoft Power Apps, select the proper environment and go to Connections. Remove the connection(s) to Dynamics 365 Customer Insights - Data.
Does this meet the goal?
- A. Yes
- B. No
Answer: A
NEW QUESTION # 72
You are a Customer Data Platform Specialist. Your company's information technology team wants to use the out-of-the-box customer lifetime value (CLV) machine learning (ML) capabilities that come with audience insights, but the team has some concerns about the suitability of their data. You need to confirm if their research about data requirements is correct.
Which two statements are correct about the data characteristic requirements for configuring the CLV ML model? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. There should be at least 100.000 unique customers to perform the CLV model.
- B. There should be at least two to three transactions per customer ID. preferably across multiple dates.
- C. The CLV model will not run if there is any missing data in the fields.
- D. There should be preferably two to three years of transactional data to predict CLV for one year.
Answer: B,D
Explanation:
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/predict-customer-lifetime-va
Topic 1, Adventure Works
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.
Blue Yonder Airlines created a new division named BY Excursions (BYE). BYE operates site-seeing tours arid other excursions in vacation destinations across North America.
BYE is the product of the acquisition of three regional tour and excursion companies.
* Each of these regional operations have updated their branding.
* The three operations continue to maintain separate CRM systems for sales and customer service in their respective terntones (East West and Central).
* Each regional operator offers different types of tours and excursions. For example, the East region currently offers boat tours, but the Central region does not.
BYE uses a single instance of Dynamics 365 Marketing for marketing automation, and tt recently implemented Dynamics 365 Customer Insights as its CDP. Dynamics 365 Marketing and Customer Insights are not currently connected.
A corporate data lake is built on Azure Data Lake Gen 2. This data lake has two containers named 'imports- and "exports. - The BYE data science team uses Azure Machine Learning Studio to build predictive models.
An Azure Data Factory pipeline produces flat-fit
le extracts of all customers, events, and survey response data from every regional CRM system, and copies them to the corporate data lake imports container daily. These extracts are produced in pipe-delimited text format and each type of extract file has the same schema. The pipeline runs at 1 a.m. US Eastern Standard Time (UTC -5). Each regional system extract has the same format.
Customer data is represented as records in the Customer extract file. This file contains customer address and contact information. Because customers can make purchases in more than one region, the same customer may be represented in multiple regional extract files.
Regional extracts may also contain multiple records corresponding to the same individual customer.
Each record in a single regional extract will have a unique customer number value. The customer number value is not guaranteed to be unique across all regional extracts. Each customer file contains fewer than 50,000 records.
Customer event ticket purchases are represented as records in the event tickets extract file. This file contains a unique ID value for every ticket purchase along with details such as event type, event date, purchase date and ticket cost Each customer is also sent a customer satisfaction survey after the conclusion of every event. The survey includes numeric rating of 1 -5 (1 being le sati d and 5 being most satisfied) and a free-text response field for the customers to share their impressions of the event.
The schema for the three files in each extract is shown below:
Your team is responsible for the configuration of Customer insights. You are an Administrator in the environment.
Your team has configured a separate data source corresponding to the customer file extracts from each regional operation. Each data source uses a Microsoft Power Query text file connector to ingest the extract files. The Microsoft Enhanced Addresses enrichment has been enabled for each regional data source. The enrichment name for each region is the region name (East. West or Central) followed by "addresses." Your team has also configured a fourth data source using Power Query to create consolidated files containing all event tickets and survey response records. These two new files have the same layout as the regional files.
Customer email addresses are included in these files because customer numbers are not unique across regions.
Your team has defined a Unified Customer Profile based on the three different customer extract files. The East and West regional customer extracts have deduplication rules configured with the default merge preferences and the following centric:
1. Exact matches on LastName. HomeAddress, City and PostalCode.
2. Exact matches on FirstName, LastName, EmailAddress and normalized PhoneNumber.
The Central regional customer extract does not have any deduplication rules configured.
Your team has configured matching to start with the East region customer extract as the primary entity, then the Central region, then the West region. Each regional entity is configured to include all records, and subsequent entities match the previous entity using the following conditions:
1. Exact matches on LastName and normalized PhoneNumber.
2. Exact matches on normalized Phonernumber, EmailAddress and Country.
Your team has added activities based on the event ticket and survey response extracts. Survey responses have been semantical^ mapped to the Feedback activity type, and event tickets have been semantically mapped to the SalesOrder activity type.
Your team has not created any measures or segments.
Your team has configured an export of the ConflationMatchPairs entity and attached it to a connection to the corporate data lake "exports" container.
In addition to the Enhanced Addresses enrichment mentioned previously, your team has configured a custom import enrichment that reads a file from a third-party vendor's SFTP server.
BYE uses Dynamics 365 Marketing s outbound marketing campaigns to send two types of commercial emails:
1, Post-purchase follow-up email - This email is sent the day after a customer purchases an event ticket. It contains generic information about upcoming events for the region. BYE leadership wants to replace the generic content with a personalized set of recommended event types the customer might want to consider. There are no restrictions on the types of events that can be recommended.
2. Post-event email - This email is sent the day after an event concludes, and it includes a link to the customer survey.
1. A significant number of BYE customers are duplicated in the regional file extracts. Manual review of a random sampling of duplicates returned the following findings:
a. Duplicate records frequently have different values for street address such as inconsistencies in spelling and abbreviations for common words like "street" "avenue." "drive.' etc.
b. Duplicate records typically share the same values for last name, email address, city, state or province, postal code, and country.
c Duplicate records typically do not share the same values for first name.
2. An automated process in the East regional CRM system recently updated the state or province component of several thousand customer's addresses with incorrect values. All other components of these customer's addresses are still presumed correct.
3. An automated process in the Central regional CRM system recently deleted the first name values for several hundred customers.
The data science team has built inference pipelines in three different workspaces. Your user account has the following access:
* Owner access to BYAEAML01
* Reader access to BYAEAML02
* User Access Administrator access to BYAEAML03
The table below shows the published pipelines in each workspace.
The marketing team requests your team plan for two updates to BYE's Customer Insights instance:
1. Stop using the Enhanced Addresses enrichment and start using the Azure Maps enrichment.
2. Start sending an export of customer data to the same data broker that currently provides the custom enrichment. This would use the same SFTP server as the existing enrichment.
AdventureWorks website page views for authenticated ecommerce customers and cycling club members are stored in a CDM folder named WEBSTATS that is stored in an Azure Data Lake Gen 2 container named WEBDATA119 in the Central US region This folder contains an entity named PageViews that includes the following fields: emoitaddress, pagers. visit date, productcatvgory.
AdventureWorks uses Dynamics 365 Sates as its sales CRM application, and its data is stored in Microsoft Dataverse.
Cycling club event logistics and member attendance are managed in an Azure SQL database. Attendance is tracked in a single table named EventAttendec that includes the following fields: emailaddress, eventuate, eventaddress, eventcity, eventstate. eventpostalcode. lastupdated (timestamp).
The GubMember entity contains records of existing customers, as well as individuals who have not made a purchase from AdventureWorks. There are approximately 500.000 records in this entity, and there are approximately 5 million records in the EventAttendee table.
AdventureWorks currently has a single Dynamics 365 Customer Insights environment. This environment is named ADWProd, and it is configured as a B-to-C production environment in the West USA region.
The following data sources have been configured:
1. To ingest the LoyottyMember. EcommerceCustomer and ClubMember entities descended in the Data Sources section of this case study.
2. For Dynamics 365 Sales contact records using a Dataverse managed data lake connector.
3. For the EventAttendee table using a Power Query connection.
Profile unification has been configured to perform map, match, and merge for non-primary key attributes with identical semantic types from the LoyottyMember, EcommerceCustomer and GubMember entities. Creation dates and timestamps were intentionally left unmapped. Some additional attributes were accidentally excluded from the merge process. These attributes are listed in in the Pain Points section of this case study.
The search and filter index has been configured to include FutlName, City, State and PhoneNumber as search fields. The Share field is enabled for fileting based on frequency and will show up to 10 options.
All members of the AdventureWorks marketing team have been granted access to the ADWProd environment.
The AdventureWorks leadership team has identified several issues that need to be addressed to support current growth and ensure customer senior
1. Attributes for first name and postal code were included in the mapping process, but they were accidentally excluded from the merge process.
2. Multiple copies of printed catalogs are being sent to members of the same household resulting in wasted printing and mailing costs.
3. A segment export to Dynamics 365 Sales has been configured, but the sales team reports the associated marketing lists has zero members.
4. Ingesting the EwntAttendee table takes significantly longer than ingesting any other data source, and it causes significant delays for completion of scheduled refreshes.
1. Only one copy of a catalog should be sent per household. AdventureWorks defines a household as all customers who share the same last name, street address, city and state.
2. Sales users are expected to call customers who are included in the loyalty system but do not have a populated email address in the loyalty system.
3. All marketing emails must include the customers first name in the subject field, if it is available in the source data.
4. Marketing team members must be able to search for customer profiles in Microsoft Dynamics 365 Customer Insights by full name, email address, phone number, city, state, and postal code.
5. All members of the marketing team who can access a production Dynamics 365 Customer Insights environment should also have access to its corresponding testing environment.
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 existing environment called "Dev" and it is not configured correctly and should not be copied
NEW QUESTION # 73
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?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION # 74
You are a Customer Data Platform Specialist. Your company's information technology team wants to use the out-of-the-box customer lifetime value (CLV) machine learning (ML) capabilities that come with audience insights, but the team has some concerns about the suitability of their data. You need to confirm if their research about data requirements is correct.
Which two statements are correct about the data characteristic requirements for configuring the CLV ML model? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. There should be at least 100.000 unique customers to perform the CLV model.
- B. There should be at least two to three transactions per customer ID. preferably across multiple dates.
- C. The CLV model will not run if there is any missing data in the fields.
- D. There should be preferably two to three years of transactional data to predict CLV for one year.
Answer: B,D
Explanation:
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/predict-customer-lifetime-va
NEW QUESTION # 75
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.
Answer:
Explanation:
Explanation
Text Description automatically generated
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/incremental-refresh-data-sou
NEW QUESTION # 76
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 remove any special characters in header, defining column types to be appropriate field types, remove any rows with missing primary key, and name the query. Create a full name and full address columns by merging the appropriate columns if they exist. Click "Next" and your data is now ready for unification.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-power-query
NEW QUESTION # 77
You need to unify the different data sources within Microsoft Dynamics 365 Customer Insights through the data unification process.
After you selected Create customer profiles on the Review step, you notice that you still need to rename a customer field.
What is the fastest way to perform the correction?
- A. Rename the field while the unification is in Refreshing status. Changes are still recorded during the current process.
- B. Wait for the process to finish. Refresh the page, then rename the field and run the unification process again
- C. While the unification process is running, separate and recombine the Customer field. Rename it and run the unification process again.
- D. View the details of the running job and cancel the job. Rename the field and run the unification process again.
Answer: A
NEW QUESTION # 78
One of the data sources being ingested into Microsoft Dynamics 365 Customer Insights is Microsoft Dataverse.
During the unification process, you need to identify the primary key to ingest tables on the Source fields page.
Which three data types can you use as a primary key attribute? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A. GUID
- B. String
- C. Whole Number
- D. integer
- E. Boolean
Answer: C,D,E
Explanation:
Topic 1, Adventure Works
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.
Blue Yonder Airlines created a new division named BY Excursions (BYE). BYE operates site-seeing tours arid other excursions in vacation destinations across North America.
BYE is the product of the acquisition of three regional tour and excursion companies.
* Each of these regional operations have updated their branding.
* The three operations continue to maintain separate CRM systems for sales and customer service in their respective terntones (East West and Central).
* Each regional operator offers different types of tours and excursions. For example, the East region currently offers boat tours, but the Central region does not.
BYE uses a single instance of Dynamics 365 Marketing for marketing automation, and tt recently implemented Dynamics 365 Customer Insights as its CDP. Dynamics 365 Marketing and Customer Insights are not currently connected.
A corporate data lake is built on Azure Data Lake Gen 2. This data lake has two containers named 'imports- and "exports. - The BYE data science team uses Azure Machine Learning Studio to build predictive models.
An Azure Data Factory pipeline produces flat-fit
le extracts of all customers, events, and survey response data from every regional CRM system, and copies them to the corporate data lake imports container daily. These extracts are produced in pipe-delimited text format and each type of extract file has the same schema. The pipeline runs at 1 a.m. US Eastern Standard Time (UTC -5). Each regional system extract has the same format.
Customer data is represented as records in the Customer extract file. This file contains customer address and contact information. Because customers can make purchases in more than one region, the same customer may be represented in multiple regional extract files.
Regional extracts may also contain multiple records corresponding to the same individual customer.
Each record in a single regional extract will have a unique customer number value. The customer number value is not guaranteed to be unique across all regional extracts. Each customer file contains fewer than 50,000 records.
Customer event ticket purchases are represented as records in the event tickets extract file. This file contains a unique ID value for every ticket purchase along with details such as event type, event date, purchase date and ticket cost Each customer is also sent a customer satisfaction survey after the conclusion of every event. The survey includes numeric rating of 1 -5 (1 being le sati d and 5 being most satisfied) and a free-text response field for the customers to share their impressions of the event.
The schema for the three files in each extract is shown below:
Your team is responsible for the configuration of Customer insights. You are an Administrator in the environment.
Your team has configured a separate data source corresponding to the customer file extracts from each regional operation. Each data source uses a Microsoft Power Query text file connector to ingest the extract files. The Microsoft Enhanced Addresses enrichment has been enabled for each regional data source. The enrichment name for each region is the region name (East. West or Central) followed by "addresses." Your team has also configured a fourth data source using Power Query to create consolidated files containing all event tickets and survey response records. These two new files have the same layout as the regional files.
Customer email addresses are included in these files because customer numbers are not unique across regions.
Your team has defined a Unified Customer Profile based on the three different customer extract files. The East and West regional customer extracts have deduplication rules configured with the default merge preferences and the following centric:
1. Exact matches on LastName. HomeAddress, City and PostalCode.
2. Exact matches on FirstName, LastName, EmailAddress and normalized PhoneNumber.
The Central regional customer extract does not have any deduplication rules configured.
Your team has configured matching to start with the East region customer extract as the primary entity, then the Central region, then the West region. Each regional entity is configured to include all records, and subsequent entities match the previous entity using the following conditions:
1. Exact matches on LastName and normalized PhoneNumber.
2. Exact matches on normalized Phonernumber, EmailAddress and Country.
Your team has added activities based on the event ticket and survey response extracts. Survey responses have been semantical^ mapped to the Feedback activity type, and event tickets have been semantically mapped to the SalesOrder activity type.
Your team has not created any measures or segments.
Your team has configured an export of the ConflationMatchPairs entity and attached it to a connection to the corporate data lake "exports" container.
In addition to the Enhanced Addresses enrichment mentioned previously, your team has configured a custom import enrichment that reads a file from a third-party vendor's SFTP server.
BYE uses Dynamics 365 Marketing s outbound marketing campaigns to send two types of commercial emails:
1, Post-purchase follow-up email - This email is sent the day after a customer purchases an event ticket. It contains generic information about upcoming events for the region. BYE leadership wants to replace the generic content with a personalized set of recommended event types the customer might want to consider. There are no restrictions on the types of events that can be recommended.
2. Post-event email - This email is sent the day after an event concludes, and it includes a link to the customer survey.
1. A significant number of BYE customers are duplicated in the regional file extracts. Manual review of a random sampling of duplicates returned the following findings:
a. Duplicate records frequently have different values for street address such as inconsistencies in spelling and abbreviations for common words like "street" "avenue." "drive.' etc.
b. Duplicate records typically share the same values for last name, email address, city, state or province, postal code, and country.
c Duplicate records typically do not share the same values for first name.
2. An automated process in the East regional CRM system recently updated the state or province component of several thousand customer's addresses with incorrect values. All other components of these customer's addresses are still presumed correct.
3. An automated process in the Central regional CRM system recently deleted the first name values for several hundred customers.
The data science team has built inference pipelines in three different workspaces. Your user account has the following access:
* Owner access to BYAEAML01
* Reader access to BYAEAML02
* User Access Administrator access to BYAEAML03
The table below shows the published pipelines in each workspace.
The marketing team requests your team plan for two updates to BYE's Customer Insights instance:
1. Stop using the Enhanced Addresses enrichment and start using the Azure Maps enrichment.
2. Start sending an export of customer data to the same data broker that currently provides the custom enrichment. This would use the same SFTP server as the existing enrichment.
AdventureWorks website page views for authenticated ecommerce customers and cycling club members are stored in a CDM folder named WEBSTATS that is stored in an Azure Data Lake Gen 2 container named WEBDATA119 in the Central US region This folder contains an entity named PageViews that includes the following fields: emoitaddress, pagers. visit date, productcatvgory.
AdventureWorks uses Dynamics 365 Sates as its sales CRM application, and its data is stored in Microsoft Dataverse.
Cycling club event logistics and member attendance are managed in an Azure SQL database. Attendance is tracked in a single table named EventAttendec that includes the following fields: emailaddress, eventuate, eventaddress, eventcity, eventstate. eventpostalcode. lastupdated (timestamp).
The GubMember entity contains records of existing customers, as well as individuals who have not made a purchase from AdventureWorks. There are approximately 500.000 records in this entity, and there are approximately 5 million records in the EventAttendee table.
AdventureWorks currently has a single Dynamics 365 Customer Insights environment. This environment is named ADWProd, and it is configured as a B-to-C production environment in the West USA region.
The following data sources have been configured:
1. To ingest the LoyottyMember. EcommerceCustomer and ClubMember entities descended in the Data Sources section of this case study.
2. For Dynamics 365 Sales contact records using a Dataverse managed data lake connector.
3. For the EventAttendee table using a Power Query connection.
Profile unification has been configured to perform map, match, and merge for non-primary key attributes with identical semantic types from the LoyottyMember, EcommerceCustomer and GubMember entities. Creation dates and timestamps were intentionally left unmapped. Some additional attributes were accidentally excluded from the merge process. These attributes are listed in in the Pain Points section of this case study.
The search and filter index has been configured to include FutlName, City, State and PhoneNumber as search fields. The Share field is enabled for fileting based on frequency and will show up to 10 options.
All members of the AdventureWorks marketing team have been granted access to the ADWProd environment.
The AdventureWorks leadership team has identified several issues that need to be addressed to support current growth and ensure customer senior
1. Attributes for first name and postal code were included in the mapping process, but they were accidentally excluded from the merge process.
2. Multiple copies of printed catalogs are being sent to members of the same household resulting in wasted printing and mailing costs.
3. A segment export to Dynamics 365 Sales has been configured, but the sales team reports the associated marketing lists has zero members.
4. Ingesting the EwntAttendee table takes significantly longer than ingesting any other data source, and it causes significant delays for completion of scheduled refreshes.
1. Only one copy of a catalog should be sent per household. AdventureWorks defines a household as all customers who share the same last name, street address, city and state.
2. Sales users are expected to call customers who are included in the loyalty system but do not have a populated email address in the loyalty system.
3. All marketing emails must include the customers first name in the subject field, if it is available in the source data.
4. Marketing team members must be able to search for customer profiles in Microsoft Dynamics 365 Customer Insights by full name, email address, phone number, city, state, and postal code.
5. All members of the marketing team who can access a production Dynamics 365 Customer Insights environment should also have access to its corresponding testing environment.
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 existing environment called "Dev" and it is not configured correctly and should not be copied
NEW QUESTION # 79
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.
Answer:
Explanation:
Explanation:
Graphical user interface, text, application, email Description automatically generated
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/overview
NEW QUESTION # 80
Your organization is using Microsoft Power Query when connecting to data sources in Microsoft Dynamics
365 Customer Insights. You loaded eCommerce profiles to Dynamics 365 Customer Insights. The table contains a iastupdated field that is loaded as a text field instead of a date field.
You need to fix the column format.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. In Dynamics 365 Customer Insights, select and edit the eCommerce profiles table to open the Power Query * Edit queries dialog.
- B. In Dynamics 365 Customer Insights, select and edit eCommerce profiles' data source, select the lastupdated column, select the Transform tab to change Data Type to Date, and select Save
- C. In Dynamics 365 Customer Insights, select and edit the eCommerce profiles data source to open the Power Query * Edit queries dialog.
- D. In Power Query, edit the queries dialog, and select the lastupdated column, select the Transform tab, change Data Type to Date, and select Save
Answer: A,B
NEW QUESTION # 81
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.
- A. Active enrichment is applied to customer profiles.
- B. Contacts from Dynamics 365 Sales are included in the audience insights unification process.
- C. Customer details control is successfully installed and added to the Contact form.
- D. Measure Control is successfully installed and added to the Contact form.
Answer: A,C
Explanation:
Reference:
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/customer-card-add-in
NEW QUESTION # 82
......
The MB-260 certification exam is a great way for professionals to demonstrate their expertise in the field of customer data management and engagement. By earning this certification, individuals can showcase their knowledge of Microsoft's products and services related to customer data management and gain recognition for their skills. Additionally, this certification can help individuals stand out in the job market and increase their career opportunities.
Get Ready to Pass the MB-260 exam with Microsoft Latest Practice Exam : https://www.dumps4pdf.com/MB-260-valid-braindumps.html
Try MB-260 Free Now! Real Exam Question Answers: https://drive.google.com/open?id=1SQaZstMo4GvPi_jms0G4sq7MoyrbiVjq