Exam4Training

Microsoft MB-260 Microsoft Dynamics 365 Customer Insights (Data) Specialist Online Training

Question #1

Topic 1, Adventure Works

Case study

Overview

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/incremental-refresh-data-sources


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?

  • A . 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.
  • B . In audience insights, select Data Sources, add data source, enter "CellPhone" in the name field and click Next.
  • C . 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.
  • D . In audience insights, add data source and select Microsoft Dataverse as an import method, enter "CellPhoneloyalty" as a data source name.

Reveal Solution Hide Solution

Correct Answer: C
C

Explanation:

There are three data sources containing customer profile data loaded to a dedicated storage account and container in the Azure Data Lake.

Ingesting Cell phone data- the requirement is to keep the name of the date sources aligned with the design document.

cellPhone_loyaly.csv: srcid (primary key), cellphone

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-power-query

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-common-data-model


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?

  • A . Edit the merged FullName field and combine fields by most recent based on timestamp in the source entity.
  • B . Edit the merged FullName field and combine fields by least recent based on timestamp in the source entity.
  • C . Separate the fields in the merged FullName field, create a new field, and add attributes in priority order.
  • D . Edit the merged FullName field, combine fields by importance, and manually rank the source entities.

Reveal Solution Hide Solution

Correct Answer: D
D

Explanation:

Adding Full Name field to the unified customer record

Full Name is a merged field with the following merging policy

a. loyalty.member.fullname

b. ecom.member.fullname

c. cclubcust.csv.full_name

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/merge-entities

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/merge-entities#group-profiles-into-households-or-clusters


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.

  • 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, Full Name, Email. Cell Phone. Street Address, and 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, FullName, Email, Home Phone. DOB fields to Index. Click Save and Run.

Reveal Solution Hide Solution

Correct Answer: AB
AB

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

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.

  • A . 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.
  • B . 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.
  • C . 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.
  • D . Dynamics 365 Sales Contacts must be ingested into audience insights as a data source and included in the unified customer profile.

Reveal Solution Hide Solution

Correct Answer: AD
AD

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/export-dynamics365-sales

Question #8

You are a Customer Data Platform Specialist. The sales team asks you for an update on its requirement to be able to create a marketing list in Dynamics 365 Sales from audience insights data.

Which validation is necessary to satisfy the sales team’s requirement?

  • A . Validate ecom_email field is part of the Customer entity profile, and it is not merged with any other email from a different source.
  • B . Validate loyalty_email field is part of the unified customer entity profile, and it is not merged with any other email from a different source.
  • C . Validate email field is part of the Loyalty Member entity and can be used as a filter when building
    a segment for export to Dynamics 365 Sales
  • D . Validate all contacts ingested from Dynamics 365 Sales are included in the segment and the proper filter is applied.

Reveal Solution Hide Solution

Correct Answer: B
B

Explanation:

Ability to use segments from the audience insights to generate marketing lists:

The Sales team needs to generate a marketing campaign based on segment of customers who have a Loyalty email. (loyalty.email)

Question #9

You are a Customer Data Platform Specialist. You need to create an additional audience insights environment based on the existing configuration in the development environment.

Which two statements are correct when creating an additional environment with limited amount of required configuration? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  • A . In Type select Trial, Region, and click next to connect to the Azure Data Lake Storage Account.
  • B . In the Create New Environment dialog window, enter *UAT1" name. Check Copy from exiting environment and select "Dev° from the option set.
  • C . In the Create New Environment dialog window, enter *UATT name. Check Copy from exiting environment, and select DEV1 from the list.
  • D . In Type select Sandbox, Region, and click next to connect to the Azure Data Lake Storage Account.

Reveal Solution Hide Solution

Correct Answer: CD
CD

Explanation:

Creating a sandbox environment that mirrors the current development environment Create a sandbox environment called UAT1 and copy configurations from env. “DEV1”.

– Note: there is also an existing environment called “Dev” and it is not configured correctly and should not be copied

Question #10

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 . 2
  • B . 3
  • C . 4
  • D . 5

Reveal Solution Hide Solution

Correct Answer: C

Question #10

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 . 2
  • B . 3
  • C . 4
  • D . 5

Reveal Solution Hide Solution

Correct Answer: C
Question #10

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 . 2
  • B . 3
  • C . 4
  • D . 5

Reveal Solution Hide Solution

Correct Answer: C
Question #10

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 . 2
  • B . 3
  • C . 4
  • D . 5

Reveal Solution Hide Solution

Correct Answer: C
Question #10

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 . 2
  • B . 3
  • C . 4
  • D . 5

Reveal Solution Hide Solution

Correct Answer: C
Question #15

Same postal code

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

Reveal Solution Hide Solution

Correct Answer:


Question #16

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.

  • A . EventRating
  • B . CustomerNumber
  • C . ResponseDate
  • D . ResponseNumber

Reveal Solution Hide Solution

Correct Answer: C
Question #17

Your manager asked you to evaluate the use of suggested segments for marketing campaigns.

You need to tell your manager what kinds of segments can be suggested based on the current Dynamics 365 Customer Insights configuration.

Which two types of segments can be suggested? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  • A . Customers who have generated the most revenue from ticket sales
  • B . Customers who have the lowest average customer satisfaction scores.
  • C . Customers who have made the most recent purchases.
  • D . Customers who have the highest total spend per customer.

Reveal Solution Hide Solution

Correct Answer: A, D
Question #18

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 . Upload a product catalog table with categories and prices for event types.
  • B . Change the existing semantic mapping type for the event tickets activity.
  • C . Include an IsReturn field in the Power Query definition for event tickets.
  • D . Add an event type id GUID to the event tickets Power Query definition.

Reveal Solution Hide Solution

Correct Answer: A
Question #19

You created a Microsoft Dynamics 365 Customer Insights environment for testing by copying the configuration of the production environment.

You need to make sure the new environment is operational and satisfies all relevant requirements.

Which three steps should you perform after creating the new environment? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  • A . Enter credentials for the data source that contains sales CRM contacts.
  • B . Remove export destinations and disable scheduled refreshes.
  • C . Recreate the data source that contains EcommerceCustomer.
  • D . Recreate the data source that contains sales CRM contacts.
  • E . Add role assignments to grant access to marketing team members.

Reveal Solution Hide Solution

Correct Answer: A, D, E
Question #20

DRAG DROP

The marketing team is working on a campaign to email cou

You need to ensure all data required to build the necessary segments is available in Microsoft Dynamics 365 Customer Insights.

Which four 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.

Reveal Solution Hide Solution

Correct Answer:


Question #21

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 . Separate the fields in the merged FuttName field and create new fields for first name and last name.
  • B . Enable data profiling for the firstname attenuates in the LoyaltyMember and tcommerceCustomer tables
  • C . Create a merged FirstName field from attributes in the LoyattyMember and EcommerceCustomer tables.
  • D . Map attenuates from the LoyattyMember and EeommereeCustomer tables to the Person.FirstNcme semantic type.

Reveal Solution Hide Solution

Correct Answer: C
Question #22

The marketing team wants to invite cycling club customers to a new product launch webinar.

You need to ensure all necessary data is available to create a segment to target the appropriate customers.

What should you do?

  • A . Enable data profiling for the attributes of the QubMember table.
  • B . Edit the existing Azure Data Lake data source and add specific SurveyResponse attributes.
  • C . Create a new Azure Data Lake data source and add the SurveyResponse table.
  • D . Edit the existing Azure Data Lake data source and add the SurveyResponse table.

Reveal Solution Hide Solution

Correct Answer: D
Question #23

You need to fix the problem with exports to Dynamics 365 Sales.

What should you do?

  • A . Verify the schedule run setting for the export rs set to "on."
  • B . Add the Dynamics 365 Sales Contact table to the profile unification process.
  • C . Add a field for loyalty system email address in Dynamics 365 Sales.
  • D . Verify the segment for export does not contain more than 100,000 members.

Reveal Solution Hide Solution

Correct Answer: B
Question #24

You want to address the IT operations teams goal.

What is the first step you should take?

  • A . Configure incremental refresh for the GubMember table.
  • B . Add a primary key to the EventAttendee table.
  • C . Recreate EventAttendee as a partitioned table.
  • D . Add a primary key to the PageViews table.

Reveal Solution Hide Solution

Correct Answer: C
Question #25

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.

  • A . Non-editable system relationships, created by the system as part of the data unification process
  • B . Non-editable system relationships, which are created automatically from ingesting data sources
  • C . Editable inherited relationships, created by the system as part of the data unification process
  • D . Editable custom relationships, created and configured by users
  • E . Non-editable inherited relationships, which are created automatically from ingesting data sources

Reveal Solution Hide Solution

Correct Answer: ADE
ADE

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/relationships

Question #26

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?

  • A . The out-of-the-box product recommendation prediction model is available for business accounts.
  • B . Data ingestion features are different for business accounts and individual customers.
  • C . Some enrichment types are available only for individual customer scenarios, while others are exclusively available for business accounts.
  • D . Business accounts and individual consumers share the same audience insights environment.

Reveal Solution Hide Solution

Correct Answer: C
C

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/work-with-business-accounts

Question #27

You are a Customer Data Platform Specialist. Your company’s chief marketing officer (CMO) learns about Dynamics 365 Customer Insights engagement insights capability. Your CMO wants to understand how engagement insights can be used to enhance audience insights.

Which two statements describe the benefits of engagement insights? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  • A . It allows you to collect, measure, and understand customer behavior on your website.
  • B . It allows you to create new customer profiles within engagement insights that can be exported to audience insights.
  • C . It allows you to send new customer leads directly to a marketing automation platform.
  • D . It allows you to link audience insights and engagement insights environments to enable bidirectional data flow.

Reveal Solution Hide Solution

Correct Answer: AD
AD

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/engagement-insights/overview

Question #28

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference:

https://docs.microsoft.com/en-us/dynamics365/customer-insights/engagement-insights/overview

https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/overview


Question #29

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/overview


Question #30

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?

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Edit fields

Reference: https://powerobjects.com/customer-insights/microsoft-dynamics-365-contacts-to-customer-insights/


Question #31

You are a Customer Data Platform Specialist. You completed all the steps in the match phase of the data unification process in the audience insights. You need to review and validate your match results.

Which three metrics are available for you to validate the results? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  • A . Unique matched records
  • B . Matched records only
  • C . Matched and non-matched records
  • D . Unique source records
  • E . All source records

Reveal Solution Hide Solution

Correct Answer: BCD
BCD

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/match-entities

Question #32

You are a Customer Data Platform Specialist. You are in the process of implementing audience insights at a bank.

You finished setting up the different initial data sources. You are starting the unification process.

Which three tasks do you need to perform in the Mapping phase of the unification process? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  • A . Identify the primary keys and semantic field types within the different entities.
  • B . Identify the entities that you need to unify into a single profile.
  • C . Identify the prioritization of similar fields between different entities.
  • D . Select the fields you want to include the unified customer profile.
  • E . Identify rules for duplication between different entities.

Reveal Solution Hide Solution

Correct Answer: ABD
ABD

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/map-entities

Question #33

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.

  • A . Attributes that are automatically mapped to a semantic type cannot be remapped to a custom semantic type.
  • B . Attributes must be mapped to the semantic type of ID in order to be used as a primary key for the entity.
  • C . The ‘Define the data in the unmapped fields’ section shows attributes that are not automatically mapped to a semantic type.
  • D . The ‘Review mapped fields’ section shows all attributes for which a semantic type is automatically identified.

Reveal Solution Hide Solution

Correct Answer: A, D
A, D

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/map-entities

Question #34

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?

  • A . You must create a separate Power Query data source for each entity you wish to ingest.
  • B . Power Query automatically recognizes header rows in files when you use the Text/CSV connector.
  • C . After you save a Power Query data source, you have to manually trigger the initial refresh process.
  • D . You can add additional entities to the data source using Get Data functionality in the Power Query.

Reveal Solution Hide Solution

Correct Answer: D
D

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-power-query

Question #35

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?

  • A . Yes
  • B . No

Reveal Solution Hide Solution

Correct Answer: B
B

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-power-query

Question #36

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?

  • A . Yes
  • B . No

Reveal Solution Hide Solution

Correct Answer: A
A

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-power-query

Question #37

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 . Yes
  • B . No

Reveal Solution Hide Solution

Correct Answer: B
B

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-power-query

Question #38

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 a Customer Data Platform Specialist. Your company’s information technology department already ingested a CSV file with column names in the first row into audience insights. You are asked to clean and transform the data to get it ready for unification.

What can you do to satisfy the requirements?

Solution: Clean the data by transforming the first row to be used as headers, defining column types to be appropriate field types, and naming the query. Create a full name column if it does not exist by merging the columns for the first name and last name. Click “Next” and your data is now ready for unification.

Does this meet the goal?

  • A . Yes
  • B . No

Reveal Solution Hide Solution

Correct Answer: A
A

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-power-query

Question #39

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 already ingested a CSV file with column names in the first row into audience insights. You are asked to clean and transform the data to get it ready for unification.

What can you do to satisfy the requirements?

Solution: Clean the data by changing columns with numbers to integer number format, which includes fields such as price, number of purchases, and postal code. You should convert primary key to integer number field if it contains only numbers. Click “Next” and your data is now ready for unification.

Does this meet the goal?

  • A . Yes
  • B . No

Reveal Solution Hide Solution

Correct Answer: B
B

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-power-query

Question #40

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 already ingested a CSV file with column names in the first row into audience insights. You are asked to clean and transform the data to get it ready for unification.

What can you do to satisfy the requirements?

Solution: Clean the data by removing any rows with nulls and deleting any leading zeros on the primary key. Click “Next” and your data is now ready for unification.

Does this meet the goal?

  • A . Yes
  • B . No

Reveal Solution Hide Solution

Correct Answer: B
B

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/connect-power-query

Question #41

You are a Customer Data Platform Specialist. Your information technology (IT) team created the customer profile records by unifying the Account, Contact, and Web Account tables. After unification was complete, the team noticed that three relationships were created automatically (CustomerToContact, CustomerToAccount and CustomerToWebAccount). The team needs to know how they can configure and update these three relationships.

What feedback should you provide?

  • A . Relationships created via the unification process can be edited by those with contributor-level access.
  • B . You can edit each of the three relationships by clicking into the Relationship tab and selecting edit.
  • C . You cannot edit any of the three relationships, as they are non-editable system relationships.
  • D . Relationships created via the unification process can only be edited by those with administrator-level access.

Reveal Solution Hide Solution

Correct Answer: C
C

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/relationships

Question #42

You are a Customer Data Platform Specialist. Audience insights users state that they are not able to quickly find details on specific customers while searching customer profiles. You explain the index and search capabilities within audience insights.

Which two statements are correct about configuring and using search and filter index capabilities? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  • A . You can add up to 25 custom fields to index and configure filtering for each one of the fields as an administrator.
  • B . The only fields that are available for indexing are the ones that exist in the customer profile that you created during the data  unification process.
  • C . You can only add a filter for a specific field from the search and filter index page in audience insights.
  • D . Users with a contributor role can add fields on the search and filter index page in audience insights and configure how many filtered records to show.

Reveal Solution Hide Solution

Correct Answer: BC
BC

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/search-filter-index

Question #43

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 two to three transactions per customer ID. preferably across multiple dates.
  • B . There should be at least 100.000 unique customers to perform the CLV model.
  • C . There should be preferably two to three years of transactional data to predict CLV for one year.
  • D . The CLV model will not run if there is any missing data in the fields.

Reveal Solution Hide Solution

Correct Answer: AC
AC

Explanation:

Reference: https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/predict-customer-lifetime-value

Question #44

Your team developed and integrated a batch inferencing pipeline to audience insights. This allows for a new custom machine learning (ML) model to run and deliver new insights to your unified profiles data. Your team is manually running the custom machine learning workflows.

Which statement is correct about allowing your workflow to run automatically with every scheduled refresh?

  • A . You can configure scheduled refreshes for audience insights from Azure ML where you developed the custom ML model.
  • B . Your team can set up scheduled refreshes that allow your workflow to run automatically.
  • C . Your team needs to manually trigger your custom machine learning workflows.
  • D . Scheduled refreshes are not supported for custom machine learning models that are connected to audience insights.

Reveal Solution Hide Solution

Correct Answer: B
B

Explanation:

Reference:

https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/custom-models

https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/system#schedule-tab

Exit mobile version