UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application. Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

A.

Use picklist fields rather than lookup to custom object.

B.

Limit assigning one user 10000 records ownership.

C.

Assign 10000 opportunities to one account.

D.

Limit associating 10000 opportunities to one account.

E.

Limit associating 10000 records looking up to same records.

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 Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?

A.

Query only indexed ID field values on the imported order to import related order lines.

B.

Leverage an External ID from source system orders to import related order lines.

C.

Leverage Batch Apex to update order ID on related order lines after import.

D.

Leverage a sequence of numbers on the imported orders to import related order lines.

Universal Containers has more than 10 million records in the Order_c object. The query has timed out when running a bulk query. What should be considered to resolve query timeout?

A.

Tooling API

B.

PK Chunking

C.

Metadata API

D.

Streaming API

UC has to built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the single source of truth for both customers and orders. UC has asked a data architect to replicate the data into salesforce so that salesforce can now act as the system of record. What are the 3 considerations that data architect should weigh before implementing this requirement? Choose 3 answers:

A.

Consider whether the data is required for sales reports, dashboards and KPI’s.

B.

Determine if the data is driver of key process implemented within salesforce.

C.

Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.

D.

Ensure the data is CRM center and able to populate standard of custom objects.

E.

A selection of the tool required to replicate the data.

F.

– Heroku Connect is required but this is confusing

Universal Containers (UC) is transitioning from Classic to Lightning Experience. What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

A.

Add Notes and Attachments Related List to page Layout in Lighting Experience.

B.

Manually upload Notes in Lighting Experience.

C.

Migrate Notes and Attachment to Enhanced Notes and Files a migration tool

D.

Manually upload Attachments in Lighting Experience.

North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly. Which two native tools should a data architect recommend to achieve this reporting requirement?

A.

Standard reports and dashboards

B.

Async SOQL with a custom object

C.

Standard SOQL queries

D.

Einstein Analytics

A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?

A.

Create formula fields with geolocation function for this requirement.

B.

Create custom fields to maintain latitude and longitude information

C.

Create a geolocation custom field to maintain this requirement

D.

Recommend app exchange packages to support this requirement.

What makes Skinny tables fast? Choose three answers.

A.

They do not include soft-deleted records

B.

They avoid resource intensive joins

C.

Their tables are kept in sync with their source tables when the source tables are modified

D.

They can contain fields from other objects

E.

They support up to a max of 100 of columns

Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers

A.

Make use of a third -party tool to help merge duplicate Contacts across Accounts.

B.

Use Data.com to standardize Contact address information to help identify duplicates.

C.

Use Workflow rules to standardize Contact information to identify and prevent duplicates.

D.

Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.

Universal containers is implementing Salesforce lead management. UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information?

A.

Ask sales people to search for populating company profile and location data

B.

Run reports to identify records which does not have company profile and location dat

C.

Leverage external data providers populate company profile and location data

D.

Export data out of Salesforce and send to another team to populate company profile and location data

Universal Containers has a custom object with millions of rows of data. When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

A.

Using leading % wildcards.

B.

Using trailing % wildcards.

C.

Performing large loads and deletions.

D.

Using NOT and != operators.

E.

Using a custom index on a deterministic formula field.