Question 1

Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records. What would be the recommended approach to help UC start immediately?

Options :

A : Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.

B : Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.

C : Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.

D : Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.

Answer: B

Question 2

A healthcare organization wants to regularly export large volumes of patient data from their Salesforce platform for further processing and backup purposes. What is an effective way to perform such an operation?

Options :

A : Use Salesforce-s Data Import Wizard for data export

B : Use the 'Export All' feature in Salesforce-s Data Export service

C : Use Salesforce-s SOAP API for data export

D : Manually export data by copying and pasting records into a spreadsheet

Answer: B

Question 3

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

Options :

A : Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields

B : Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

C : Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

D : Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

Answer: B,C

Question 4

Your organization uses Salesforce Customer 360 for managing contacts and campaigns. You are tasked with designing a data model to track the responses to various campaigns. A contact can respond to multiple campaigns and a campaign can have multiple responses. However, responses should be unique per contact per campaign. What would be the most suitable design to meet this requirement?

Options :

A : Create a junction object "CampaignResponse" with master-detail relationships to both "Contact" and "Campaign"

B : Create a custom object "CampaignResponse" and use a lookup field on the "Contact" object to relate it to "CampaignResponse"

C : Use a multi-select picklist on the "Contact" object to list all campaign responses

D : Use a multi-select picklist on the "Campaign" object to list all campaign responses

Answer: A

Question 5

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO isfacing query timeout issues while extracting these records.What should a data architect recommend in order to get around the time out issue?

Options :

A : Use a custom auto number and formula field and use that to chunk records while extracting data.

B : The REST API to extract data as it automatically chunks records by 200.

C : Use ETL tool for extraction of records

D : Ask SF support to increase the query timeout value.

Answer: C

Higher Test Marks with Free Online Plat-Arch-201 Exam Practice

Buying Options: