Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance issues and time-outs while running case reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?

• A.Create a custom object to store aggregate data and run reports.
• B.Move data off of the platform and run reporting outside Salesforce, and give access to reports.
• C.Contact Salesforce support to enable skinny table for cases.
• D.Build reports using custom Lightning components.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) stores 10 million rows of inventory data in a cloud database. As part of creating a connected experience in Salesforce, UC would like to expose this inventory data to Sales Cloud without a direct import. UC has asked its data architect to determine if Salesforce Connect is needed.
Which three considerations should the data architect make when evaluating the need for Salesforce Connect?
(Choose three.)

• A.You need to expose data via a virtual private connection.
• B.You need small amounts of external data at any one time.
• C.You have a large amount of data and would like to copy subsets of it into Salesforce.
• D.You have a large amount of data that you don't want to copy into your Salesforce org.
• E.You want real-time access to the latest data from other systems.

Comment: *

Name: *

Email: *

Verification: *

UC has a roll-up summary field on Account to calculate the count of contacts associated with an account.
During the account load, SF is throwing an "Unable to lock a row" error.
Which solution should a data architect recommend, to resolve the error?

• A.Leverage data loader platform API to load data.
• B.Perform Batch job in parallel mode and reduce Batch size
• C.Defer roll-up summary fields calculation during data migration.
• D.Perform Batch job in serial mode and reduce batch size

Comment: *

Name: *

Email: *

Verification: *

A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

• A.Use Salesforce Soap API in serial mode.
• B.Use Salesforce Bulk API in serial mode.
• C.Use Salesforce Bulk API in parallel mode.
• D.Use Salesforce Soap API in parallel mode.

Comment: *

Name: *

Email: *

Verification: *

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.Create one skinny table per report.
• B.Index key fields used in report criteria.
• C.Share each report with fewer users.
• D.Enable Divisions for large data objects.

Comment: *

Name: *

Email: *

Verification: *