Question

A data engineer needs to build a complete availability matrix for a Gold-layer report. Each of the 500 store locations must appear once for every date in a 365-row date dimension table, regardless of whether any sales occurred. Both tables share no common join key. Which Spark SQL join produces all 182,500 store-date combinations?

Accepted Answer

A CROSS JOIN between the stores table and the date dimension table

Answer

An INNER JOIN on store_id = date_id

Answer

A LEFT OUTER JOIN with the date table on the left side

Answer

A FULL OUTER JOIN between the two tables