All practice questions
1784 questions
A Salesforce Administrator at a SaaS enterprise is building an Account report for key account managers. The business requirements state that the report must display Accounts that belong to either the 'Healthcare' or 'Financial Services' industry, AND meet at least one of the following criteria: have an Annual Revenue exceeding $10,000,000 OR maintain an active 'Platinum' SLA subscription. The administrator configures the following report filters:
1. Industry EQUALS Healthcare
2. Industry EQUALS Financial Services
3. Annual Revenue GREATER THAN 10000000
4. SLA EQUALS Platinum
Which filter logic expression should the administrator apply to fulfill this exact business requirement?
A Salesforce administrator at Pinnacle Operations is configuring a custom Duplicate Rule on the Lead object to improve data hygiene. Which two settings or actions can the administrator configure directly within the Duplicate Rule definition? (Select TWO answers)
Select all that apply
An administrator at a non-profit organization needs to automate a business process for a custom object named Volunteer Shift. When a Volunteer Shift record is created or updated and the Hours Completed field is filled, a custom field named Shift Status on the triggering record must automatically be set to Completed before the record is written to the database. The requirement specifies that this automation must deliver optimal performance without causing additional DML operations. Which automation tool configuration should the administrator select?
An organization requires an automated process when a custom object record, Project__c, is updated to a status of 'Cancelled'. The requirements specify: sending an email notification to the project manager, updating the status of all related child Project_Task__c records to 'Cancelled', and removing all associated temporary draft logs from the system. Which limitation of Process Builder must the Salesforce Administrator account for when designing this solution?
A Salesforce Administrator at a renewable energy company is tasked with configuring an Opportunity report for regional sales directors. The report must satisfy the following business requirements:
1. Categorize deals into three distinct size tiers based on the Amount field: 'Small' (< 20,000 to 100,000).
2. Restrict the report results to show only Accounts that have at least one registered active installation record (a custom object related to Account via a lookup relationship).
Which TWO features should the administrator use to fulfill these report requirements?
Select all that apply
An administrator at Borealis Energy created and activated a custom Matching Rule on the Account object using the Account Name and Tax ID fields. However, when sales representatives save new Account records containing values identical to existing accounts, Salesforce saves the records without displaying warnings, blocking creation, or generating entries in Duplicate Record Sets. Which of the following explains why duplicate records are still being created without any warning?
A Salesforce Administrator needs to automate a process for a custom object named Event Sponsorship. When an Event Sponsorship record's status is changed to 'Confirmed', the system must satisfy two requirements: (1) update a custom field named Discount_Rate__c on the triggering record prior to saving, and (2) create a related Task record assigned to the finance team. Which TWO automation approaches should the administrator combine to meet these requirements efficiently while adhering to Salesforce best practices? (Select TWO answers.)
Select all that apply
An organization requires an automated process on the Asset object. When an Asset's status is updated to Obsolete, all related custom Maintenance Request records that are currently Open must have their status updated to Cancelled. To ensure optimal performance and avoid reaching governor limits, how should the administrator configure the Flow Builder elements?
A support manager at Apex Global Services wants to calculate the elapsed business days between the Created Date and Closed Date for each individual support case listed in a detail report. The manager also wants to display these case records grouped by Product Family to analyze average turnaround times. Which solution should the Salesforce administrator implement to calculate the elapsed time for each individual case record within the report?
A Salesforce administrator at Nexus Financial Services needs to configure duplicate management for Account records to prevent duplicate submissions based on a custom Tax Identification Number field. What is the correct sequence of steps required to build, configure, and activate this duplicate prevention process in Salesforce?
Drag items to arrange them in the correct order
An administrator is building an autolaunched flow to update the Stage of all open Renewal Opportunities associated with an Account whenever the Account's service tier changes. To ensure the flow adheres to Salesforce governor limits and bulkification best practices, which two elements or design choices should the administrator include in the flow logic?
Select all that apply
Universal Freight Solutions requires an automated mechanism on a custom object named Vendor Compliance Review. Whenever a Vendor Compliance Review record is created or updated, the system must automatically set the Risk Index score field on the triggering record based on selected risk factors before the record is saved to the database. Which automation tool should the Salesforce administrator select to fulfill this requirement efficiently?
A Salesforce Administrator is asked to automate several business actions when a Contract record status is updated to 'Activated'. The requirements include: creating a follow-up Task, posting an update to the related Account Chatter feed, sending an Email Alert to the contract owner, and deleting temporary draft attachment records associated with the contract. Which requirement CANNOT be accomplished using native Process Builder actions without invoking Apex code or Flow Builder?
An organization tracks client retention through a custom object named Service Contract. When a Service Contract record is updated to a status of 'Renewed', the system must immediately set the Renewal Audit Status field on the same record to 'Completed' before saving to the database. Additionally, an automated email alert must be sent to the Account Owner immediately, and a renewal check-in task must be scheduled 30 days prior to the contract expiration date. Which TWO automation configurations should a Salesforce Administrator select to meet these requirements efficiently using declarative tools?
Select all that apply
A Salesforce administrator at Orion Maritime Solutions created and activated a custom Matching Rule on the Contact object to compare email addresses and phone numbers. However, sales representatives report that the system still allows them to create identical Contact records without displaying any warning or alert. What is the most likely reason for this behavior?
A Salesforce administrator is tasked with building a custom report on Support Cases grouped by Support Tier. The VP of Customer Support requires two specific metrics: evaluating the duration in days between Created Date and Closed Date for every individual case record, and calculating the percentage of closed cases for each Support Tier relative to the grand total of all closed cases. Which two formula configurations should the administrator implement to meet these business requirements?
Select all that apply
A Salesforce Administrator is reviewing declarative automation capabilities for business processes. Match each business automation requirement on the left with the correct Process Builder capability or platform limitation on the right.
Click a left item, then click its matching right item
Items
Matches
An administrator needs to build an autolaunched flow that calculates the total cost of all line items associated with a Work Order and updates a custom total field on the parent Work Order. Which design approach correctly utilizes flow resources and data elements while preventing SOQL and DML governor limit exceptions?
A Salesforce administrator at Zenith Logistics is configuring duplicate management on the Lead object to improve data hygiene. The administrator has already built and activated a custom Matching Rule. Which two settings or actions are configured directly within a Duplicate Rule to control record processing and user notifications when duplicate records are detected?
Select all that apply
An operations manager at a technology firm requests a Salesforce report displaying Accounts and their associated active Assets. The manager requires a custom calculation that evaluates the purchase price of each individual Asset row to output a category label of 'High Value' if the price is greater than 50,000. Which solution should the Salesforce administrator implement to satisfy this requirement?