Salesforce Certified Tableau CRM and Einstein Discovery Consultant — Question 81

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?

Answer options

• A. q - cogroup Opportunity by 'Id', Activities by 'OpportunityId' left;
• B. q - cogroup Opportunity by 'Id' left, Activities by 'OpportunityId';
• C. q - cogroup Opportunity by 'Id' right, Activities by 'OpportunityId';
• D. q - cogroup Opportunity by 'Id', Activities by 'OpportunityId';

Correct answer: B

Explanation

The correct answer is B because it uses a left join to ensure all Opportunity records are included, even those without Activities, while also allowing for the retrieval of related Activities. Option A incorrectly groups Activities first, resulting in lost Opportunities, while C is a right join that excludes Opportunities without Activities. Option D performs an inner join, which would also omit Opportunities without related Activities.