Microsoft Exam MB-260 Topic 10 Question 37 Discussion

Actual exam question for Microsoft's MB-260 exam

Question #: 37
Topic #: 10

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 Microsoft Power Query. Which is an appropriate action to take when using Microsoft Power Query to ingest data?

AYou can have Microsoft Power Query automatically recognizes header rows in files when you use the Text/CSV connector.

BAfter you saw a Microsoft Power Query data source you have to manually trigger the initial refresh process.

CYou must select Microsoft Power Query as an import method when creating the data source

DIf a system process uses a Microsoft Power Query data source, you can simultaneously edit the data source.

Show Suggested Answer

Suggested Answer: B

by Aja at Aug 22, 2024, 06:45 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Tuyet

9 months ago

Hold up, did they really just ask us to 'clean and transform the data'? That's like asking a chef to make a meal - there's a lot more to it than just following a single step!

upvoted 0 times

Catarina

8 months ago

I agree, there's definitely more to cleaning and transforming data than just defining column types and naming queries.

upvoted 0 times

...

10 months ago

Hmm, not too sure about this one. I think there might be more to it than just that. Shouldn't we also handle the rows with a high proportion of nulls?

upvoted 0 times

Cherrie

9 months ago

Yes, we should definitely do that.

upvoted 0 times

...

Roslyn

9 months ago

I think we should handle the rows with nulls.

upvoted 0 times

...

Alecia

10 months ago

I agree with Ines, defining column types and creating full name and full address columns should prepare the data for unification.

upvoted 0 times

...

10 months ago

I think the solution meets the goal.

upvoted 0 times

...