Certified Platform Data Architect practice questions, page 2 of 3, with answer review and explanations.
Question 6
Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field:1. High Value2. Medium Value3. Low ValueWhich strategy should a data architect recommend to configure customer type?
Provide help text to guide users with defined choices.
Create a validation rule to limit entry to defined choices.
Single-select restricted picklist with defined choices.
Lookup to a custom object with defined choices.
Question 7
A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store. The sates associates use Global Search to search for customers in Salesforce before they create the customers.Which option should a data architect choose to implement to avoid duplicates?
Leverage duplicate rules in Salesforce to validate duplicates during the account creation process.
Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
Implement an MDM solution to validate the customer information before creating Accounts in Salesforce.
Develop an Apex class that searches for duplicates and removes them nightly.
Question 8
Universal Containers (UC) has adopted Salesforce as its primary sales automation tool. UC has 100,000 customers with a growth rate of 10% a year. UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.The UC sales team needs to be able to pull up a customer record and view their account status, invoice history, and open opportunities without navigating outside of Salesforce.What should a data architect use to provide the sales team with the required functionality?
Create a custom object and migrate the last 12 months of invoice data into Salesforce so it can be displayed on the Account layout.
Create a visual force tab with the billing system encapsulated within an iframe.
Write an Apex callout and populate a related list to display on the account record.
Create a mashup page that will present the billing system records within Salesforce.
Question 9
Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an "UNABLE_TO_LOCK_ROW" error.Which solution should a data architect recommend to resolve the error?
Leverage Data Loader's platform API to load data.
Perform a batch job in parallel mode and reduce the batch size.
Defer rollup summary field calculation during data migration.
Perform a batch job in serial mode and reduce the batch size.
Question 10
Universal Containers (UC) has implemented Sales Cloud for its entire sales organization. UC has built a custom object called Projects__c that stores customer project details and employee billable hours.The following requirements are needed:1. A subset of individuals from the finance team will need access to the Projects object for reporting and adjusting employee utilization.2. The finance users will not need access to any sales objects, but they will need to interact with the custom object.Which license type should a data architect recommend for the finance team that best meets the requirements?