Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-900 Exam - Topic 6 Question 32 Discussion

You are using Dynamics 365 Sales.You need to create a Power BI report that includes customer office locations. The City and State columnsmust be combined to form one column on the report.What should you do?
A) Use Power Query Editor to merge columns.
B) Import the data.
C) Export data to Microsoft Excel.
D) Create a view.

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Sharika
7 months ago
C is a waste of time, just use Power Query!
upvoted 0 times
...
Jannette
7 months ago
I disagree, D is better for creating a view of the data.
upvoted 0 times
...
Nobuko
8 months ago
Wait, can you really merge columns in Power Query? Sounds too easy!
upvoted 0 times
...
Fabiola
8 months ago
I think B could work too, but A is more efficient.
upvoted 0 times
...
Iluminada
8 months ago
Definitely A, merging columns in Power Query is the way to go!
upvoted 0 times
...
Marylou
8 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
8 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
8 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
8 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
8 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
8 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
8 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
...

Save Cancel