Pass the Salesforce App Builder Platform-App-Builder Questions and answers with ValidTests

Roll-up summaries allow MAX, MIN, SUM, COUNT, and AVG functions on numeric fields from child records related by a master-detail relationship. Roll-up summaries are limited to master-detail relationships and cannot be used with lookup relationships. An object can have up to 40 roll-up summary fields, not 25. An object can have up to 25 relationship fields (master-detail or lookup), not 20.

The app builder should use a global picklist value set to share the list of values for the Status field across each object. A global picklist value set is a set of values that can be used by multiple picklist fields on different objects. This can ensure data consistency and reduce maintenance efforts. Option A, C, and D are not features that can share picklist values across objects.

To test code against a subset of production data under 5 GB and to refresh the sandbox environment weekly, the most suitable type of sandbox is:

Partial Copy (B). A Partial Copy sandbox includes a copy of your production org’s metadata and a subset of your production data as defined by the sandbox template. It allows up to 5 GB of data and can be refreshed every 5 days, making it ideal for scenarios where a representative sample of production data is needed for testing without the storage and refresh limitations of a Full Copy sandbox.

Developer Pro (A) and Developer (D) sandboxes also allow for testing and development but do not include a subset of production data—they either have no data or only limited sample data. A Full Copy sandbox (C) provides a full replica of production data, far exceeding the 5 GB requirement and generally is refreshed less frequently due to larger data volume and longer copy times.

Reference for sandbox types and their capabilities:

Sandbox Types and Templates: https://help.salesforce.com/articleView?id=sf.data_sandbox_implementation_tips.htm &type=5

The full sandbox should be refreshed after each major release to production. This way, the full sandbox will have the most updated data and metadata from the production org, and can be used for final load and regression testing before the next release. Option A is incorrect because refreshing the full sandbox after user acceptance testing is complete is not necessary, as user acceptance testing can be done in the partial data sandbox or the production org. Option B is incorrect because refreshing the full sandbox after each push from the partial data sandbox is not necessary, as the full sandbox can receive configuration and code changes from the partial data sandbox without refreshing. Option D is incorrect because refreshing the full sandbox after a new user is added to production is not necessary, as adding a new user does not affect the data and metadata in the full sandbox.

For automatically updating contact statuses when an account type changes:

D. Record triggered flow. This type of automation can monitor changes in account types and accordingly update related records, such as contacts.

Steps to implement:

Navigate to Setup → Flows.

Create a new Flow and choose the record-triggered flow type.

Configure the flow to trigger when the Account record is updated to 'Past-Customer'.

Add an Update Records element to modify all related contacts, setting their status to 'Re-Market'.

Activate the flow.

This automation ensures that contact statuses are updated in real-time when their related account's type changes, maintaining data consistency and relevancy.

For more on record-triggered flows, check out Salesforce's Record-Triggered Flows documentation.

To meet the requirement of summarizing the number of open and closed cases on an Account, two potential automation solutions can be used:

Option A (AppExchange): Salesforce AppExchange offers various pre-built apps and components, including those for case management, which could provide the functionality to summarize cases and categorize customer support utilization. Many apps can handle complex business requirements like case summary roll-ups and could meet the needs without custom development.

An indirect lookup relationship is a custom relationship between two objects that are linked by an external ID field. The external ID field must be a custom field on the parent object that has the “External ID” attribute enabled. The child object must be a standard or custom object that is on the detail side of a master-detail or lookup relationship.

An Approval Process is the appropriate feature to manage and enforce that new vendors accept terms on agreements before an opportunity can be closed. This process can be configured to require approvals from designated approvers when certain conditions are met, ensuring that all necessary agreements are in place and validated before proceeding.

A: Email Alert cannot enforce acceptance of terms.

B: Dynamic Action primarily adjusts the user interface based on field values, not process management.

The best way to implement this requirement is to create a formula field on the Case object using the TEXT function. A formula field can display the value of another field from a related object, such as the Account object. The TEXT function can convert a picklist value into text, which can be displayed on the Case record. Creating a formula field on the Account object using the ISPICKVAL function is not a valid solution, as it does not show the value of Support Level on the Case record. The ISPICKVAL function is used to check if a picklist field has a certain value, not to display it. Creating a Process Builder and using a field update on the Case object is not an optimal solution, as it requires more configuration and maintenance than a formula field. A Process Builder may also introduce delays or errors in updating the field value. Creating a roll-up summary field using Support Level on the Account object is not a valid solution, as it does not show the value of Support Level on the Case record. A roll-up summary field is used to aggregate numeric values from child records, not to display picklist values.

If an employee attempts to edit the description field after submitting an opportunity for approval, they will be presented with a ‘Record Lock’ notification. This means that the record is locked for editing while it is in the approval process and only users with the “Modify All” permission or users above them in the role hierarchy can edit it. [Source]