Northern Trail Outfitters (NTO) has an external product master system that syncs product and pricing information with Salesforce. Users have been complaining that they are seeing discrepancies in product and pricing information displayed on the NTO website and Salesforce. As a data architect, which action is recommended to avoid data sync issues?

A.

Build a custom integration for two-way sync of product and pricing information between product master to Salesforce.

B.

Build a custom integration for one-way sync of product and pricing information from product master to Salesforce.

C.

Implement a manual process to update the products from an extract from the products master on a weekly basis.

D.

Use the Customer 360 data manager to sync product and pricing information from product master database to Salesforce.

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

Which three characteristics of a Skinny table help improve report and query performance?

A.

Skinny tables can contain frequently used fields and thereby help avoid joins.

B.

Skinny tables can be used to create custom indexes on multi-select picklist fields.

C.

Skinny tables provide a view across multiple objects for easy access to combined data.

D.

Skinny tables are kept in sync with changes to data in the source tables.

E.

Skinny tables do not include records that are available in the recycle bin.

Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily. Which license type should a data architect recommend that best fits these requirements?

A.

Service Cloud

B.

Lightning platform Start

C.

Lightning Platform plus

D.

Lightning External Apps Starts

Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout. What is the fastest and most effective way for a data architect to solve the time-out issue?

A.

Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

B.

Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce

C.

Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.

D.

Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

UC has a variety of systems across its technology landscape, including SF, legacy enterprise resource planning (ERP) applications and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity and order data into Salesforce as part of its master data management (MDM) strategy. What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:

A.

Create new fields to store additional values from all the systems.

B.

Install a 3rd party AppExchange tool to handle the merger

C.

Analyze each system’s data model and perform gap analysis

D.

Utilize an ETL tool to merge, transform and de-duplicate data.

E.

Work with Stakeholders to define record and field survivorship rules

Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC. Which two common techniques are used building a data dictionary to store information on how business entities are defined?

A.

Use Salesforce Object Query Language.

B.

Use a data definition language.

C.

Use an entity relationship diagram.

D.

Use the Salesforce Metadata API.

Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

A.

Index key fields used in report criteria.

B.

Enable Divisions for large data objects.

C.

Create one skinny table per report.

D.

Share each report with fewer users.

Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers

A.

Engage with IT program managers to assess current velocity of projects in the pipeline.

B.

Engage with database administrators to assess current database performance metrics.

C.

Engage with executive sponsorship to assess enterprise data strategy and goals.

D.

Engage with business units and IT to assess current operational systems and data models.

Universal Containers has provided a web order form for its customer and has noticed invalid data coming in on orders. What should be used to mitigate this problem?

A.

Work Flow Rules

B.

Formatted Fields

C.

Apex Trigger

D.

Validation Rules