Salesforce Exam CRM-Analytics-and-Einstein-Discovery-Consultant Topic 4 Question 5 Discussion

Actual exam question for Salesforce's Salesforce Certified CRM Analytics and Einstein Discovery Consultant exam

Question #: 5
Topic #: 4

[All Salesforce Certified CRM Analytics and Einstein Discovery Consultant Questions]

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 AccoundId.

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

AA fill statement

BA cogrouop or union statement

CA union statement

DA cogroup statement

Show Suggested Answer

Suggested Answer: B

by Milly at Aug 09, 2024, 01:24 AM

Limited Time Offer

25%

Off

Get Premium CRM-Analytics-and-Einstein-Discovery-Consultant Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tula

9 days ago

Hmm, this is a tough one. I'm leaning towards C, but I could also see D being a valid option. I guess it depends on the specific requirements of the consultant.

upvoted 0 times

...

Elvera

14 days ago

I think the consultant can use a cogroup or union statement.

upvoted 0 times

...

Raylene

14 days ago

I'm going with B. A cogroup or union statement seems like the most logical approach to handle this requirement.

upvoted 0 times

...

Hailey

19 days ago

D. A cogroup statement seems like the right choice here, as it would allow the consultant to group the data by AccountId and then work with the opportunities and cases separately.

upvoted 0 times

...