Salesforce Certified Tableau CRM and Einstein Discovery Consultant — Question 3

A company used Tableau CRM to create two datasets:
1. "OpportunityWithAccount" dataset, which contains data from the Opportunity standard object augmented by the Account data.
2. "CaseWithAccount" dataset, which contains data from the Case standard object augmented by the Account data.
The company wants to build a lens showing the total number of Opportunities and Cases per Account.
How can a consultant help them build this lens?

Answer options

• A. Use "Compare Table" to join the "OpportunityWithAccount" and "CaseWithAccount" datasets using the "AccountId" and then aggregate by Account.
• B. Use a SAQL query to group and join the "OpportunityWithAccount" and "CaseWithAccount" datasets then generate the results.
• C. Use a Salesforce Direct query to join "OpportunityWithAccount" and "CaseWithAccount" datasets.
• D. Set up Connect Data Sources in the UI between the "OpportunityWithAccount" and "CaseWithAccount" datasets.

Correct answer: B

Explanation

The correct answer is B because using a SAQL query allows for effective grouping and joining of datasets, which is necessary for aggregating the total number of Opportunities and Cases per Account. Options A and D do not provide the same level of data manipulation needed, and option C is less suited for the requirement as it does not utilize the power of SAQL for aggregation.