Salesforce Certified Platform Data Architect Sample Questions:

1. Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard is not reliable for their real-time decision- making. On analysis, the team the following issues with data entered in Salesforce.
- Information in certain records is incomplete.
- Incorrect entry in certain fields causes records to be excluded in
report fitters.
- Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the issues?

A) Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.
B) design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect
C) Explore third-party data providers to enrich and augment information entered in salesforce.
D) Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.
E) Periodically export data to cleanse data and import them back into Salesforce for executive reports.

2. To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

A) Errors when a duplicate Contact name is found cause upsert to fail.
B) Errors with records being updated and inserted in the same CSV file.
C) Errors with duplicate external Id values within the same CSV file.
D) Errors with using the wrong external Id will cause the load to fail.

3. Which feature controls record-level access?

A) Profiles
B) Roles only
C) Permission Sets
D) Sharing Rules

4. Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

A) Create a text field and make it an external ID.
B) Create a Master -Detail to custom object ShippingStatus c.
C) Create a Lookup to custom object ShippingStatus c.
D) Create a picklist field, values sorted alphabetically.

5. Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount.
Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?

A) Contact each business on the list and ask them to review and update their address information.
B) Build a team of employees that validate Accounts by searching the web and making phone calls.
C) Leverage Data.com Clean to clean up Account address fields with the D&B database.
D) Integrate with a third-party database or services for address validation and enrichment.

Solutions: