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?
Suggested Answer: A
Get Premium PL-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
SH
Sharika
11 months ago
C is a waste of time, just use Power Query!
JA
Jannette
12 months ago
I disagree, D is better for creating a view of the data.
NO
Nobuko
12 months ago
Wait, can you really merge columns in Power Query? Sounds too easy!
FA
Fabiola
1 year ago
I think B could work too, but A is more efficient.
IL
Iluminada
1 year ago
Definitely A, merging columns in Power Query is the way to go!
MA
Marylou
1 year ago
Creating a view sounds familiar, but I don't think it would help with merging those specific columns in the report.
AN
Annette
1 year ago
I feel like importing the data might not be enough if we need to combine the City and State into one column.
MI
Michel
1 year ago
I remember practicing a similar question where we had to manipulate data in Power BI, and merging columns was definitely part of it.
KE
Kenda
1 year 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.
SH
Sheridan
1 year 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.
DE
Devorah
1 year 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.
LA
Laquanda
1 year 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.