Implementing Analytics Solutions Using Microsoft Fabric — Question 100

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?

Answer options

• A. inner
• B. full outer
• C. left outer
• D. right anti
• E. right outer
• F. left anti

Correct answer: B

Explanation

The correct answer is B, full outer join, as it retrieves all rows from both tables, including those that do not have matching rows in the other table. The other options, such as inner and outer joins, only return rows with matches or a subset of rows, thus failing to include all data from both tables.