Microsoft Customer Data Platform Specialist (beta) v1.0

An organization is using Microsoft Power Query when connecting to data sources in Microsoft Dynamics 365 Customer Insights.

You need to load eCommerce Contacts to Dynamics 365 Customer Insights using Power Query.

Which is an appropriate action to take when using Power Query to ingest data?

Historic legacy interactions are ingested using a CSV file as part of the data sources in Microsoft Dynamics 365 Customer Insights. The date when the interaction took place has the column name Interaction Date.

After the data is ingested and configured in Dynamics 365 Customer Insights, users are not able to select the logical date operator such as on or after when using the Interaction Date attribute in a segment rule.

You need to ensure users can use the correct date operators for the Interaction Date in the segment rules.

What should you do?

You need to unify the different data sources within Microsoft Dynamics 365 Customer Insights through the data unification process.

After you selected Run on the Merge page, you notice that you still need to rename a merged field.

What is the fastest way to perform the correction?

A company has Microsoft Dynamics 365 Customer Insights set up as the Customer Data Platform. The eCommerce application sends updates on customer purchases to Dynamics 365 Customer Insights through its real-time APIs. You configured eCommerce purchases to show on the customer activity timeline.

A marketing user reports that eCommerce purchases for customers seem to be disappearing from the customer activity timelines over time. The marketing user also notices that segments based on eCommerce purchases are not updating.

You need to explain why this is happening.

Which two explanations should you provide? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Your company is using Microsoft Dynamics 365 Customer Insights to deliver personalized customer experiences.

You notice in System > Status that the merge process shows a “Failure” status.

You need to determine the processes that depend directly on the successful completion of the merge process.

What are the three processes? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Your company implemented Microsoft Dynamics 365 Customer Insights as the Customer Data Platform, and you are assigned as an administrator. You monitor the status overview in the Administration section of the important product processes on a daily basis.

When the status does not show “Successful”, you must recognize the dependencies between refresh processes.

What are two of these dependencies?

NOTE: Each correct selection is worth one point.

You need to set up the refresh schedule for Microsoft Dynamics 365 Customer Insights.

Which two interval periods are available? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

An organization is using Microsoft Power Query when connecting to data sources in Microsoft Dynamics 365 Customer Insights.

You need to load eCommerce Contacts to Dynamics 365 Customer insights using Power Query.

Which is an appropriate action to take when using Power Query to ingest data?

You are selecting the data sources for an incremental refresh.

You need to set up the incremental refresh for qualified data sources.

Which two points must you consider before doing the refresh? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

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

An organization is using Microsoft Power Query when connecting to data sources in Microsoft Dynamics 365 Customer Insights.

You need to load eCommerce Contacts to Dynamics 365 Customer Insights using Power Query.

Which is an appropriate action to take when using Power Query to ingest data?

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

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

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

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

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

Solution: Transform the first row to be used as headers, and remove any special characters or spaces from header row. Remove rows with missing primary keys, and name the query. Select Next and your data is now ready for unification.

Does this meet the goal?

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

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

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

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

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

Solution: Transform the first row to be used as headers, remove rows that contain null values, and name the query. Select Next and your data is now ready for unification.

Does this meet the goal?

HOTSPOT
-

You have enabled real-time data ingestion in Microsoft Dynamics 365 Customer Insights.

You need to explain to your company’s marketing team how the behavior of real-time data ingestion differs from the behavior of scheduled data ingestion.

Which four areas of the Unified Customer Profile will always remain unchanged after the completion of a real-time data operation?

NOTE: Each correct selection is worth one point.