Question 1
A consultant is designing a dataset for a global sales team. The requirement states that regional managers should only see data for their specific region, while the VP of Sales must see all data. The Salesforce Org uses a Role Hierarchy where the VP is at the top, but the regional managers are in a custom 'Region' object related to the User object, not strictly in the standard Role Hierarchy. Which security implementation strategy effectively meets this requirement in CRM Analytics?
Answer and explanation
Correct answer: C
Since the security requirement is based on a custom 'Region' object relationship rather than the standard Salesforce Role Hierarchy, standard inheritance won't work directly. The best approach is to flatten the relevant hierarchy or attributes into the dataset during data prep and then use a security predicate (e.g., 'Region' == '$User.Region__c' || 'VP_Flag' == true) to control visibility.