Free Application Architect Plat-Arch-201 Ultimate Study Guide (Updated 279 Questions) [Q67-Q81]

admin Plat-Arch-201 Salesforce October 27, 2026

Rate this post

Free Application Architect Plat-Arch-201 Ultimate Study Guide (Updated 279 Questions)

Get to the Top with Plat-Arch-201 Practice Exam Questions

Salesforce Plat-Arch-201 Exam Syllabus Topics:

Section	Weight	Objectives
Data Migration	15%	– Describe the tools and best practices for data migration – Describe the considerations for data migration – Describe the implications of data migration on data quality
Data Governance	10%	– Describe the considerations for data quality – Describe the considerations for data classification – Describe the elements of a data governance framework
Salesforce Data Management	25%	– Describe the considerations for data governance – Describe the considerations for data archival – Describe the implications of LDV on data management – Describe the considerations for data migration
Large Data Volumes	20%	– Describe the features and best practices for LDV – Describe the implications of LDV on data modeling – Describe the considerations for Large Data Volumes (LDV)
Master Data Management	5%	– Describe the considerations for a Master Data Management strategy – Describe the methods for aligning data across systems
Data Modeling/Database Design	25%	– Describe the options and considerations for Large Data Volumes (LDV) – Describe the considerations when designing a data model for Salesforce – Describe the implications of LDV on data modeling – Explain the usage of external objects

QUESTION 67
A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren’t relevant any longer. Sales Managers need the data for their historical reporting. What strategy should a data architect use to ensure a better user experience for the Sales Reps?

Create a Permission Set to hide old data from Sales Reps.

Use Batch Apex to archive old data on a rolling nightly basis.

Archive and purge old data from Salesforce on a monthly basis.

Set data access to Private to hide old data from Sales Reps.

QUESTION 68
The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatID field:
Select id, description, Subject from Task where WhatId!= NULL
When the data architect usages the query to select values for a process a time out error occurs.
What does the data architect need to change to make this query more performant?

Remove description from the requested field set.

Change query to SOSL.

Add limit 100 to the query.

Change the where clause to filter by a deterministic defined value.

QUESTION 69
Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce. Which governance measure should a data architect recommend to solve this issue?

Add description fields to explain why the field is used, and mark the field as required.

Create and manage a data dictionary and ups a governance process for changes made to common objects.

Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.

Create validation rules with error messages to explain why the fields is used

QUESTION 70
What is an advantage of using Custom metadata type over Custom setting?

Custom metadata records are not copied from production to sandbox.

Custom metadata types are available for reporting.

Custom metadata records are deployable using packages.

Custom metadata records are editable in Apex.

QUESTION 71
Universal Container is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status. What solution a data architect recommends to give the sales team visibility into order status?

Leverage Canvas to bring the order management UI in to the Salesforce tab.

Build batch jobs to push order line items to salesforce.

leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.

Build real-time integration to pull order line items into Salesforce when viewing orders.

QUESTION 72
DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout. DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.
The Architect needs to ensure this field always contains data coming from the source system.
Which two approaches should the Architect take? Choose 2 answer

Set up a Validation Rule to prevent blank values.

Create a Workflow to default a value into this field.

Mark the field required in setup at the field level.

Blame the customer’s external system for bad data.

QUESTION 73
Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for
5 years. Managers at Get Cloudy Consulting need access to up to one week’s worth of these status reports with all of their details. An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce. Which two limits should the Architect be aware of? (Choose two.)

Data storage limits

Workflow rule limits

API Request limits

Webservice callout limits

QUESTION 74
Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW. What data extraction strategy should a data architect use for maximum performance?

Install a third-party AppExchange tool.

Call the REST API in successive queries.

Utilize PK Chunking with the Bulk API.

Use the Bulk API in parallel mode.

QUESTION 75
Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system. During analysis, UC users highlight a pain point that there are multiple versions of many customers. What should the data architect do for a successful migration to mitigate the pain point?

Hire an intern manually de-duplicate the records after migrating to Salesforce.

Migrate the data as is, and use Salesforce’s de-duplicating feature.

Have the users manually clean the data in the old system prior to migration.

Store the data in a staging database, and de-duplicate identical records.

QUESTION 76
A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

Import Account records first followed by order records after sorting order by OrderID.

Import Account records first followed by order records after sorting orders by AccountID.

Change the relationship to Lookup and update the relationship to master-detail after import.

Import Order records and Account records separately and populate AccountID in orders using batch Apex.

QUESTION 77
Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode. What should an Architect consider when loading the Opportunity records?

Use the Name field values to sort batches.

Order batches by Auto-number field.

Create indexes on Opportunity object text fields.

Group batches by the AccountId field.

QUESTION 78
Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan? Choose 2 answer

Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.

Schedule reports that will automatically catch duplicates and merge or delete the records every week.

Store all data in an external system and set up an integration to Salesforce for view -only access.

QUESTION 79
Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record. What should a data architect recommend to guarantee that records are not being updated at the same time?

Embed the keywords FOR UPDATE after SOQL statements.

Disable classes or triggers that have the potential to obtain the same record.

Migrate programmatic logic to processes and flows.

Refactor or optimize classes and trigger for maximum CPU performance.

QUESTION 80
Universal Containers (UC) has a custom discount request object set as a detail object with a custom product object as the master. There is a requirement to allow the creation of generic discount requests without the custom product object as its master record. What solution should an Architect recommend to UC?

Mandate the selection of a custom product for each discount request.

Create a placeholder product record for the generic discount request.

Remove the master-detail relationship and keep the objects separate.

Change the master-detail relationship to a lookup relationship.

QUESTION 81
Universal Containers has a requirement to store more than 100 million records in salesforce and needs to create a custom big object to support this business requirement. Which two tools should a data architect use to build custom object?

Use DX to create big object.

Use Metadata API to create big object.

Go to Big Object in setup select new to create big object.

Go to Object Manager in setup and select new to create big object.