ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 87 discussion

Actual exam question from Microsoft's PL-300
Question #: 87
Topic #: 2
[All PL-300 Questions]

DRAG DROP
-

You use Power Query Editor to import three tables named Customers, Address, and Country.

In the source system, not every customer has a related address, but every address has a related country.

You need to merge all the tables into a single query. The solution must optimize query refresh performance.

Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by Endeetheanalyst at Sept. 5, 2024, 1:12 p.m.

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
Submit Cancel
Endeetheanalyst
Highly Voted 7 months, 3 weeks ago
This should be left outer join, since the customer table is on the left side.
upvoted 21 times
f534a80
4 months, 2 weeks ago
1. Should be left outer join 2. I don't understand the order of "join". If we join table customer+adress it would be still some customers with null values in adress therefore left outer join. If we join adress with country before joining customer with adress then should be inner join
upvoted 1 times
Rahultakle
4 months ago
Use a Left Outer Join. This join will include all customers and their related addresses, if available. Since not every customer has an address, this join ensures that all customers are included, even if they don't have a corresponding address. Use an Inner Join. This join will include only the addresses that have a related country. Since every address has a related country, this join will ensure that all addresses are matched with their corresponding countries.
upvoted 1 times
...
...
...
rcaliandro
Highly Voted 7 months, 3 weeks ago
In my opinion it is wrong, it should be: Left outer, inner join
upvoted 14 times
rcaliandro
7 months, 3 weeks ago
what do you think guys?
upvoted 1 times
...
...
2c7b65c
Most Recent 1 month, 3 weeks ago
Understanding the Relationships: Customers ↔ Address Not every customer has an address → This means some customers may not be matched with an address. One-to-zero-or-one relationship → A customer may or may not have an address. Address ↔ Country Every address has a related country → This means all addresses will have a corresponding country. One-to-one relationship → Each address belongs to exactly one country. Query Plan: Merge Customers and Address using a Left Outer Join Retains all customers, even those without an address. Merge Address (now merged with Customers) and Country using an Inner Join Ensures that every address has a valid country.
upvoted 1 times
...
SylUK
3 months ago
The answer is Right outer and Inner: MY explanation for Right Outer; Customers is Left and Address Right , the question says 'not every Customer has a relalated Address ' this means in the source system, the Address table has all the records but the Customer table doesn't therefore the RIGHT OUTER should be perfect to merge both table according to the question explanations. Where we will obtain at the end ,a merge table with all addresses with their corresponding customer and even addresses without related customer(NULL VALUES). That means NOT EVERY CUSTOMER HAS A RELATED ADDRESS.
upvoted 2 times
santhosh28
2 months, 1 week ago
If you user right outer, any customer that has no address will not be part of the final table.
upvoted 1 times
...
...
jaume
5 months ago
to link customers with address we should use LEFT INNER to ensure we are getting all customers (from the left table) and matching addresses (every customer has a related address). Since LEFT INNER is not available, we should use the "opposite" which is RIGHT OUTER. Then, each address has a related country, we can use the INNER join
upvoted 1 times
...
LuluSkyy
6 months, 2 weeks ago
I think the answer should be left outer since the customer table is on the left. so we should be all the records on the left table and the matching records on the right table.
upvoted 2 times
...
VladStan
6 months, 2 weeks ago
Left outer, Inner
upvoted 1 times
...
f07fa5c
6 months, 3 weeks ago
Left outer, Inner
upvoted 1 times
...
Jayaruwan
7 months, 2 weeks ago
My previous comment is wrong. I am sorry it is left outer and inner
upvoted 3 times
...
Jayaruwan
7 months, 2 weeks ago
Right outer is correct because some customers have no address
upvoted 4 times
Arth_1111
7 months, 2 weeks ago
Left outer join is correct because we cant ignore the customers who does not have a address. Left table (Customers) should be included. 1. Left Outer Join 2. Inner Join
upvoted 6 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago