UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside 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 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 setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?

A.

Use the SOAP API to export data.

B.

Utilize the Bulk API to export the data.

C.

Use GZIP compression to export the data.

D.

Schedule a Batch Apex job to export the data.

Northern Trail Outfitters needs to implement an archive solution for Salesforce data. This archive solution needs to help NTO do the following:
1. Remove outdated Information not required on a day-to-day basis.
2. Improve Salesforce performance.
Which solution should be used to meet these requirements?

A.

Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,

B.

Identify a location to store archived data, and move data to the location using a time based workflow.

C.

Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.

D.

Create a full copy sandbox, and use it as a source for retaining archived data.

Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?

A.

Load all data using external IDs to link to parent records.

B.

Use workflow to calculate summary values instead of Roll -Up.

C.

Use triggers to calculate summary values instead of Roll -Up.

D.

Load all data after deferring sharing calculations.

Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

A.

Limitations on master -detail relationships.

B.

Org data storage limitations.

C.

Bulk API limitations on picklist fields.

D.

Standard list view in -line editing.

A large telecommunication provider that provides internet services to both residence and business has the following attributes:
A customer who purchases its services for their home will be created as an Account in Salesforce.
Individuals within the same house address will be created as Contact in Salesforce.
Businesses are created as Accounts in Salesforce.
Some of the customers have both services at their home and business.
What should a data architect recommend for a single view of these customers without creating multiple customer records?

A.

Customers are created as Contacts and related to Business and Residential Accounts using the Account Contact Relationships.

B.

Customers are created as Person Accounts and related to Business and Residential Accounts using the Account Contact relationship.

C.

Customer are created as individual objects and relate with Accounts for Business and Residence accounts.

D.

Costumers are created as Accounts for Residence Account and use Parent Account to relate Business Account.

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records. What should a data architect recommend in order to get around the time out issue?

A.

Use a custom auto number and formula field and use that to chunk records while extracting data.

B.

The REST API to extract data as it automatically chunks records by 200.

C.

Use ETL tool for extraction of records.

D.

Ask SF support to increase the query timeout value.

NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards. Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

A.

Define data duplication standards and rules

B.

Define key fields in staging database for data cleansing

C.

Measure data timeliness and consistency

D.

Finalize an extract transform load (ETL) tool for data migration

E.

Measure data completeness and accuracy

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.

Integrate with a third-party database or services for address validation and enrichment.

D.

Leverage Data.com Clean to clean up Account address fields with the D&B database.

What should a data architect do to provide additional guidance for users when they enter information in a standard field?

A.

Provide custom help text under field properties.

B.

Create a custom page with help text for user guidance.

C.

Add custom help text in default value for the field.

D.

Add a label field with help text adjacent to the custom field.