salesforce platform developer 1 practice exam Advanced Practice Exam: Hard Questions 2025

A batch job updates 50,000 Opportunity records nightly. Each Opportunity update triggers an Opportunity after-update trigger that recalculates fields on related Account and inserts a Task for the Opportunity owner. In production, the job intermittently fails with CPU time limit errors and occasional "Too many SOQL queries: 101" errors. The trigger currently queries related Accounts inside a loop and inserts Tasks one-by-one. What is the best architecture change to resolve both issues while preserving behavior?

A developer builds a Lightning Web Component that allows users to mass-update 200 Case records from a list view-like UI. The component calls an @AuraEnabled Apex method that loops through the Cases and performs update statements. Users report that sometimes only a subset of Cases update, and no clear error is shown; debug logs show "UNABLE_TO_LOCK_ROW" errors. What is the best solution to increase reliability and provide clear, record-level error feedback to the UI?

A company stores high-volume IoT readings in a custom object Reading__c (10+ million records). Each Reading__c has a lookup to Asset__c. Users need a report on Asset__c showing the most recent Reading__c value and timestamp. The current solution uses a formula field with a cross-object reference, but it performs poorly and is not feasible for reporting. What is the best approach within Platform Developer I scope?

An org has an after-update trigger on Contact that updates related Account fields when Contact.Title changes. A Flow also updates Contact.Title during Account updates. Users report intermittent "maximum trigger depth exceeded" errors. What is the best way to prevent recursion and ensure updates happen only when necessary?

A Lightning Web Component needs to display a filtered list of records based on the current user’s field-level security (FLS) and sharing. The developer currently uses an @AuraEnabled Apex method that queries fields directly and returns sObjects to the client. A security review flags the code for not enforcing FLS. What is the best Apex-side remediation?

A developer writes an Apex trigger that must create a single "Monthly Summary" record per Account per month based on inserted Invoice__c records. Multiple users may insert invoices at the same time. The current design queries for an existing summary and inserts one if none exists, but duplicates are occasionally created. What is the best platform-native approach to prevent duplicates under concurrency?

A test class for an Apex controller intermittently fails in a full sandbox but passes in a developer sandbox. The failure is "System.QueryException: List has no rows for assignment to SObject". The test relies on existing data and queries for a specific Profile name and a RecordType by developer name. What is the best fix to make the test deterministic and deployment-ready?

A developer needs to deploy a change that adds a new required field to a custom object and updates existing Apex code that inserts records of that object. In a staging environment, deployment fails because existing unit tests insert the object without setting the new required field. What is the best deployment strategy to minimize risk and avoid breaking production?

A company uses a complex approval-like process implemented in Flow. When a custom object Request__c is submitted, it should lock the record, create multiple child tasks, and notify a dynamic set of approvers. The org is hitting governor limits during bulk imports of Request__c because the Flow runs per record and performs multiple queries and DML operations. What is the best redesign that stays within Platform Developer I best practices for bulk operations?

An org has a requirement to show a custom “Risk Score” on Opportunity that is calculated from related OpportunityLineItem records and a third-party risk rating stored on Account. The score must be visible in the UI in real time as users edit line items, and must also be accurate for reports and API integrations. What is the best solution design balancing correctness, performance, and platform constraints?