ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 35 - Certified Tableau CRM and Einstein Discovery Consultant discussion

Report
Export

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';
Answers
A.
q = cogroup Opportunity by 'Id', Activities by 'Opportunityld';
B.
q = cogroup Opportunity by 'Id', Activities by 'Opportunityld' left;
Answers
B.
q = cogroup Opportunity by 'Id', Activities by 'Opportunityld' left;
C.
q = cogroup Opportunity by 'Id' right, Activities by 'Opportunityld';
Answers
C.
q = cogroup Opportunity by 'Id' right, Activities by 'Opportunityld';
D.
q = cogroup Opportunity by 'Id' left, Activities by 'Opportunityld';
Answers
D.
q = cogroup Opportunity by 'Id' left, Activities by 'Opportunityld';
Suggested 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

asked 23/09/2024
Stephen DeWhite
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first