Salesforce Certified Platform Data Architect Sample Questions:

1. Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc. Which two recommended approaches would address the above requirement?

A) Use Weekly Export to extract transactional data to on-premise systems.
B) Use Field Audit History to capture operational data and extract it to on-premise systems.
C) Use Event Monitoring to extract event data to on-premise systems.
D) Use a custom built extract job to extract operational data to on-premise systems.

2. Universal Containers (UC) is in the process of migrating legacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements:
- Legacy inventory data will be stored in a custom child object called
Inventory_c.
- Inventory data should be related to the standard Account object.
- The Inventory object should Invent the same sharing rules as the
Account object.
- Anytime an Account record is deleted in Salesforce, the related
Inventory_c record(s) should be deleted as well.
What type of relationship field should a data architect recommend in this scenario?

A) Master-detail relationship filed on Account, related to Inventory_c
B) Lookup relationship fields on Inventory related to Account
C) Master-detail relationship filed on Inventory_c, related to Account
D) Indirect lookup relationship field on Account, related to Inventory_c

3. Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

A) Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.
B) Store all data in shadow custom objects on any updates and deletes, and extract them as needed .
C) Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.
D) Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

4. Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table. What should the data architect do in order to migrate the data to Salesfoce?

A) Migrate the data and assign to a non-person system user.
B) Migrate to Salesforce without a record owner.
C) Assign record owner based on relationship.
D) Create custom objects to store agent relationships.

5. Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data. Which two solutions should a data architect recommend to resolve the complaints?

A) Implement a de-dupe solution and establish account ownership in Salesforce
B) Build a nightly batch job to de-dupe data, and merge account records.
C) Build a nightly sync job from ERP to Salesforce.
D) Integrate Salesforce with ERP, and make ERP as system of truth.

Solutions: