A monthly comparison must include months with zero activity rather than omitting them from the chart. Which approach best fits?

1. Join results to a complete calendar dimension and fill only the intended missing measures.
2. Validate join cardinality and aggregate or deduplicate at the intended grain.
3. Use SAFE_DIVIDE and handle its result explicitly.
4. Use COUNT DISTINCT on the stable customer identifier.