TABLEAU-CRM-EINSTEIN-DISCOVERY-CONSULTANT practice question 4 of 30

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?

Full set: 242 questions
Answer options
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'; Correct answer
Correct Answer:
D. q = cogroup Opportunity by 'Id' left, Activities by 'Opportunityld';
Scroll to Top