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

The correct answer is B. full outer. 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

Submitted by thandi_sa· Apr 18, 2026Prepare data

Question

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?

Options

Ainner
Bfull outer
Cleft outer
Dright anti
Eright outer
Fleft anti

How the community answered

(29 responses)

A
7% (2)
B
86% (25)
E
3% (1)
F
3% (1)

Explanation

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

Topics

#SQL Joins#Full Outer Join#Microsoft Fabric#Lakehouse Querying

Community Discussion

No community discussion yet for this question.

Full DP-600 Practice