Examkin

Soru

Zorluk: OrtaReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator at a solar power installation company is building an Opportunity report for executive leadership. The leadership team requires the report to evaluate deals that are successfully closed, and are either valued above $100,000 or originated from a Partner Referral. Additionally, all qualifying records must belong to accounts located within the United States.

The administrator creates the following report field filters:
1. Stage equals Closed Won
2. Amount greater than 100,000
3. Lead Source equals Partner Referral
4. Account Billing Country equals US, USA

Which filter logic configuration satisfies the business requirements?

  1. 1 AND (2 OR 3) AND 4Cevap
  2. B
    1 AND 2 OR 3 AND 4
  3. C
    (1 AND 2) OR (3 AND 4)
  4. D
    (1 OR 2 OR 3) AND 4

Cevap

The correct filter logic expression is 1 AND (2 OR 3) AND 4.
The filter logic expression combining mandatory conditions via AND with alternative conditions enclosed in parentheses, formatted as 1 AND (2 OR 3) AND 4, correctly ensures that Stage equals Closed Won and Billing Country equals US/USA are strictly enforced alongside either high deal amount or partner referral source.

Adım Adım Çözüm

1
Identify mandatory criteria required for all records
Filter 1 (Stage equals Closed Won) and Filter 4 (Account Billing Country equals US, USA) must strictly apply to every record.
The scenario states records must be successfully closed and must belong to accounts in the United States.
2
Identify alternative conditionally satisfying criteria
Filter 2 (Amount greater than 100,000) and Filter 3 (Lead Source equals Partner Referral) are joined by an OR operator.
The requirement specifies deals that either have a high value or originated from a partner referral.
3
Group OR statements using parentheses within the full Boolean filter expression
Combine into 1 AND (2 OR 3) AND 4.
Parentheses ensure the OR statement is evaluated as a single unit before combining with the mandatory AND statements.

Anahtar Kavram

Report Filter Logic and Parentheses Grouping
Bu soruyu puanla

Konular

Report Filtering, Filter Logic, and Bucketing

Bu konudan daha fazla soru