Salesforce Certified Platform Data Architect Sample Questions:

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?

A) 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.
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 before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.
D) 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.

2. Northern Trail Outfitters (NTO) wants to start a loyalty program to reward repeat customers. The program will track every item a customer has bought and grants them points for discounts. The following conditions will exist upon implementation:
- Data will be used to drive marketing and product development
initiatives.
- NTO estimates that the program will generate 100 million rows of date monthly.
- NTO will use Salesforce's Einstein Analytics and Discovery to
leverage their data and make business and marketing decisions.
What should the Data Architect do to store, collect, and use the reward program data?

A) Create a custom object in Salesforce that will be used to capture the Reward Program data.
B) Create a big object in Einstein Analytics to capture the Loyalty Program data.
C) Create a custom big object in Salesforce which will be used to capture the Reward Program data for consumption by Einstein.
D) Have Einstein connect to the point of sales system to capture the Reward Program data.

3. North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly. Which two native tools should a data architect recommend to achieve this reporting requirement?

A) Standard reports and dashboards
B) Async SOQL with a custom object
C) Einstein Analytics
D) Standard SOQL queries

4. Universal Containers (UC) is building a Service Cloud call center application and has a multisystem support solution. UC would like or ensure that all systems have access to the same customer information. What solution should a data architect recommend?

A) Let each system be an owner of data it generates.
B) Load customer data in all systems.
C) Implement a master data management (MDM) strategy for customer data.
D) Make Salesforce the system of record for all data.

5. UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.

A) Limit Batch to 10K records
B) Use PK Chunking
C) Export in multiple batches
D) Export Bulk API in parallel mode

Solutions: