Microsoft PL-900 Exam - Topic 1 Question 4 Discussion

Actual exam question for Microsoft's PL-900 exam

Question #: 4
Topic #: 1

A company manages a chain of retail stores. The company stores a list of retail store names and numbers in one Power BI table. The company stores sales transaction data including a transaction ID in another table.

The transaction ID includes the store number.

You need to show the store name for all retail transactions in all Power BI reports.

Which tool should you use?

AQuery Editor

BPower BI Service

CMicrosoft Excel

DData Connector

Show Suggested Answer

Suggested Answer: A

Power BI Desktop comes with Query Editor, where you can connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop.

https://docs.microsoft.com/en-us/power-bi/desktop-query-overview

by Herminia at May 03, 2022, 09:15 PM

Limited Time Offer

25%

Off

Get Premium PL-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Desirae

4 months ago

Isn't Microsoft Excel a bit outdated for this kind of task?

upvoted 0 times

...

Noelia

4 months ago

Query Editor makes sense, but I'm surprised it's not just a simple drag-and-drop.

upvoted 0 times

...

Providencia

4 months ago

I thought Power BI Service could do that too?

upvoted 0 times

...

Madalyn

5 months ago

Definitely agree, Query Editor is the way to go!

upvoted 0 times

...

Leota

5 months ago

You need to use Query Editor for this.

upvoted 0 times

...

Kasandra

5 months ago

I remember we discussed how to display related data in reports, but I can't recall if it was specifically about using Power BI Service or something else.

upvoted 0 times

...

Hyman

5 months ago

This question reminds me of a practice scenario where we had to relate two tables. I feel like the Data Connector could also be relevant here.

upvoted 0 times

...

Justine

5 months ago

I think we might need to use the Query Editor to merge the tables, but I'm not entirely sure if that's the right approach.

upvoted 0 times

...

Shenika

5 months ago

I’m leaning towards Query Editor since it’s often used for data transformation, but I wonder if there’s a simpler way to achieve this in Power BI.

upvoted 0 times

...

Brandon

5 months ago

This seems pretty straightforward. I just need to make sure I allocate the overhead costs correctly and then subtract the total costs from the selling price to get the profit per unit.

upvoted 0 times

...

Annelle

5 months ago

I'm pretty sure the answer is B. In a MIL test environment, you can access the system at any point through access points, so stimulations and observations are possible anywhere.

upvoted 0 times

...

Alisha

5 months ago

Hmm, I'm a bit unsure about this one. The "Analyze in Excel" option is something I remember learning about, but I can't quite recall where it's located in the Power BI interface. I'll need to think this through step-by-step.

upvoted 0 times

...