Sign in

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.

Question 1Choose one

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?

Question 2Choose one

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 the Bulk API in parallel concurrency 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]

Question 3Choose one

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?

Question 4Choose one

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?

Question 5Choose one

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?

Question 6Choose one

A multinational corporation operates in the EU and US. They must comply with GDPR 'Right to be Forgotten' requests. When a customer requests deletion, their personal data in the 'Contact' and 'Case' objects in production must be anonymized, but the statistical data (e.g., Case reason, timestamps) must be retained for reporting. Which approach meets this requirement?

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.

Create account