MENU
You are using Dynamics 365 Sales.
You need to pull data into a Power BI report for your team. The City and State columns must be combined to form one column on the report.
Which function would you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
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
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
12 comments · newest first
SO
Sonia
12 months ago
D could work, but it’s not the best option here.
MA
Margo
1 year ago
Wait, can you really do it just with A? Sounds too easy!
VI
Victor
1 year ago
C seems unnecessary for this task.
KI
King
1 year ago
I think B is also important, but not for merging.
GR
Gracia
1 year ago
Definitely A, merging columns in Power Query is the way to go!
NI
Nida
1 year ago
I’m a bit confused about the options. I know merging columns is a common task, but I wonder if importing the data has anything to do with it.
HA
Harrison
1 year ago
I feel like exporting to Excel might not be the right answer here, but I can't recall if creating a view would help with combining those columns.
SH
Sheron
1 year ago
I think we can use Power Query to merge columns, but I'm not entirely sure if that's the only way to do it.
JE
Jerlene
1 year ago
I remember practicing a question where we had to combine fields in Power BI, and I think merging columns was the right approach then too.
DU
Dulce
1 year ago
Hmm, this seems like a tricky one. I'll need to carefully think through the IP network range and the potential number of host IPs that could be scanned.
LE
Leeann
1 year ago
This looks like a tricky one. I'll need to think through the WebLogic JMS features carefully to figure out which one is best for handling an unreliable network connection.
RO
Rosina
1 year ago
Hmm, I'm a little unsure about this one. I know we need to create the VM in Subscription1, but I'm not sure if the provided command is the complete solution or if there are any other steps involved. I'll need to double-check the documentation.