Salesforce Certified Platform Data Architect Sample Questions:

1. NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTO using Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification. Which 3 considerations are needed prior to a SF Connect implementation? Choose 3 answer

A) Develop an object relationship strategy.
B) Create a 2nd system Admin user for authentication to the external source.
C) Assess whether the external data source is reachable via an ODATA endpoint.
D) Identify the external tables to sync into external objects
E) Configure a middleware tool to poll external table data

2. Which API is best for loading millions of records asynchronously?

A) Streaming API
B) SOAP API
C) Bulk API
D) REST API

3. DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

What should the Architect consider in this situation?

A) Load all data using external IDs to link to parent records.
B) Calculate summary values instead of Roll-Up by using workflow.
C) Load all data after deferring sharing calculations.
D) Calculate summary values instead of Roll-Up by using triggers.

4. UC has millions of case records with case history and SLA data. UC's compliance team would like historical cases to be accessible for 10 years for Audit purpose. What solution should a data architect recommend?

A) Archive Case data using Salesforce Archiving process
B) Use a custom Big object to store archived case data.
C) Purchase more data storage to support case object
D) Use a custom object to store archived case data.

5. Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

A) Use Formula fields to surface information I related entities on the report.
B) Use triggers to populate denormalized related fields on the Account.
C) Use an indexed data field with bounded data filters.
D) Use unbounded date ranges to filter the report.

Solutions: