Salesforce Certified Tableau CRM and Einstein Discovery Consultant — Question 53

A consultant is tasked with creating one query that shows how many opportunities and cases there are per account. Cases and opportunities are found in two different datasets with a reference to the related Account via the AccountId.

What options do the consultant have in Analytics Studio to create the query?

Answer options

• A. a union statement
• B. a fill statement
• C. a cogroup statement
• D. a cogroup or union statement

Correct answer: C

Explanation

The correct answer is C, as a cogroup statement allows for combining datasets based on a common key, like AccountId, effectively showing the number of opportunities and cases per account. Option A, a union statement, would not work as it combines datasets without considering the relationship between them, while options B and D do not provide the best solution for this specific requirement.