Free Plat-Arch-201 sample questions
Real questions from the Salesforce Certified Platform Data Architect practice bank, with the correct answer and an explanation for each one. No junk, no filler.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 6 of 12 free sample questions.
A telecommunications company uses Salesforce to track customer support tickets. They have accumulated 30 million 'Support_Log__c' records over the past five years. The Support team reports that reports filtering by 'Log_Date__c' and 'Status__c' have started timing out. The 'Support_Log__c' object is a custom object. An architect confirms that 'Log_Date__c' is already indexed. What advanced performance optimization technique should be evaluated next to improve query performance specifically for this custom object without archiving data off-platform?
A manufacturing company is migrating 5 million Order History records from a legacy ERP to Salesforce. The migration window is limited to 8 hours. The target object 'Order_History__c' has a Master-Detail relationship to the 'Account' object. The source data is sorted chronologically. During the initial test load using Bulk API 2.0 in Parallel mode, the architect observes frequent 'UNABLE_TO_LOCK_ROW' errors. What is the most effective strategy to resolve these locking errors while maintaining high throughput? flowchart TD A[Start Migration] --> B{Check Mode} B -- Parallel --> C[Batches Processed Simultaneously] C --> D{Parent Locked?} D -- Yes --> E[Lock Row Error] D -- No --> F[Success] B -- Serial --> G[Batches Processed Sequentially] G --> H[Slower Throughput]
A healthcare provider needs to store audit logs for patient data access. Regulatory requirements dictate that these logs must be retained for 10 years and must be immutable (cannot be modified or deleted by standard users). The volume is estimated at 500 million records per year. The data will rarely be accessed but must be queryable for compliance audits. Which solution best meets these requirements?
An architect is designing a data model for a logistics company. They have a 'Shipment__c' object and a 'Container__c' object. Each Shipment can contain multiple Containers, and a Container can be part of multiple Shipments over time (e.g., reusable containers). The business needs to track the specific date a container was assigned to a shipment. Which relationship type is most appropriate?
A retail company wants to use Salesforce to manage customer loyalty data. They have an external loyalty engine (Oracle DB) that processes points in real-time. The marketing team needs to view the current point balance on the Contact record in Salesforce without storing the data in Salesforce to avoid synchronization issues. They also want to run reports in Salesforce combining Contact data with Loyalty data. What is the recommended solution?
6 more free samples are waiting
Create a free account to unlock the whole Plat-Arch-201 sample bank, or get full access to all 134 practice questions in the simulator.