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 1 Question 4 Discussion

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?
A) Query Editor
B) Power BI Service
C) Microsoft Excel
D) Data Connector

Microsoft PL-900 Exam - Topic 1 Question 4 Discussion

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

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Desirae
9 months ago
Isn't Microsoft Excel a bit outdated for this kind of task?
upvoted 0 times
...
Noelia
9 months ago
Query Editor makes sense, but I'm surprised it's not just a simple drag-and-drop.
upvoted 0 times
...
Providencia
9 months ago
I thought Power BI Service could do that too?
upvoted 0 times
...
Madalyn
9 months ago
Definitely agree, Query Editor is the way to go!
upvoted 0 times
...
Leota
9 months ago
You need to use Query Editor for this.
upvoted 0 times
...
Kasandra
9 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
10 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
10 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
10 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
10 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
10 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
10 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
...

Save Cancel