Practice Free Plat-Arch-201 Exam Online Questions
Universal Containers (UC) has 50 million customers and stores customer order history on an ERP system. UC also uses Salesforce to manage opportunities and customer support.
In order to provide seamless customer support, UC would like to see the customer’s order history when viewing the customer record during a sales or support call.
What should a data architect do in order to provide this functionality, while preserving the user experience?
- A . Use an Apex callout to populate a text area field for displaying the order history.
- B . Use Salesforce Connect and an external object to display the order history in Salesforce
- C . Import the order history into a custom Salesforce object, update nightly
- D . Embed the ERP system in an iframe and display on a custom tab.
B
Explanation:
According to Trailhead2, Salesforce Connect is a feature that allows administrators to integrate external data sources with Salesforce without copying or synchronizing the data. Salesforce Connect can use external objects to display the external data in Salesforce as if it were stored in Salesforce objects, enabling seamless user experience and real-time access.
Option B is the correct answer because it suggests using Salesforce Connect and an external object to display the order history in Salesforce.
Option A is incorrect because using an Apex callout to populate a text area field for displaying the order history can be inefficient and unreliable, as it requires making an HTTP request for each customer record and storing the order history as unstructured text.
Option C is incorrect because importing the order history into a custom Salesforce object, update nightly can consume a lot of storage space and cause data latency, as the order history may change more frequently than once a night.
Option D is incorrect because embedding the ERP system in an iframe and displaying on a custom tab can degrade the user experience and security, as it requires switching between tabs and authenticating with another system.
Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC.
Which two common techniques are used building a data dictionary to store information on how business entities are defined?
- A . Use Salesforce Object Query Language.
- B . Use a data definition language.
- C . Use an entity relationship diagram.
- D . Use the Salesforce Metadata API.
C, D
Explanation:
A data dictionary is a document that describes the structure, format, and meaning of data entities and attributes. A common technique to build a data dictionary is to use an entity relationship diagram (ERD), which shows the logical relationships between objects and fields in a graphical way. Another technique is to use the Salesforce Metadata API, which allows you to retrieve and deploy the metadata that defines your Salesforce org
Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.
Which three recommendations should a data architect make is order to reduce the number of records from the org? Choose 3 answers
- A . Use hard delete in Bulk API to permanently delete records from Salesforce.
- B . Use hard delete in batch Apex to permanently delete records from Salesforce.
- C . Identify records in objects that have not been modified or used In last 3 years.
- D . Use Rest API to permanently delete records from the Salesforce org.
- E . Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.
A, C, E
Explanation:
Using hard delete in Bulk API, identifying records that have not been modified or used in last 3 years, and archiving the records in EDW before deleting from Salesforce are all good recommendations to reduce the number of records from the org1. Using hard delete in batch Apex or Rest API may not be as efficient or scalable as Bulk API
Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and Service History (Service-History__ c) are both custom objects related through a lookup relationship.
Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce. UC has two hours of migration window every week and is facing locking issues as part of the data migration process.
What should a data architect recommend to avoid locking issues without affecting performance of data migration?
- A . Use Bulk API parallel mode for data migration
- B . Use Bulk API serial mode for data migration
- C . Insert the order in another custom object and use Batch Apex to move the records to Service_Order__cobject.
- D . Change the lookup configuration to "Clear the value of this field" when lookup record is deleted.
B
Explanation:
According to the official Salesforce guide1, using Bulk API serial mode for data migration can help avoid locking issues by processing batches in a single thread. This mode ensures that batches are processed in the order they are received and that only one batch is processed at a time. This reduces the risk of lock contention and deadlocks, especially when updating parent and child records in a lookup relationship.
Option B is the correct answer because it suggests using Bulk API serial mode for data migration.
Option A is incorrect because using Bulk API parallel mode for data migration can cause locking issues by processing batches in multiple threads. This mode does not guarantee the order of batch processing and can result in concurrent updates to the same records, which can lead to lock contention and deadlocks.
Option C is incorrect because inserting the order in another custom object and using Batch Apex to move the records to Service_Order__c object adds unnecessary complexity and overhead to the data migration process.
Option D is incorrect because changing the lookup configuration to “Clear the value of this field” when lookup record is deleted does not address the locking issues caused by data migration, but rather by record deletion.
Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.
Which three consideration should the data architect make when evaluating the need for Salesforce Connect?
- A . You want real-time access to the latest data, from other systems.
- B . You have a large amount of data and would like to copy subsets of it into Salesforce.
- C . You need to expose data via a virtual private connection.
- D . You have a large amount of data that you don’t want to copy into your Salesforce org.
- E . You need to small amounts of external data at any one time.
A, D, E
Explanation:
The correct answer is A, D, and E. The data architect should consider these three factors when evaluating the need for Salesforce Connect: You want real-time access to the latest data from other systems, you have a large amount of data that you don’t want to copy into your Salesforce org, and you need to small amounts of external data at any one time. These factors indicate that Salesforce Connect is a suitable solution for creating a connected experience in Salesforce without importing inventory data from a cloud database. Salesforce Connect allows Salesforce to access external data via OData or custom adapters without storing it in Salesforce, which reduces storage costs and ensures data freshness. Salesforce Connect also supports pagination and caching to optimize performance when accessing small amounts of external data at any one time.
Option B is incorrect because if you have a large amount of data and would like to copy subsets of it into Salesforce, you may not need Salesforce Connect but rather use other tools such as Data Loader or API integration.
Option C is incorrect because if you need to expose data via a virtual private connection, you may not need Salesforce Connect but rather use other tools such as VPN or VPC peering.
Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.
Which three consideration should the data architect make when evaluating the need for Salesforce Connect?
- A . You want real-time access to the latest data, from other systems.
- B . You have a large amount of data and would like to copy subsets of it into Salesforce.
- C . You need to expose data via a virtual private connection.
- D . You have a large amount of data that you don’t want to copy into your Salesforce org.
- E . You need to small amounts of external data at any one time.
A, D, E
Explanation:
The correct answer is A, D, and E. The data architect should consider these three factors when evaluating the need for Salesforce Connect: You want real-time access to the latest data from other systems, you have a large amount of data that you don’t want to copy into your Salesforce org, and you need to small amounts of external data at any one time. These factors indicate that Salesforce Connect is a suitable solution for creating a connected experience in Salesforce without importing inventory data from a cloud database. Salesforce Connect allows Salesforce to access external data via OData or custom adapters without storing it in Salesforce, which reduces storage costs and ensures data freshness. Salesforce Connect also supports pagination and caching to optimize performance when accessing small amounts of external data at any one time.
Option B is incorrect because if you have a large amount of data and would like to copy subsets of it into Salesforce, you may not need Salesforce Connect but rather use other tools such as Data Loader or API integration.
Option C is incorrect because if you need to expose data via a virtual private connection, you may not need Salesforce Connect but rather use other tools such as VPN or VPC peering.
Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.
Which 2 data archiving strategies should a data architect recommend? Choose 2 options:
- A . Use custom objects for cases older than 2 years and use nightly batch to move them.
- B . Sync cases older than 2 years to an external database, and provide access to Service agents to the database
- C . Use Big objects for cases older than 2 years, and use nightly batch to move them.
- D . Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.
C, D
Explanation:
The best data archiving strategies for UC are to use Big objects and Heroku with external objects. Big objects allow storing large amounts of data on the Salesforce platform without affecting performance or storage limits. They also support point-and-click tools, triggers, and Apex code. Heroku is a cloud platform that can host external databases and integrate with Salesforce using external objects. External objects enable on-demand access to external data sources via standard Salesforce APIs and user interfaces. Using bulk API to hard delete cases from Salesforce will free up storage space and improve performance.
Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.
Which 2 data archiving strategies should a data architect recommend? Choose 2 options:
- A . Use custom objects for cases older than 2 years and use nightly batch to move them.
- B . Sync cases older than 2 years to an external database, and provide access to Service agents to the database
- C . Use Big objects for cases older than 2 years, and use nightly batch to move them.
- D . Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.
C, D
Explanation:
The best data archiving strategies for UC are to use Big objects and Heroku with external objects. Big objects allow storing large amounts of data on the Salesforce platform without affecting performance or storage limits. They also support point-and-click tools, triggers, and Apex code. Heroku is a cloud platform that can host external databases and integrate with Salesforce using external objects. External objects enable on-demand access to external data sources via standard Salesforce APIs and user interfaces. Using bulk API to hard delete cases from Salesforce will free up storage space and improve performance.
NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO’s product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.
Which licenses does NTO need to provide these features to the Franchisees?
- A . Salesforce Sales Cloud license
- B . Lightning Platform license
- C . Customer Community license
- D . Partner Community license
D
Explanation:
The best license to provide these features to the franchisees is the Partner Community license. Partner Community licenses are designed for external users who collaborate with your sales team on deals, such as resellers, distributors, or brokers. Partner Community users can access standard CRM objects, such as accounts, contacts, leads, opportunities, campaigns, and reports. They can also access custom objects and run dashboards12. Salesforce Sales Cloud license is not a good option because it is intended for internal users who need full access to standard CRM and custom apps. Lightning Platform license is not a good option because it is intended for users who need access to custom apps but not to standard CRM functionality. Customer Community license is not a good option because it is intended for external users who need access to customer support features, such as cases and knowledge articles, but not to sales features
Marketing: All email, SMS, and social campaigns for a customer
Customer service agents using Salesforce would like to view the activities from all four systems to provide support to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?
- A . Explore external data sources in Salesforce to build a 360-degree view of the customer.
- B . Use a customer data mart to create the 360-degree view of the customer.
- C . Periodically upload summary information in Salesforce to build a 360-degree view.
- D . Migrate customer activities fro, all four system into Salesforce.
A
Explanation:
Exploring external data sources in Salesforce to build a 360 degree view of the customer (option A) is the best strategy to satisfy this requirement, as it allows customer service agents to view the activities from all four systems in real time without storing or replicating the data in Salesforce. Using a customer data mart to create the 360 degree view of the customer (option B) is not a good strategy, as it may introduce additional complexity and cost, and it does not leverage the native Salesforce features. Periodically uploading summary information in Salesforce to build a 360 degree view (option C) is also not a good strategy, as it may cause data latency and inconsistency, and it does not provide real-time information. Migrating customer activities from all four systems into Salesforce (option D) is also not a good strategy, as it may cause data redundancy and conflicts, and it does not scale well with large volumes of data.