An app builder wants to create a formula field on an Account to include data from related Contacts but is unable to find the relationship in the formula editor. What is a limitation of formulas that could be causing the issue?
The correct answer is D. Unable to reference the child records.
Formula fields can reference fields from related parent records using cross-object formulas, but they cannot directly pull values from multiple child records onto a parent record. Salesforce describes cross-object formulas as formulas that can reference fields from a parent object when the formula is created on the child/detail side of the relationship.
In this case, Account is the parent and Contacts are child records. Since the formula is being created on Account and trying to reference related Contacts, the relationship does not appear in the formula editor.
Correct design alternatives: use a roll-up summary where supported, Flow, Apex, or reporting.
===========
DreamHouse Realty is rethinking its sandbox utilization strategy after acquiring Cloud Kicks. The Salesforce COE already utilizes a partial and a Full sandbox, which it refreshes on their own regular schedules. Teams are expanding and have to begin each of their small projects in a sandbox before Committing to the larger pool for collaborative testing while still keeping costs down. Which sandbox type should be considered first?
The correct answer is C. Developer sandbox.
For small, individual projects where teams need separate environments before moving work into a larger shared testing sandbox, a Developer sandbox should be considered first. It is intended for development and testing of configuration changes in an isolated environment and is the lowest-cost sandbox option compared with Developer Pro, Partial, and Full sandboxes. Salesforce describes sandbox types for different testing and development needs, with Developer and Developer Pro sandboxes copying configuration/metadata rather than full production data.
Developer Pro provides more storage, but the question emphasizes small projects and keeping costs down. Partial and Full sandboxes are better for broader testing with data, but they are not the first choice for many small isolated development efforts.
===========
An app builder at Cloud Kicks created a custom object and related fields in the schema builder. Which next steps should the app builder take to ensure users can access the new object and fields?
The correct next steps are A. Add the fields to the page layout on the object and C. Create a permission set for access to the object and fields.
This is a two-part access problem in Salesforce: users need both security access and user-interface exposure. Creating a custom object and fields in Schema Builder only creates the metadata. It does not automatically guarantee that end users can see, create, edit, or use those records and fields.
C is required because object permissions define the base-level access users have to records for an object, such as create, read, edit, and delete. Salesforce also uses field permissions / field-level security to control whether users can view or edit individual fields. Permission sets are the correct modern mechanism to grant object and field permissions to selected users without changing their base profile.
A is also required because page layouts control the organization of fields on record detail and edit pages. Even if a user has field-level access, the field must be placed on the relevant page layout for normal record-page visibility and editing in the UI. Salesforce specifically separates field-level security as the access-control layer and page layouts as the UI organization layer.
B is incorrect because ''Allow Reports'' only makes the object available for report creation; it does not grant users object CRUD access or field-level visibility. D is incorrect because data types are assigned during field creation, not after, and choosing a data type does not grant user access.
Universal Containers uses a custom object called Projects. When managers Assign projects, they set a custom field on the Project record called Estimated Hours. Once set, users should be able to decrease but not increase the value. How can an app builder meet this requirement?
The correct answer is C. Create a validation rule that uses the PRIORVALUE function.
The requirement is: once Estimated Hours is set, users can decrease the value but cannot increase it. A validation rule can compare the new value with the old value by using PRIORVALUE().
Example logic:
Estimated_Hours__c > PRIORVALUE(Estimated_Hours__c)
Salesforce documents PRIORVALUE() as the function used to return the previous value of a field, and Salesforce examples use it in validation rules to compare a changed value against the prior value.
A is incomplete because ISCHANGED() only detects that the field changed; it does not determine whether the value increased or decreased.
B is incorrect because a default value does not control later edits.
D is incorrect because PREVGROUPVAL() is used in reports, not validation rules.
===========
Universal Containers utilizes opportunities and a custom object called Detaited.Sales__c. The company would like to roll sales metrics up to an opportunity for only Detailed.Sales__c records that have their picklist status set to Active.
What is the recommended method for the app builder to achieve this request?
Create a master-detail relationship between the parent and child object with a roll-up summary field that filters on the status field is the recommended method for the app builder to achieve the request of rolling up sales metrics to an opportunity for only Detailed.Sales__c records that have their picklist status set to Active. According to theSalesforce documentation, ''Roll-up summary fields calculate values from related records, such as those in a master-detail relationship.'' A roll-up summary field can filter on a field value of the child records and sum up only those records that match the criteria. Utilize the AppExchange to download a third-party application that can roll up the sales dollars with the appropriate filter, create a lookup relationship between the parent and child object with a roll-up summary field that filters on the status field, and utilize Apex code to roll up the desired amounts are not valid or necessary methods for this request.
Betty Collins
4 days agoKaren Bell
18 days agoRebecca Martinez
1 month agoDonna Perez
2 months agoBrian Evans
2 months agoJames Bell
3 months agoDavid Wright
3 months agoRebecca King
2 months agoElizabeth Lewis
2 months agoJohn Green
2 months agoHollis
3 months agoEmeline
4 months agoEmmett
4 months agoCaren
4 months agoMarsha
4 months agoChaya
5 months agoGlendora
5 months agoTrina
5 months agoAliza
5 months agoWillard
6 months agoShannon
6 months agoPaulene
6 months agoJamal
6 months agoNa
7 months agoFloyd
7 months agoNaomi
7 months agoShizue
7 months agoMalinda
8 months ago