Data-Architect Practice Test

All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:
• An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.
• An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.
• A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.
How should the architect determine which of these systems is the system of record?

A.

Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.

B.

Whatever system updates the attribute or object should be the system of record for that field or object.

C.

Whatever integration data flow runs last will, by default, determine which system is the system of record.

D.

Data flows should be reviewed with the business users to determine the system of record per object or field.

Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used. An Architect needs to determine which system is the system of record on a field level. What should the Architect do to achieve this goal?

A.

Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.

B.

Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.

C.

The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.

D.

Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.

Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity data. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?

A.

The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

B.

A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.

C.

The Opportunity engagement system should become the system of record for Opportunity records.

D.

Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?

A.

How many fields are defined on the custom objects that need to be archived?

B.

Which profiles and users currently have access to these custom object records?

C.

If reporting is necessary, can the information be aggregated into fewer, summary records?

D.

Will the data being archived need to be reported on or accessed in any way in the future?

E.

Are there any regulatory restrictions that will influence the archiving and purging plans?

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.

Contact Salesforce support to enable skinny table for cases.

C.

Move data off of the platform and run reporting outside Salesforce, and give access to reports.

D.

Build reports using custom Lightning components.