Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam MB-260 Topic 7 Question 19 Discussion

Actual exam question for Microsoft's MB-260 exam
Question #: 19
Topic #: 7
[All MB-260 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer: C, D

Contribute your Thoughts:

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

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77