Certified Marketing Cloud DeveloperDemo

By Salesforce · Question Mode

QuestionQ55

Scripting and Automation

How should a developer optimize a query activity that is currently timing out?

  • A Use intermediate tables to stage data
  • B Use intrinsic functions in the WHERE clause
  • C Use SELECT * to include all fields
Explanation

Staging data in intermediate tables splits a complex operation into smaller steps and reduces the volume of data processed at each stage. Salesforce recommends carrying only necessary fields through successive query activities and joining the final results back to the original dataset, reducing storage and retrieval resources.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!