Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.
What are two automated approaches to fulfill this goal? (Choose two.)

• A.Apex Triggers
• B.Schedulable Batch Apex
• C.Third-party Integration Tool (ETL)
• D.Third-party Business Intelligence system

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?

• A.Ensure the account product vendor includes Wave Analytics in their offering.
• B.Ensure the account product vendor provides a sound data archiving strategy.
• C.Ensure invoice line items simply reference existing Opportunity line items.
• D.Ensure the accounting product runs 100% natively on the Salesforce platform.

Comment: *

Name: *

Email: *

Verification: *

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 text field and make it an external ID.
• C.Create a Lookup to custom object ShippingStatus c.
• D.Create a Master -Detail to custom object ShippingStatus c.

Comment: *

Name: *

Email: *

Verification: *

UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.
Which 3 recommendations should a data architect provide to prevent ownership skew?
Choose 3 answers:

• A.Assigned a default user as owner of accounts, and assign role in hierarchy.
• B.Assign "view all" permission on profile to give access to account.
• C.Assign a default user as owner of account and do not assign any role to default user.
• D.Assign a default user as owner of accounts and assigned top most role in hierarchy.
• E.Keep users out of public groups that can be used as the source for sharing rules.

Comment: *

Name: *

Email: *

Verification: *

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

• A.Reduce the number of triggers on Order _c object.
• B.Make the queries more selective using indexed fields.
• C.Work with Salesforce Support to enable Skinny Tables.
• D.Use SOQL queries without WHERE conditions.

Comment: *

Name: *

Email: *

Verification: *