Microsoft PL-900 Exam - Topic 6 Question 32 Discussion

Actual exam question for Microsoft's PL-900 exam

Question #: 32
Topic #: 6

[All PL-900 Questions]

You are using Dynamics 365 Sales.

You need to create a Power BI report that includes customer office locations. The City and State columns

must be combined to form one column on the report.

What should you do?

AUse Power Query Editor to merge columns.

BImport the data.

CExport data to Microsoft Excel.

DCreate a view.

Show Suggested Answer

Suggested Answer: A

https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d

by Sue at May 10, 2022, 04:00 AM

Limited Time Offer

25%

Off

Get Premium PL-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Sharika

4 months ago

C is a waste of time, just use Power Query!

upvoted 0 times

...

Jannette

5 months ago

I disagree, D is better for creating a view of the data.

upvoted 0 times

...

Nobuko

5 months ago

Wait, can you really merge columns in Power Query? Sounds too easy!

upvoted 0 times

...

Fabiola

5 months ago

I think B could work too, but A is more efficient.

upvoted 0 times

...

Iluminada

5 months ago

Definitely A, merging columns in Power Query is the way to go!

upvoted 0 times

...

Marylou

5 months ago

Creating a view sounds familiar, but I don't think it would help with merging those specific columns in the report.

upvoted 0 times

...

Annette

5 months ago

I feel like importing the data might not be enough if we need to combine the City and State into one column.

upvoted 0 times

...

Michel

5 months ago

I remember practicing a similar question where we had to manipulate data in Power BI, and merging columns was definitely part of it.

upvoted 0 times

...

Kenda

5 months ago

I think we might need to use Power Query Editor to merge those columns, but I'm not entirely sure if that's the only way.

upvoted 0 times

...

Sheridan

5 months ago

This one seems pretty straightforward. Python is a popular data analytics tool that is also a general-purpose programming language, so I'm going with D.

upvoted 0 times

...

Devorah

5 months ago

Okay, I've got this. Oracle Inventory receives shipping information and reservations information from Order Management. Those are the two pieces of information I'm confident about.

upvoted 0 times

...

Laquanda

6 months ago

I feel like option C is the best fit here. The question is asking about ensuring the elicitation process was done properly, so that seems to be the most relevant answer.

upvoted 0 times

...