Which Join Returns All Rows in Both Tables?

Query and analyze data
Answer Correct answer: B — Use a full outer join to return all rows from both tables in a merge query.

You have a Fabric tenant that contains a lakehouse. You plan to use a visual query to merge two tables. You need to ensure that the query returns all the rows in both tables. Which type of join should you use?

  1. inner
  2. full outer Correct Answer
  3. left outer
  4. right anti
  5. right outer

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

The question tests knowledge of SQL join types and the common trap is confusing partial outer joins (left/right) with a full outer join that preserves all rows from both sides.

To return all rows from both tables in a Fabric lakehouse visual query, a full outer join is required. This page explains why full outer join is the correct choice over inner, left, or right joins.

Choosing left outer or right outer, which only return all rows from one table, not both.

Community Discussion (6 comments)

nappi1 👍 1 Selected: B
since there is no other information on the tables, the answer is the academical one
vernillen 👍 1 Selected: B
Just making it more obvious, but yea... all other options wouldn't return all the rows in both tables but exclude some.
stilferx 👍 3 Selected: B
IMHO, 1st grage of SQL school - FULL OUTER JOIN. Because - ALL rows, not from left, right, ... table(s)
2dc6125 👍 3
B. Left or right will only return one table all rows and other table if exist in the other table. inner will only return if data match in both tables so Full (outer) join will return all data from both tables
VAzureD 👍 4 Selected: B
FULL (OUTER) JOIN https://www.w3schools.com/sql/sql_join.asp
Nefirs 👍 2 Selected: B
full outer keeps rows from both sides

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

A full outer join combines the results of both left and right outer joins. It returns all rows from both the left and right tables, filling missing data with NULLs where there is no match. This directly satisfies the requirement to return all rows in both tables.

Why the Other Options Are Wrong

An inner join (A) only returns rows where there is a match in both tables. Left outer (C) and right outer (E) return all rows from only one table and matched rows from the other. Right anti (D) returns only rows from the right table that have no match in the left table.

Community Comment Notes

The community strongly agrees on the full outer join, noting it is a fundamental SQL concept. As stilferx noted, "FULL OUTER JOIN. Because - ALL rows, not from left, right,... table(s)", and vernillen added that other joins "wouldn't return all the rows in both tables but exclude some."

Official Reference

https://www.w3schools.com/sql/sql_join.asp

Exam Strategy

When a question specifies returning all rows from both tables without exclusions, immediately look for 'full outer join'. Eliminate inner and anti joins first, then distinguish between left/right and full.

Related Analysis

You have a Fabric warehouse named Warehouse1 that contains a

A-Grade

You have a Fabric tenant that contains a lakehouse named Lak

A-Grade

Note: This question is part of a series of questions that pr

A-Grade

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide