Salesforce Certified Tableau CRM and Einstein Discovery Consultant — Question 46

The Universal Containers company used Tableau CRM to create two datasets:
✑ Dataset A: contains a list of activities with an "activityID" dimension and a "userID" dimension
✑ Dataset B: contains a list of users with a "userID" dimension
The team wants to delete from Dataset A all activities related to users in Dataset B.
How can a Tableau CRM Consultant help them achieve this?

Answer options

• A. Use an external ETL tool to extract both datasets and delete records.
• B. Use a combination of dataflow transformations: "augment" and "filter."
• C. Use the dataflow transformation "delete" and set "userID" as the deletion ID.
• D. Use the recipe operation "delete" and set "userID" as the deletion ID.

Correct answer: B

Explanation

The correct answer is B because using a combination of 'augment' and 'filter' transformations allows the consultant to effectively manage the datasets and remove the desired activities from Dataset A based on the criteria from Dataset B. Option A is incorrect as it suggests an external ETL tool, which is not necessary within Tableau CRM. Option C and D are also incorrect since they imply a simple deletion process that does not leverage the capabilities of dataflow transformations to refine the datasets.