How should the developer optimize the query?

A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio.

How should the developer optimize the query?
A . Configure a longer timeout period within Administration in Automation Studio.
B . Use intermediate tables to break queries into smaller parts.
C . Ensure all SQL Query Activities are in the same step in the automation.
D . Limit joins to the INNER JOIN within all SQL Query Activities.

View Answer

Answer: B