Exam4Training

Which SAQL statement will fetch all Opportunities, even if they don’t have associated Activities, and fetch related Activity data, if it exists?

In an org, some of the Activity records do not have related Opportunity records. Additionally, there are Opportunity records that do not have related Activity records.

Which SAQL statement will fetch all Opportunities, even if they don’t have associated Activities, and fetch related Activity data, if it exists?
A . q = cogroup Opportunity by ‘Id’, Activities by ‘Opportunityld’;
B . q = cogroup Opportunity by ‘Id’, Activities by ‘Opportunityld’ left;
C . q = cogroup Opportunity by ‘Id’ right, Activities by ‘Opportunityld’;
D . q = cogroup Opportunity by ‘Id’ left, Activities by ‘Opportunityld’;

Answer: D

Explanation:

https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_statement_cogroup.htm

Latest ANC-301 Dumps Valid Version with 242 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version