Microsoft Dynamics 365 Customer Insights – Data — Question 25

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.

Answer options

• A. 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
• B. In Dynamics 365 Customer Insights, select and edit the eCommerce profiles data source to open the Power Query - Edit queries dialog
• C. In Dynamics 365 Customer Insights, select and edit the eCommerce profiles entity 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

Correct answer: B, D

Explanation

To correct the column format, you first need to access the Power Query - Edit queries dialog for the eCommerce profiles data source (Option B). After that, you can modify the lastupdated column's data type to Date in Power Query (Option D). Options A and C do not lead to the appropriate editing interface for changing the data type.