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 2 Question 36 Discussion

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.
A) Use Power Query to merge columns.
B) Import the data. 18912E1457D5D1DDCBD40AB3BF70D5D
C) Export data to Microsoft Excel.
D) Create a view.

Microsoft PL-900 Exam - Topic 2 Question 36 Discussion

Actual exam question for Microsoft's PL-900 exam
Question #: 36
Topic #: 2
[All PL-900 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer: A

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

by Weldon at May 06, 2022, 07:56 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
Sonia
10 months ago
D could work, but it’s not the best option here.
upvoted 0 times
...
Margo
10 months ago
Wait, can you really do it just with A? Sounds too easy!
upvoted 0 times
...
Victor
11 months ago
C seems unnecessary for this task.
upvoted 0 times
...
King
11 months ago
I think B is also important, but not for merging.
upvoted 0 times
...
Gracia
11 months ago
Definitely A, merging columns in Power Query is the way to go!
upvoted 0 times
...
Nida
11 months 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.
upvoted 0 times
...
Harrison
11 months 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.
upvoted 0 times
...
Sheron
11 months 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.
upvoted 0 times
...
Jerlene
11 months 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.
upvoted 0 times
...
Dulce
11 months 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.
upvoted 0 times
...
Leeann
11 months 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.
upvoted 0 times
...
Rosina
11 months 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.
upvoted 0 times
...

Save Cancel