Salesforce Updated Nonprofit-Cloud-Consultant Exam Questions and Answers by jeremiah

In the Grantmaking lifecycle, transparency and collaboration are key, especially during the application phase. A lead applicant (grant seeker) often needs to bring in subject matter experts, accountants, or board members to help draft specific sections of a complex funding proposal.

To enable this within an Experience Cloud portal, Salesforce utilizes Compliant Data Sharing (CDS). CDS allows for granular, record-level sharing that can be managed directly by end-users (the grant seekers) rather than requiring an administrator to manually adjust sharing rules or public groups every time a collaborator is added.

Step-by-Step Configuration for the Consultant:

Enable CDS: The consultant must first enable "Compliant Data Sharing" in the Setup menu for the relevant objects, such as Individual Application or Funding Award.

Define Participant Roles: Roles like "Collaborator," "Reviewer," or "Signatory" are defined. Each role is assigned a specific access level (Read or Read/Edit).

Add Related Lists: The consultant adds the "Participants" related list to the page layout used in the Grantmaking Portal.

User Empowerment: Once configured, a grant seeker can navigate to their application in the portal, click "Add Participant," and search for other users within their organization to grant them access to that specific application.

This feature ensures that sensitive financial and program data is shared only with authorized individuals, maintaining a high level of security and "compliance" while still promoting the collaborative effort necessary for high-quality grant applications. Permission sets (Option C) provide the broad ability to use the portal, but CDS provides the specific mechanism for peer-to-peer record sharing.

In NPSP, Engagement Plans are used to automate the creation of a set of tasks when a specific goal is identified (e.g., "Major Donor Stewardship"). It is critical to understand the relationship between the Template and the Instance.

The Logic of Decoupling:

The Template: This is the "blueprint" that defines which tasks should be created, who should own them, and what their due dates are relative to the start date.

The Engagement Plan (Instance): When a user applies a template to a Contact or Campaign, the system "explodes" the template and creates actual Task records and an Engagement Plan record.

Persistence: Once those tasks are created, they become independent records. If an admin modifies the original Engagement Plan Template (e.g., adding a new task or changing a deadline), NPSP does not retroactively update existing tasks or plans that were already generated. This is intentional to prevent disrupting ongoing workflows or overwriting manual changes staff may have made to their active tasks.

Result: Any modifications to the template will only be visible on new Engagement Plans created after the change was saved.

To update existing plans, the manager would have to delete the current Engagement Plan and re-apply the updated template, or manually add the new tasks to the current records.

In NPSP, aggregating data from child Opportunity records to the parent Contact or Account record is handled by the Rollup engine. While there are several ways to do this in Salesforce, Customizable Rollups are the standard NPSP tool for this requirement.

Why Customizable Rollups (C) are the best fit:

Cross-Object Support: Standard Roll-up Summary fields (Option B) only work if there is a Master-Detail relationship. Because the relationship between Opportunities and Contacts in NPSP is technically a Lookup relationship (managed through Opportunity Contact Roles), standard roll-ups cannot be used.

Logic and Filtering: Customizable Rollups allow the consultant to define specific "Filter Groups." For example, you can set the rollup to only look at "Closed/Won" donations and ignore "In-Kind" gifts.

Operation Types: To get the "most recent" date, the consultant sets the rollup operation to MAX. The system will look at all qualifying Opportunities, find the one with the latest (highest) date, and write that date to the target field on the Contact.

Automation: Every time a new Opportunity is added or updated, NPSP's nightly batch (or real-time triggers) will re-calculate the value. If a new gift arrives with a more recent date, the old value on the Contact will be overwritten automatically.

Formula fields (Option A) cannot be used because they can only pull data up from a parent to a child, not aggregate multiple child records into a single parent field.