Microsoft Exam MB-260 Topic 7 Question 19 Discussion

Actual exam question for Microsoft's MB-260 exam

Question #: 19
Topic #: 7

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.

AIn Power Query, edit the queries dialog, and select the lastupdated column, select the Transform tab, change Data Type to Date, and select Save

BIn Dynamics 365 Customer Insights, select and edit the eCommerce profiles data source to open the Power Query * Edit queries dialog.

CIn 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

DIn Dynamics 365 Customer Insights, select and edit the eCommerce profiles table to open the Power Query * Edit queries dialog.

Show Suggested Answer

Suggested Answer: C, D

by Pete at Nov 22, 2023, 02:39 AM

Limited Time Offer

25%

Off

Get Premium MB-260 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Susana

8 months ago

Haha, this reminds me of that time I tried to fix a column in Power BI and ended up accidentally deleting the entire data source. Let's just hope we don't make any rookie mistakes like that on the exam!

upvoted 0 times

Lai

7 months ago

D) In Dynamics 365 Customer Insights, select and edit the eCommerce profiles table to open the Power Query * Edit queries dialog.

upvoted 0 times

...

Ora

7 months ago

I agree, let's stay focused and make sure we fix the column format without any issues.

upvoted 0 times

...

Frankie

8 months ago

Definitely! We don't want any accidental mishaps during the exam.

upvoted 0 times

...

Christiane

8 months ago

B) In Dynamics 365 Customer Insights, select and edit the eCommerce profiles data source to open the Power Query * Edit queries dialog.

upvoted 0 times

...

Georgene

8 months ago

Oh no, deleting the entire data source sounds like a nightmare! Let's be careful and make sure we follow the correct steps.

upvoted 0 times

...

Corinne

8 months ago

C) 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

upvoted 0 times

...

Earlean

8 months ago

A) In Power Query, edit the queries dialog, and select the lastupdated column, select the Transform tab, change Data Type to Date, and select Save

upvoted 0 times

...

Vince

8 months ago

Ah, I see what's going on now. The question is asking us to perform two actions, and the correct answer is a combination of B and A. We need to edit the data source in Dynamics 365 to open the Power Query editor, and then in the Power Query editor, we need to change the data type of the lastupdated column to Date. Simple enough!

upvoted 0 times

...

Wilson

8 months ago

Hmm, I think the correct answer has to be a combination of options. We need to edit the query in Dynamics 365 Customer Insights, but we also need to change the data type in Power Query. I'm just not sure if we need to do that in the Dynamics 365 interface or in the standalone Power Query editor.

upvoted 0 times

...

Cammy

8 months ago

This seems like a straightforward question, but I'm a little unsure about the exact steps to fix the column format. I think the key is to edit the query in Power Query, but I'm not sure if we need to do that in Dynamics 365 or in the Power Query editor directly.

upvoted 0 times

...