Free Salesforce Certified Data Architect (WI23) Exam Data-Architect Exam Practice Test

A large retail B2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system: 1. Salesforce CRM3. Customer Master Data management (MDM)4. Contract Management system5. Marketing solutionWhat should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

• Store the salesforce id in all the solutions to identify the customer.
• Create a custom object that will serve as a cross reference for the customer id.
• Create a customer data base and use this id in all systems.
• Create a custom field as external id to maintain the customer Id from the MDM solution.

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?

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

Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not routed by assignment rules are assigned to a dummy user. Sales rep are complaining of high load times and issues with accessing leads assigned to the dummy user.What should a data architect recommend to solve these performance issues?

• Assign dummy user last role in role hierarchy
• Create multiple dummy user and assign leads to them
• Assign dummy user to highest role in role hierarchy
• Periodically delete leads to reduce number of leads

Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

• Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.
• Schedule reports that will automatically catch duplicates and merge or delete the records every week.
• Enforce critical business processes by using Workflow, Validation Rules, and Apex code.
• Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

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?

• Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.
• Whatever system updates the attribute or object should be the system of record for that field or object.
• Whatever integration data flow runs last will, by default, determine which system is the system of record.
• Data flows should be reviewed with the business users to determine the system of record per object or field.

Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?

• Allow users to import their data using the Salesforce Import tools.
• Utilize a 3rd -party solution from the AppExchange for data uploads.
• Utilize an app from the AppExchange to create data -quality dashboards.
• Use Apex to validate the format of phone numbers and postal codes.

Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?

• After the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.
• Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.
• Enable 'Set Audit Fields' and assign the permission to the user loading the data for the duration of the migration.
• Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate 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?

• Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.
• Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.
• The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.
• 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 (UC) owns several Salesforce orgs across a variety of business units. UC management has declared that it needs the ability to report on Accounts and Opportunities from each org in one place. Once the data is brought together into a global view, management would like to use advanced Al-driven analytics on the dataset.Which tool should a data architect recommend to accomplish this reporting requirement?

• Run standard reports and dashboards.
• Install a third-party AppExchange tool for multi-org reporting.
• Use Einstein Analytics for multi-org.
• Write a Python script to aggregate and visualize the data.

What makes Skinny tables fast? Choose three answers.

• They do not include soft-deleted records
• They avoid resource intensive joins
• Their tables are kept in sync with their source tables when the source tables are modified
• They can contain fields from other objects
• They support up to a max of 100 of columns