Salesforce Certified Platform Data Architect Sample Questions:

1. 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 option

A) Use Big objects for cases older than 2 years, and use nightly batch to move them.
B) Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.
C) Use custom objects for cases older than 2 years and use nightly batch to move them.
D) Sync cases older than 2 years to an external database, and provide access to Service agents to the database

2. DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout. DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.
The Architect needs to ensure this field always contains data coming from the source system.
Which two approaches should the Architect take? Choose 2 answer

A) Set up a Validation Rule to prevent blank values.
B) Mark the field required in setup at the field level.
C) Create a Workflow to default a value into this field.
D) Blame the customer's external system for bad data.

3. UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?

A) Create another field to copy data from encrypted field and use this field in export
B) Leverage Apex class to decrypt data before exporting it.
C) Set up a custom profile for data migration user and assign view encrypted data.
D) Set a standard profile for Data Migration user, and assign view encrypted data

4. Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD's sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.
NTO's management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.
What should a data architect consider before implementing Salesforce Connect for reporting?

A) Maximum page size for server-driven paging
B) Maximum number for records returned
C) Maximum external objects per org
D) OData callout limits per day

5. Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting reports in the Salesforce org. Which solution should a data architect recommend to improve reporting performance?

A) Create a custom object to store aggregate data and run reports.
B) Move data off of the platform and run reporting outside Salesforce, and give access to reports.
C) Contact Salesforce support to enable skinny table for cases.
D) Build reports using custom Lightning components.

Solutions: