フリー問題

問題文

Two tables, Orders and Returns, are combined with an inner join on Order ID. Some orders were never returned. What happens to those orders in the joined result?

選択肢

1. They are dropped from the result, because an inner join keeps only rows that match in both tables.
2. They are kept, and the Returns columns are filled with zeros.
3. They are kept, and the Returns columns show the most recent return for a similar order, because Tableau falls back to the nearest available key when an exact match is missing.
4. They are kept, and Tableau automatically converts the join to a full outer join.