Adobe Campaign Business Practitioner (CBP) Certification Practice Exam

How do you create the effect of parentheses when specifying filtering conditions in the query editor?

1. Use the AND operator.

2. Use the NOT operator.

3. Combine expressions with OR.

4. Indent the expression.

The correct answer is: Combine expressions with OR.

Using parentheses in filtering conditions allows for controlling the order of evaluation and grouping of conditions, much like in mathematical expressions. The correct answer highlights the use of combining expressions with the OR operator to create groupings that reflect a conditional logic hierarchy. When you combine expressions with the OR operator, you effectively allow for multiple conditions to be satisfied simultaneously. This logical grouping emulates the effect of parentheses, as it defines how the conditions interact with each other. When conditions are structured this way, you can ensure that at least one of the given conditions must be true for the overall expression to be true, effectively persisting the same logic that parentheses would enforce. In contrast, using the AND operator would imply that all conditions must be met, which does not create any conditional groupings akin to parentheses. Likewise, employing the NOT operator changes the meaning of the conditions and does not contribute to grouping as intended. Indenting the expression, while useful for readability, has no bearing on the logical evaluation of conditions in the query editor. Therefore, combining expressions with OR is the method that creates the effect of parentheses in the structure of conditions.