Pergunta de entrevista da empresa ASCAP

I was given a scenario about processing a dataset that would exceed the 50,000 record SOQL limit. The interviewer specifically challenged the use of a standard batch job for this, and instead, insisted that it could be handled more effectively by using SOQL subqueries.