Pergunta de entrevista da empresa Tact.ai

Which join is optimal between cross join vs other joins specially in DWH