Marketing-Cloud-Developer Exam Dumps | In which three ways should a developer optimize a query activity if it is currently timing out? Choose

<< Prev Question Next Question >>

In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3

A. Only update records that have changed since last execution

B. Use SELECT * to include all fields

C. Use intrisic functions in the WHERE clause

D. Use intermediate tables to stage data

E. Use Primary key(s) on fields used in joins

DataExtension - Aug 25, 2025

A, D, E

C is not correct:
"Don’t use these non-searchable arguments in a WHERE clause.
OR
NOT
<
>
NOT EXISTS
NOT IN
NOT LIKE
Intrinsic functions that operate on a column value"

https://help.salesforce.com/s/articleView?id=sf.mc_as_optimize_the_query_activity.htm&type=5

Maja - Nov 28, 2022

Download PDF File