Salesforce Certified Platform Data Architect (Plat-Arch-201) Exam Practice Test Instant Access

Question 1

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.

Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

AUse picklist fields rather than lookup to custom object.

BLimit assigning one user 10000 records ownership.

CAssign 10000 opportunities to one account.

DLimit associating 10000 opportunities to one account.

ELimit associating 10000 records looking up to same records.

Answer : B, D, E

Data skew occurs when a large number of child records are associated with a single parent record, or when a single user owns a large number of records. This can cause performance issues and lock contention.To avoid data skew, the data architect should limit assigning one user 10,000 records ownership, limit associating 10,000 opportunities to one account, and limit associating 10,000 records looking up to the same record

Question 2

A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:

State in which the customer is located

City in which the customer is located if available

Zip code in which the customer is located if available

Changes to this information should have minimum code changes

What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

ACreate a custom object to maintain the pricing criteria.

BAssign the pricing criteria within customer pricing engine.

CMaintain require pricing criteria in custom metadata types.

DConfigure the pricing criteria in price books.

Answer : C

According to theGet Started with Custom Metadata Typesunit on Trailhead, one of the use cases for custom metadata types is to define custom charges for an accounting app. The unit states that ''Say that your org uses a standard accounting app. You can create a custom metadata type that defines custom charges, like duties and VAT rates. Then you can write some Apex code that calculates the total amount due for each invoice by using the metadata from your custom metadata type.'' Therefore, a similar approach can be used to maintain the pricing criteria for a custom pricing engine in Salesforce.

Question 3

UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org's Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.

UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.

What should a data architect suggest to achieve this 360-degree view of the customer?

AConsolidate the data from each org into a centralized datastore

BUse Salesforce Connect's cross-org adapter.

CBuild a bidirectional integration between all orgs.

DUse an ETL tool to migrate gap Accounts and Contacts into each org.

Answer : A

Consolidating the data from each org into a centralized datastore is the best suggestion to achieve a 360-degree view of the customer. This way, UC can have a single source of truth for all customer data and avoid data silos and inconsistencies. The other options are not feasible because they either require complex integration, additional cost, or data duplication.

Question 4

US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.

Which solution should a data architect use to comply with the DR policy?

ALeverage a 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system.

BLeverage salesforce weekly exports, and store data in Flat files on a protected system.

CUtilize an ETL tool to migrate data to an on-premise archive solution.

DWrite a custom batch job to extract data changes nightly, and store in an external protected system.

Answer : A

The best solution to comply with the DR policy is to leverage a 3rd party tool that extract Salesforce data/metadata and stores the information in an external protected system. This solution can help create a backup of Salesforce data and metadata in case of a disaster or data loss event. It can also help restore data from the backup system to Salesforce if needed.There are various 3rd party tools available in the AppExchange or online that offer data backup and recovery services for Salesforce67. Leverage Salesforce weekly exports and store data in flat files on a protected system is not a good solution because it does not include metadata backup and it does not allow granular or automated data recovery. Utilize an ETL tool to migrate data to an on-premise archive solution is not a good solution because it does not include metadata backup and it may require complex data transformations and synchronizations. Write a custom batch job to extract data changes nightly and store in an external protected system is not a good solution because it does not include metadata backup and it may have performance or reliability issues.

Question 5

Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

AUse third-party AppExchange tools to monitor and measure data quality.

BGenerate reports to view the quality of sample data.

CUse custom objects and fields to calculate data quality.

DExport the data to an enterprise data warehouse and use BI tools for data quality.

Answer : A

Using third-party AppExchange tools to monitor and measure data quality can address the requirement of UC executives by providing features such as data cleansing, deduplication, validation, enrichment, and scoring. These tools can help improve the accuracy, completeness, and consistency of the data entered by sales reps .

Question 6

DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.

A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.

What are two important considerations for the Data Architect in this scenario? (Choose two.)

AStandard list view in-line editing.

BLimitations on Org data storage.

CBulk API limitations on picklist fields.

DLimitations on master-detail relationships.

Answer : B, C

The Data Architect should consider the limitations on Org data storage and the Bulk API limitations on picklist fields when denormalizing the data model into a single Transaction object with a Branch Office picklist.The Org data storage limit is the total amount of data that can be stored in a Salesforce Org, and it depends on the edition and license type of the Org1.The Bulk API limit on picklist fields is the maximum number of values that can be imported or exported using the Bulk API, and it is 1,000 values per picklist field2. These limitations could affect the performance and scalability of the data model, and the Data Architect should plan accordingly.

Question 7

UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.

What should a data architect recommend to ensure data quality is maintained in salesforce.

AActivate validation rules once the leads are loaded into salesforce to maintain quality.

BAllow validation rules to be activated during the load of leads into salesforce.

CDevelop custom APEX batch process to improve quality once the load is completed.

DEnsure the lead data is preprocessed for quality before loading into salesforce.

Answer : D

Ensuring the lead data is preprocessed for quality before loading into Salesforce is the best way to maintain data quality2. Activating validation rules after the load or developing a custom Apex batch process may not catch all the errors or may require additional time and resources. Allowing validation rules to be activated during the load may cause failures or delays.