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