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 picklist field, values sorted alphabetically.

B. Create a Master -Detail to custom object ShippingStatus c.

C. Create a Lookup to custom object ShippingStatus c.

D. Create a text field and make it an external ID.

A company has 12 million records, and a nightly integration queries these records.

Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

A. Make sure the query doesn't contain NULL in any filter criteria.

B. Create a formula field instead of having multiple filter criteria.

C. Create custom indexes on the fields used in the filter criteria.

D. Modify the integration users' profile to have View All Data.

Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

A. Extract the Salesforce data into Excel and manually compare this against the trusted source.

B. Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

C. Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

D. Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years. What is the recommended solution to ensure longterm performance, bearing in mind the above requirements?

A. Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.

B. Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.

C. Implement a new Categories custom object and a master-detail relationship from Account to Category.

D. Implement a new Categories custom object and create a lookup field from Account to Category.

An Architect needs information about who is creating, changing, or deleting certain fields within the past four months.

How can the Architect access this information?

A. Create a field history report for the fields in question.

B. After exporting the setup audit trail, find the fields in question.

C. After exporting the metadata, search it for the fields in question.

D. Remove "customize application" permissions from everyone else.

Universal Containers (UC) is planning a massive Salesforce implementation with large volumes of data. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.

What should a data architect do to minimize data load times due to system calculations?

A. Enable defer sharing calculations, and suspend sharing rule calculations

B. Load the data through data loader, and turn on parallel processing.

C. Leverage the Bulk API and concurrent processing with multiple batches

D. Enable granular locking to avoid "UNABLE _TO_LOCK_ROW" error.

What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

A. Reference data policy.

B. Data governance policy.

C. Data sensitivity policy.

D. Compliance categorization policy.

Universal Containers (UC) owns multiple Salesforce orgs that are distributed across regional branches. Each branch stores local customer data inside of its org's Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.

UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all of its orgs in one place.

What should a data architect suggest to achieve this 360-degree view of the customer?

A. Consolidate the data from each org into a centralized datastore

B. Use Salesforce Connect's cross-org adapter.

C. Build a bidirectional integration between all orgs.

D. Use an ETL tool to migrate gap Accounts and Contacts into each org.

Universal Containers is building a Salesforce application to track Contacts and the respective Conferences that they have attended with the following requirements:

1.

Contacts will be stored in the standard Contact object.

2.

Conferences will be stored in a custom Conference_ _c object.

3.

Each Contact may attend multiple Conferences and each Conference may be related to multiple Contacts.

How should a data architect model the relationship between the Contact and Conference_ _c objects?

A. Implement a Contact Conference junction object with master-detail relationships to both Contact and Conference_ _c.

B. Create a master-detail relationship field on the Conference_ _c object

C. Create a lookup relationship field on the Contact object.

D. Create a master-detail relationship field on the Contact object.

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 solution should a data architect recommend to resolve the complaints?

A. Build a nightly batch job to de-dupe data, and merge account records.

B. Integrate Salesforce with ERP, and make ERP as system of truth.

C. Build a nightly sync job from ERP to Salesforce.

D. Implement a de-dupe solution and establish account ownership in Salesforce