Exam PL-900 All Questions

View all questions & answers for the PL-900 exam

Exam PL-900 topic 1 question 90 discussion

Actual exam question from Microsoft's PL-900

Question #: 90
Topic #: 1

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.
C. Export data to Microsoft Excel.
D. Create a view.

Show Suggested Answer

Suggested Answer: A 🗳️

by Stik at Sept. 2, 2020, 1:58 a.m.

Comments

Submit Cancel

techwen

Highly Voted 3 years, 7 months ago

A: merge columns is correct. And if there would be DAX as another option, I would choose this since you have to choose two options. All the other answers don't make much sense

upvoted 22 times

ExamCert2022

3 years, 1 month ago

We definitely can use :View" in SQL to merge two column. Remember View is the result of a SELECT statement. So D is correct.

upvoted 4 times

...

alfredpereira

Highly Voted 3 years, 3 months ago

1) Is (A) Merger and 2) IS (D) View

upvoted 6 times

...

SoulRock

Most Recent 1 year, 1 month ago

Selected Answer: A

A. Use Power Query to merge columns

upvoted 1 times

...

artilals

1 year, 1 month ago

In exam 18 dec 2023

upvoted 1 times

...

tiger120155

1 year, 5 months ago

Came out in an August 2023 exam

upvoted 3 times

...

intentando

1 year, 10 months ago

Selected Answer: A

https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d#:~:text=Select%20Transform%20%3E%20Merge%20Columns.,Select%20OK.

upvoted 1 times

...

AZ_Guru_Wannabe

1 year, 10 months ago

Selected Answer: A

I just did this with Power BI desktop. The "each correct answer" part infers that it's a 2 (or more) step process, so I'd choose B then A. You have to import data first as soon as you even open Power BI, so that should be the initial step. Then I selected "transform data" and used power query to merge my columns. If the actual question wants 3 answers, then create a view, visualization, or dashboard would be the next one I'd select. Also, this is the same as question # 72

upvoted 3 times

Maniula

1 year, 7 months ago

"Each correct answer presents a COMPLETE solution." It's the opposite of what you're describing.

upvoted 1 times

...

EdrisKazemi

2 years ago

Selected Answer: A

A. Use Power Query to merge columns. Power Query is a data connection and data transformation tool that allows you to connect to various data sources, including Dynamics 365, and manipulate the data as needed. One of the capabilities of Power Query is the ability to merge columns, which can be used to combine the City and State columns into one column on the report. This is the most efficient way to accomplish this task as it allows you to make the changes directly to the data source and avoid having to manually manipulate the data in another tool like Microsoft Excel.

upvoted 1 times

...

Glubbs

2 years, 1 month ago

Selected Answer: A

Same Q72

upvoted 3 times

...

Lee_Tonida

2 years, 8 months ago

Verified. In exam 5/13/2022.

upvoted 2 times

...

Contactfornitish

2 years, 9 months ago

Came in exam, 11/04/2022

upvoted 1 times

...

Timian

2 years, 10 months ago

First you need to import the data, merge the columns and create a view. That tells me the answer is A, B & D

upvoted 1 times

fujifilm

2 years, 5 months ago

From my understanding, it is not about the process how to get there. So only A & D are correct

upvoted 1 times

...

COVID22

3 years ago

A and D

upvoted 3 times

...

RVS1995

3 years, 5 months ago

Two answers: A - Use Power Query to merge columns C - Export data to Microsoft Excel From Dynamics 365 Sales, export the data to Excel. From Excel, merge the two columns using formula. Save the Excel. Then get data (from Excel) to Power BI.

upvoted 4 times

abiy1102

3 years ago

Yes. since the question seems asking 2 answers i will go with A and C.

upvoted 1 times

...

ViccC

3 years, 4 months ago

The questions said it needed to be a complete solution. For answer C only the 'export data' is given. This implies there will be no import of the data and thus is not a complete solution.

upvoted 6 times

...