exam questions

Exam PL-900 All Questions

View all questions & answers for the PL-900 exam

Exam PL-900 topic 1 question 99 discussion

Actual exam question from Microsoft's PL-900
Question #: 99
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?

  • A. Query Editor
  • B. Power BI Service
  • C. Microsoft Excel
  • D. Data Connector
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
DevCitizen
Highly Voted 2 years, 11 months ago
on exam 12/29/20
upvoted 20 times
...
SerejoFco
Highly Voted 2 years, 4 months ago
Query Editor is the right answer
upvoted 19 times
...
EdrisKazemi
Most Recent 10 months, 3 weeks ago
Selected Answer: A
A. Query Editor In Power BI, you can use the Query Editor to join the table containing store names and numbers with the table containing sales transaction data. By joining the two tables on the store number, you will be able to show the store name in all Power BI reports that use the transaction data. B. Power BI Service: Power BI service is a web-based service that allows you to view and share Power BI reports, but it does not include the tool to join tables. C. Microsoft Excel: You can use Excel to join tables, but Power BI has its own tool called Query Editor that is more powerful and allows you to join tables in a more efficient way. D. Data Connector: Data connectors are used to connect to various data sources, but it does not include the tool to join tables.
upvoted 11 times
...
rtth
10 months, 4 weeks ago
still seen in exam Jan-23
upvoted 5 times
...
Eltooth
1 year ago
Selected Answer: A
A is correct answer. Power Query
upvoted 2 times
...
kumarGola
1 year, 1 month ago
correct answer is A
upvoted 1 times
...
Cesarin20xx
1 year, 2 months ago
correct answer
upvoted 2 times
...
jellybiscuit
1 year, 2 months ago
Selected Answer: A
query editor You need to define the relationship
upvoted 3 times
...
VladStan
1 year, 3 months ago
What is the correct answer here? I'd say that it is actually done through PBI Desktop -> Model view by making the relationship...
upvoted 1 times
VladStan
1 year, 3 months ago
Power Query has a "join" functionality which can achieve this...
upvoted 2 times
...
...
Contactfornitish
1 year, 7 months ago
In exam today, 11/04/2022
upvoted 3 times
...
easport
1 year, 8 months ago
Verified on exam 17/03/2022
upvoted 2 times
...
KorRaj
1 year, 9 months ago
In Exam on 3/3/22
upvoted 3 times
...
Khella
2 years, 3 months ago
Verified 6/9/2021
upvoted 2 times
...
MaHa_Ma
2 years, 3 months ago
verified 28/08/21
upvoted 3 times
...
techwen
2 years, 5 months ago
Query Editor seems correct to me
upvoted 1 times
...
Davedidisco
2 years, 8 months ago
thought this would be a relationship but if not query editor would be next logical answer
upvoted 2 times
...
thulstrup
2 years, 8 months ago
I don't get it - query editor is where you fetch and transform data - you don't make reports in query editor. The relationship between the store table and the sales data table and the actual report would be made either in the model and report builder part of Power BI Desktop or Power BI Service. I would say that B. Power BI Service is the correct answer.
upvoted 3 times
dojom73239
2 years, 8 months ago
IIRC you can only define relationship in PBI desktop. So PBI service would be wrong here
upvoted 1 times
...
RRJMkNxo
2 years, 3 months ago
@thulstrup, Can't you join tables in PQ?
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...